Search This Blog

Monday, April 4, 2011

Deleting Expired RMAN Backups and Archives Logs after CROSSCHECK

export ORACLE_SID= (UNIX)
or
set
ORACLE_SID=
RMAN TARGET / catalog rman/rman@rman cmdfile=C:\cleanObsoleteArchives\clean.rman

clean.rman
=============
change archivelog all crosscheck;
crosscheck backupset ;
DELETE EXPIRED BACKUP;
crosscheck archivelog all;
delete noprompt obsolete;
restore validate database;
list backup;
exit;


Ref: http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/maint003.htm#i1008500