Hi all,
I am taking over a database system and is now looking at its backup policy.
The system is running level 0 full backup every Monday and level 1 incremental cumulative on every other day. Both the full and incremental backup runs at 00:40am
The backup retention policy is set to 1 day.
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
Everyday, there is a script call "delete_obsolete.sh" that runs at very 00:25 am.
In the script, there are 3 lines following below
crosscheck backup;
delete noprompt expired backup;
delete obsolete until time 'sysdate-6';
q1) So I believe, with the "UNTIL TIME", it will overwrite the retention policy and only delete backup that are older then "sysdate - 6" - right ?
However in RMAN list summary, assuming today is 4/9/2015 (Friday) and the delete_obsolete.sh script is run at 00:25 hrs that day,
The script will actually delete backup that are older then sysdate - 6 which equates to 29-aug-15 00:25:00
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
2211797 B 0 A DISK 24-AUG-2015 02:55:04 2 1 YES SEC_FFF1_STBY_2NDRMAN_BACKUP
2211798 B 0 A DISK 24-AUG-2015 03:31:28 3 1 YES SEC_FFF1_STBY_2NDRMAN_BACKUP
2211799 B 0 A DISK 24-AUG-2015 03:53:10 3 1 YES SEC_FFF1_STBY_2NDRMAN_BACKUP
2217710 B 1 A DISK 28-AUG-2015 00:55:38 1 1 YES SEC_FFF1_STBY_2ND_LV1_BACKUP
2217711 B 1 A DISK 28-AUG-2015 00:56:51 1 1 YES SEC_FFF1_STBY_2ND_LV1_BACKUP
2217712 B 1 A DISK 28-AUG-2015 00:57:52 1 1 YES SEC_FFF1_STBY_2ND_LV1_BACKUP
2217713 B F A DISK 28-AUG-2015 00:58:15 1 1 NO TAG20150828T005753
2219520 B 1 A DISK 29-AUG-2015 00:56:23 1 1 YES SEC_FFF1_STBY_2ND_LV1_BACKUP
2219521 B 1 A DISK 29-AUG-2015 00:56:47 1 1 YES SEC_FFF1_STBY_2ND_LV1_BACKUP
2219522 B 1 A DISK 29-AUG-2015 00:57:56 1 1 YES SEC_FFF1_STBY_2ND_LV1_BACKUP
2219523 B F A DISK 29-AUG-2015 00:58:25 1 1 NO TAG20150829T005803
**q2) So if RMAN is told delete obsolete older then 29-aug-15 00:25:00, why is 28-Aug backup not deleted ?
q3) Is 24-Aug-15 backup not deleted because it is a level 0 and it is need to restore the 29-AUG-2015 lvl 1 backup which still does not fall under older then "29-Aug-2015 00:25:00" category
Regards,
Noob