RE: deleting archive logs with rman
- From: "Kayaroganam, Arumugam \(Customer Services, ICT - Solihull MBC\)" <akayaroganam@xxxxxxxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Wed, 2 Jan 2008 09:56:52 -0000
Use this...
RMAN> create script DeleteArchiveSysdate
{allocate channel c5 type disk;
delete archivelog until time 'sysdate -3';
release channel c5;
resync catalog;}
---
RMAN> Create script CrossChkAll {
# Note:~ The below command run outside of a RUN block.
# allocate channel for maintenance type disk;
allocate channel c1 device type disk;
resync catalog;
crosscheck backup ;
crosscheck copy;
crosscheck archivelog all;
release channel c1;
}
Thanks,
- Aru.
-----Original Message-----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx]On Behalf Of Kenan "Öztürk
Sent: 02 January 2008 09:50
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: deleting archive logs with rman
Hi all,
is it possible to delete archive logs which are older than a given specific
time with RMAN??
similar linux/unix command as follows
find <directory>/*.arc -mtime +5 -exec rm {} \;
Regards,
Kenan
_____
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>
it now.
**********************************************************************
DISCLAIMER:
'This e-mail and files transmitted with it are confidential and intended solely
for the use of the individual to whom it is addressed. If you are not the
intended recipient please notify the sender immediately and delete the message.
Any views or opinions presented are solely those of the author and do not
necessarily represent those of Solihull Council unless explicitly stated
otherwise. Solihull Council may monitor the contents of e-mail sent and
received via its network for the purposes of ensuring compliance with its
policies and procedures.'
**********************************************************************
Other related posts:
