RE: deleting archive logs with rman
- From: Kenan "�zt�rk" <mynameiskenan@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 2 Jan 2008 02:00:19 -0800 (PST)
hmmm,
great thanks indeed.
"Kayaroganam, Arumugam (Customer Services, ICT - Solihull MBC)"
<akayaroganam@xxxxxxxxxxxxxxx> wrote: 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 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.'
**********************************************************************
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
Other related posts:
