Hi All,
I've a situation where I don't understand why some archivelogs don't get cleaned up.
For the moment I've the following situation
RMAN config:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 6 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '//NAS/bckup';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\PRODUCT\11.2.0\IMPAXAGILITY_DB\DATABASE\SNCFAPROD.ORA'; # default
log_archive_dest_1 LOCATION=F:\ORACLE\ORAARCH
1. removed all my backups... to start all over again with a fresh situation
2. Took a L1 backup (which will be a L0 since there doesn't exists a previous L0)
ALLOCATE CHANNEL C1 TYPE DISK;
BACKUP INCREMENTAL LEVEL 1 TAG "DAILY_INCR_BACKUP" DATABASE PLUS ARCHIVELOG;
BACKUP AS COPY CURRENT CONTROLFILE REUSE;
BACKUP SPFILE REUSE;
3. After the successfull backup it run a cleanup script
ALLOCATE CHANNEL C1 TYPE DISK;
CROSSCHECK BACKUP;
CROSSCHECK BACKUPSET;
CROSSCHECK ARCHIVELOG ALL;
CROSSCHECK DATAFILECOPY ALL;
DELETE NOPROMPT OBSOLETE;
DELETE NOPROMPT EXPIRED BACKUP;
4. In this cleanup step (delete obsolete) RMAN didn't identify any archivelog as obsolete while a 'list archivelog all' returns archivelogs from 12jan2014 (while today its 15march2014)
So my question(s)
- Why didn't RMAN delete my old archive logs?
- How can i check which archivelogs will be deleted from filesystem by RMAN?
Kind Regards,