RE: 11g RMAN backup archive logs, delete options
Date: Wed, 18 May 2011 19:39:11 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD305B699_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
I think I figured it out- at least on 11gR1 this policy is valid-
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO DEVICE TYPE DISK APPLIED ON ALL STANDBY; Then I can run a delete archivelog all completed before 'sysdate -7';
From: CRISLER, JON A (ATTCORP)
Sent: Wednesday, May 18, 2011 3:12 PM
To: oracle-l_at_freelists.org
Subject: 11g RMAN backup archive logs, delete options
I want to combine the functions of deleting archive logs based on date AND that they have been backed up already. Is this possible ?
For instance this will delete all the archive logs backed up (regulated by rman archive log deletion policy)
Run {
backup as compressed backupset
archivelog all
delete all input;
}
This would delete archive logs-
delete archivelog all completed before 'sysdate -7';
What I am looking for is deleting them based on date, and that they have been backed up.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 18 2011 - 14:39:11 CDT