Wednesday, August 10, 2011

Difference Between OBSOLETE AND EXPIRED Backup


RMAN considers backups of datafiles and control files as obsolete, that is, no longer needed for recovery, according to criteria that we specify in the CONFIGURE command. We can then use the REPORT OBSOLETE  command to view obsolete files and DELETE OBSOLETE to delete them .
For ex  :  we set our retention policy to redundancy 2. this means we always want to keep at least 2 backup, after 2 backup, if we take an another backup oldest one become obsolete because there is 3 backup and we want to keep 2. if our flash recovery area is full then obsolete backups can be overwrite.

A status of "expired" means that the backup piece or backup set is not found in the backup destination or missing .Since backup info is hold in our controlfile and catalog . Our controlfile thinks that there is a backup under a directory with a name but someone delete this file from operating system. We can run crosscheck command to check if these files are exist and if rman found a file is missing then mark that backup record as expired which means is no more exists.


Enjoy   :-) 

11 comments:

Rashmi said...

Thanks for the info.

Anonymous said...

Thanks and Valuble information.


With Regards
Joseph

Dev Anand said...

Much Understandable. Explained So nicely..

NEERAJ VISHEN said...

Thanks Rashmi and Dev Anand .....

You most welcome !!!!!


Have Fun and Enjoy :)

Anonymous said...

Intrvew qstn thnks dear hehe
feroz khan :)

Unknown said...

Excellent mate

Imran said...

Thanks for the info....
Very useful

Unknown said...

As per http://www.dba-oracle.com/t_rman_delete_obsolete_remove_files.htm - Obsolete doesn't have anything to do with retention policy. It only marks a file OBSOLETE if it is not required for full database recovery.

Unknown said...

As per http://www.dba-oracle.com/t_rman_delete_obsolete_remove_files.htm - A file is obsolete only if it is not required for full database recovery. It has got nothing do with retention policy.

Unknown said...

If I have retention policy redundancy to 7 and I want delete archives older than 7 days in ASM archive destination which command i have to use in RMAN DELETE OBSOLETE OR DELETE EXPIRED ARCHIVELOG ALL?

Unknown said...

If I have retention policy to redundancy 7 and if I want to delete archives older than 7 days in ASM archive destination eg:+DATA/ORCL/ARCHIVELOG/ HERE I WANT KEEP ONLY 7 DAYS ARCHIVES WHICH ONE I HAVE TO USE IN RMAN SCRIPT DELETE OBSOLETE OR DELETE EXPIRED ARCHIVELOG ALL;