Dear Tom,
I have a problem where my Rman jobs (Level 1 Differential, Level 1 Cumulative, or Level 0) have a DELETE OBSOLETE NOPROMPT as the last command in a run block - the command does indeed DELETE from the CATALOG as I'd expect based upon a Recovery Window of 15 Days BUT it does not DELETE the file from DISK ( it does DELETE from the Recovery Area on disk, BUT it does NOT from the NFS disk device). Those backupsets on NFS are created from "backup recovery area to destination '/bkup'.
The RMan job run from OEM (12c) and the databases are all 12.1.0.2 - the OEM job runs against 3 database targets (all RAC, each of which have 2 instances running), and at the same time. All targets generally completed within 30 seconds to 1 minute of each other.
Here is a copy of the script and I will attach a copy of the log generated by the "DELETE NOPROMPT OBSOLETE" command. The attachment will also show clearly the files that still exist on disk - those are dated from February 29 through March 3, 2016. Interestingly enough, is that the disk files and directory for /bkup/PEMART/backupset/2016_03_04, /bkup/PEMART/backupset/2016_03_05, and /bkup/PEMART/backupset/2016_03_06 have been deleted as expected.
set echo on;
set encryption on for all tablespaces algorithm 'AES128' identified by '<pwd here>' only;
RUN {
select inst_id,status from gv$instance;
report schema;
alter database backup controlfile to trace;
create pfile from spfile;
backup check logical incremental level 1 database plus archivelog not backed up 2 times;
}
RUN {
backup recovery area to destination '/bkup/';
}
RUN {
DELETE NOPROMPT archivelog all completed before 'sysdate-1';
}
RUN {
DELETE NOPROMPT OBSOLETE;
}
EXIT
A little backupground information is that a Level 0 Backup is run on a weekly basis just after midnight on Monday morning. The Recovery Window is 15 Days and the Control_File_Record_Keep_Time is 23 Days to accommodate the Recovery Window of 15 Days. Archive Log Backups are run periodically and Level1 Differential and Level1 Cumulative on an alternating dailiy basis.
Any insight to this would be GREATLY appreciated.
MANY THANKS,
Mike
Hmmm....I tried to reproduce (I'm on 11.2.0.4) and could not.
I did the following test:
3 executions of:
backup database plus archivelog;
backup recovery area to destination 'D:\oracle\nfsbkp';
with the default settings of redundancy 1. Both the flash recov dest and the "nfs" secondary backup, are just local destinations on my laptop.
So then I checked on obsolete backups
RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1 22-MAR-16
Backup Piece 1 22-MAR-16 D:\ORACLE\BKP\DB11_01R142PJ_1_1
Archive Log 1 18-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_18\O1_MF_1_322_CK8CXB08_.ARC
Backup Set 2 22-MAR-16
Backup Piece 2 22-MAR-16 D:\ORACLE\BKP\DB11_02R142R0_1_1
Archive Log 2 18-APR-16 D:\ORACLE\BKP\DB11\ALTERNATE\DB11\ARCHIVELOG\2016_04_18\O1_MF_1_323_CK8D0GDW_.ARC
Archive Log 3 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_324_CKFT2BO0_.ARC
Archive Log 4 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_325_CKGOLOLT_.ARC
Backup Set 3 20-APR-16
Backup Piece 8 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181342_CKGOQZ6H_.BKP
Backup Set 3 20-APR-16
Backup Piece 3 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181342_CKGOLP95_.BKP
Archive Log 5 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_326_CKGON4VQ_.ARC
Backup Set 4 20-APR-16
Backup Piece 4 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_NNNDF_TAG20160420T181343_CKGOLQV4_.BKP
Backup Set 4 20-APR-16
Backup Piece 9 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NNNDF_TAG20160420T181343_CKGOR294_.BKP
Backup Set 5 20-APR-16
Backup Piece 10 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181428_CKGOSHCG_.BKP
Backup Set 5 20-APR-16
Backup Piece 5 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181428_CKGON513_.BKP
Backup Set 6 20-APR-16
Backup Piece 11 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181430_CKGOSJFC_.BKP
Backup Set 6 20-APR-16
Backup Piece 6 20-APR-16 D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909684870_CKGON6BT_.BKP
Backup Set 7 20-APR-16
Backup Piece 7 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181630_CKGOQY3W_.BKP
Archive Log 6 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_327_CKGOT5Y0_.ARC
Backup Set 8 20-APR-16
Backup Piece 12 20-APR-16 D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909685041_CKGOSKTD_.BKP
Backup Set 8 20-APR-16
Backup Piece 18 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181721_CKGOVRJT_.BKP
Backup Set 9 20-APR-16
Backup Piece 19 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181742_CKGOVSLR_.BKP
Backup Set 9 20-APR-16
Backup Piece 13 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181742_CKGOT64P_.BKP
Backup Set 12 20-APR-16
Backup Piece 16 20-APR-16 D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909685109_CKGOVP3C_.BKP
Backup Set 12 20-APR-16
Backup Piece 22 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181829_CKGOXBSJ_.BKP
So far, so good. The base backups are obsolete as are the secondary backups to my "nfs" location. So then I run the delete command
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1 22-MAR-16
Backup Piece 1 22-MAR-16 D:\ORACLE\BKP\DB11_01R142PJ_1_1
Archive Log 1 18-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_18\O1_MF_1_322_CK8CXB08_.ARC
Backup Set 2 22-MAR-16
Backup Piece 2 22-MAR-16 D:\ORACLE\BKP\DB11_02R142R0_1_1
Archive Log 2 18-APR-16 D:\ORACLE\BKP\DB11\ALTERNATE\DB11\ARCHIVELOG\2016_04_18\O1_MF_1_323_CK8D0GDW_.ARC
Archive Log 3 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_324_CKFT2BO0_.ARC
Archive Log 4 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_325_CKGOLOLT_.ARC
Backup Set 3 20-APR-16
Backup Piece 8 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181342_CKGOQZ6H_.BKP
Backup Set 3 20-APR-16
Backup Piece 3 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181342_CKGOLP95_.BKP
Archive Log 5 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_326_CKGON4VQ_.ARC
Backup Set 4 20-APR-16
Backup Piece 4 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_NNNDF_TAG20160420T181343_CKGOLQV4_.BKP
Backup Set 4 20-APR-16
Backup Piece 9 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NNNDF_TAG20160420T181343_CKGOR294_.BKP
Backup Set 5 20-APR-16
Backup Piece 10 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181428_CKGOSHCG_.BKP
Backup Set 5 20-APR-16
Backup Piece 5 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181428_CKGON513_.BKP
Backup Set 6 20-APR-16
Backup Piece 11 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181430_CKGOSJFC_.BKP
Backup Set 6 20-APR-16
Backup Piece 6 20-APR-16 D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909684870_CKGON6BT_.BKP
Backup Set 7 20-APR-16
Backup Piece 7 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181630_CKGOQY3W_.BKP
Archive Log 6 20-APR-16 D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_327_CKGOT5Y0_.ARC
Backup Set 8 20-APR-16
Backup Piece 12 20-APR-16 D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909685041_CKGOSKTD_.BKP
Backup Set 8 20-APR-16
Backup Piece 18 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181721_CKGOVRJT_.BKP
Backup Set 9 20-APR-16
Backup Piece 19 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181742_CKGOVSLR_.BKP
Backup Set 9 20-APR-16
Backup Piece 13 20-APR-16 D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181742_CKGOT64P_.BKP
Backup Set 12 20-APR-16
Backup Piece 16 20-APR-16 D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909685109_CKGOVP3C_.BKP
Backup Set 12 20-APR-16
Backup Piece 22 20-APR-16 D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181829_CKGOXBSJ_.BKP
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11_01R142PJ_1_1 RECID=1 STAMP=907152179
deleted archived log
archived log file name=D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_18\O1_MF_1_322_CK8CXB08_.ARC RECID=1 STAMP=909478314
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11_02R142R0_1_1 RECID=2 STAMP=907152225
deleted archived log
archived log file name=D:\ORACLE\BKP\DB11\ALTERNATE\DB11\ARCHIVELOG\2016_04_18\O1_MF_1_323_CK8D0GDW_.ARC RECID=2 STAMP=909478414
deleted archived log
archived log file name=D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_324_CKFT2BO0_.ARC RECID=3 STAMP=909656650
deleted archived log
archived log file name=D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_325_CKGOLOLT_.ARC RECID=4 STAMP=909684821
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181342_CKGOQZ6H_.BKP RECID=8 STAMP=909684991
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181342_CKGOLP95_.BKP RECID=3 STAMP=909684822
deleted archived log
archived log file name=D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_326_CKGON4VQ_.ARC RECID=5 STAMP=909684868
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_NNNDF_TAG20160420T181343_CKGOLQV4_.BKP RECID=4 STAMP=909684823
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NNNDF_TAG20160420T181343_CKGOR294_.BKP RECID=9 STAMP=909684994
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181428_CKGOSHCG_.BKP RECID=10 STAMP=909685039
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181428_CKGON513_.BKP RECID=5 STAMP=909684869
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181430_CKGOSJFC_.BKP RECID=11 STAMP=909685040
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909684870_CKGON6BT_.BKP RECID=6 STAMP=909684870
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181630_CKGOQY3W_.BKP RECID=7 STAMP=909684990
deleted archived log
archived log file name=D:\ORACLE\BKP\DB11\DB11\ARCHIVELOG\2016_04_20\O1_MF_1_327_CKGOT5Y0_.ARC RECID=6 STAMP=909685061
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909685041_CKGOSKTD_.BKP RECID=12 STAMP=909685041
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181721_CKGOVRJT_.BKP RECID=18 STAMP=909685112
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181742_CKGOVSLR_.BKP RECID=19 STAMP=909685113
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11\DB11\BACKUPSET\2016_04_20\O1_MF_ANNNN_TAG20160420T181742_CKGOT64P_.BKP RECID=13 STAMP=909685062
deleted backup piece
backup piece handle=D:\ORACLE\BKP\DB11\DB11\AUTOBACKUP\2016_04_20\O1_MF_S_909685109_CKGOVP3C_.BKP RECID=16 STAMP=909685110
deleted backup piece
backup piece handle=D:\ORACLE\NFSBKP\DB11\BACKUPSET\2016_04_20\O1_MF_NCSNF_TAG20160420T181829_CKGOXBSJ_.BKP RECID=22 STAMP=909685162
Deleted 23 objects
and when I check on the OS, the files are indeed gone.
I know that doesn't help *you* much :-) but I'd perhaps try
1) create a small database with basic redundancy of 1, and repeat my test above on your environment (both destinations local disk). See if the delete works as expected
2) then repeat with the secondary destination being on your true nfs share. See if the delete works as expected.
If either dont work, then you've got a basic test case for Support.
If they both *do* work, then at least you know it *can* work on your setup - then its case of slowing increasing the "realism" of your test case to more closely match your environment.
Hope this helps.