Hi all,
I run Incremental Backup level 0 everyday, so that means i have full backup everyday.
I set the recovery window to 3 days.
What i don't understand is RMAN doesn't think my backup of archivelog obsolete.
Please see below
RMAN> list backup summary;
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
11483 B A A DISK 01-APR-10 1 1 YES ARCHIVELOGBACKUP
11502 B A A DISK 02-APR-10 1 1 YES ARCHIVELOGBACKUP
11521 B A A DISK 03-APR-10 1 1 YES ARCHIVELOGBACKUP
11540 B A A DISK 04-APR-10 1 1 YES ARCHIVELOGBACKUP
11559 B A A DISK 05-APR-10 1 1 YES ARCHIVELOGBACKUP
11578 B A A DISK 06-APR-10 1 1 YES ARCHIVELOGBACKUP
..
..
.. so on
So as you can see, i have backup of archive log dated 1 APR to 06 April and up to the current date (not shown but it's there).
BUT, you will see it's not reported below.
RMAN> report obsolete
2> ;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 3 days
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 11585 07-APR-10
Backup Piece 13479 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs8tyw0_.bkp
Backup Set 11586 07-APR-10
Backup Piece 13480 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs8xn0c_.bkp
Backup Set 11587 07-APR-10
Backup Piece 13481 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs8zcj3_.bkp
Backup Set 11588 07-APR-10
Backup Piece 13482 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs90h2h_.bkp
Backup Set 11589 07-APR-10
Backup Piece 13483 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs9188b_.bkp
Backup Set 11590 07-APR-10
Backup Piece 13484 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs921jw_.bkp
Backup Set 11591 07-APR-10
Backup Piece 13485 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs92jvd_.bkp
Backup Set 11592 07-APR-10
Backup Piece 13486 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs94820_.bkp
Backup Set 11593 07-APR-10
Backup Piece 13487 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs951by_.bkp
Backup Set 11594 07-APR-10
Backup Piece 13488 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs96hjn_.bkp
Backup Set 11595 07-APR-10
Backup Piece 13489 07-APR-10 /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_nnnd0_DB_BACKUP_LEVEL0_5vs97lck_.bkp
Backup Set 11599 07-APR-10
Backup Piece 13493 07-APR-10 /oradump/flash_recovery_area/MYDB/autobackup/2010_04_07/o1_mf_s_715735968_5vs9f0qq_.bkp
Backup Set 11615 08-APR-10
Backup Piece 13510 08-APR-10 /oradump/flash_recovery_area/MYDB/autobackup/2010_04_08/o1_mf_s_715822279_5vvxp807_.bkp
Control File Copy 857 08-APR-10 /oradump/flash_recovery_area/MYDB/controlfile/o1_mf_TAG20100408T233329_5vvxt95x_.ctl
Backup Set 11617 08-APR-10
Backup Piece 13512 08-APR-10 /oradump/flash_recovery_area/MYDB/autobackup/2010_04_08/o1_mf_s_715822379_5vvxscl4_.bkp
Could anyone enlighten me why the archivelog backups are not reported obsolete?
Another thing is, when i ran the following, why don't the condition 'sysdate-3' be satisfied?
It's showing my backup until the current date, where i actually want to delete only old backup up to current day - 3.
RMAN> delete backup of archivelog until time='sysdate-3';
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
13371 11483 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_01/o1_mf_annnn_ARCHIVELOGBACKUP_5v9h14l4_.bkp
13391 11502 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_02/o1_mf_annnn_ARCHIVELOGBACKUP_5vd3f6d7_.bkp
13411 11521 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_03/o1_mf_annnn_ARCHIVELOGBACKUP_5vgqnqwp_.bkp
13431 11540 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_04/o1_mf_annnn_ARCHIVELOGBACKUP_5vkckhvv_.bkp
13451 11559 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_05/o1_mf_annnn_ARCHIVELOGBACKUP_5vn0fssp_.bkp
13471 11578 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_06/o1_mf_annnn_ARCHIVELOGBACKUP_5vpo0q6v_.bkp
13491 11597 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_07/o1_mf_annnn_ARCHIVELOGBACKUP_5vs99d73_.bkp
13511 11616 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_08/o1_mf_annnn_ARCHIVELOGBACKUP_5vvxpp2q_.bkp
13531 11635 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_09/o1_mf_annnn_ARCHIVELOGBACKUP_5vykzvc2_.bkp
13551 11654 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_10/o1_mf_annnn_ARCHIVELOGBACKUP_5w16bzp4_.bkp
13571 11673 1 1 AVAILABLE DISK /oradump/flash_recovery_area/MYDB/backupset/2010_04_11/o1_mf_annnn_ARCHIVELOGBACKUP_5w3t5rwv_.bkp
I am a little confused here, hope someone can enlighten me here.
Thanks
-Joel