RE: 11g RMAN backup archive logs, delete options

  • From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
  • To: "'JC1706@xxxxxxx'" <JC1706@xxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 18 May 2011 15:19:29 -0400

it would be something like the following:

delete archivelog until time 'sysdate - 7' backed up 1 times to device type 
disk;  [or  "device type sbt" in case of tape]

Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106



________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of CRISLER, JON A (ATTCORP)
Sent: Wednesday, May 18, 2011 3:12 PM
To: oracle-l@xxxxxxxxxxxxx
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.

NOTICE: Confidential message which may be privileged. Unauthorized 
use/disclosure prohibited. If received in error, please go to www.td.com/legal 
for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié. 
Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière 
d'aller au www.td.com/francais/avis_juridique pour des instructions.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2011