Friday, December 28, 2012

RMAN delete commands

rosscheck backup of database
completed between 'SYSDATE' and 'SYSDATE-30';

When you are deleting backups ensure that you don't use OS commands to do so.

For deleting expired backups of previous week type the following

RMAN>DELETE EXPIRED BACKUP COMPLETED BEFORE SYSDATE-7

and for deleting backups completed before 7 days type

RMAN>DELETE BACKUP COMPLETED BEFORE SYSDATE-7

Don't use the OS utilites to maintain the backups.