I have an RMAN script that keeps two copies of the backupset at all times. I have a space issue at the moment and I can only hold one backupset.
How do I get RMAN to delete all the backupsets first and then take a backup? Is there something I can do with the REDUNDANCY parameter? It would not let me set it to zero.
I am in Oracle 220.127.116.11 on Solaris. Here is my current RMAN script.
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = '$BKUPDIR/full_%d_%Y%M%D_%s';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$BKUPDIR/cf_%d_%F';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '$BKUPDIR/snapcf_@.f';
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
delete noprompt obsolete;
backup database plus archivelog delete input tag='$TAG';
06-16-2008, 01:09 PM
What happens when you do
RMAN> LIST EXPIRED BACKUPSET;
RMAN> DELETE EXPIRED BACKUPSET;
you can also do
DELETE OBSOLETE REDUNDANCY = 3 --->i see your redundancy is 1 but
06-17-2008, 01:17 AM
How about dynamically changing the retention policy to recovery windows, lesser than the days of retention before taking the backup, run the backup code, and then change it back to redundancy 1. Just a thought. Please let us know your output.