Monday, April 8, 2013

Cross checking archive logs


In Oracle 10g you can run the following command to crosscheck and expire any expired archive logs:

Example for Oracle 10g use:

RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;

However in Oracle 8 and 9 you need to do the following

Example for Oracle 8 use:
RMAN> Change Archivelog All Validate;

Example for Oracle 8i use:
RMAN> change Archivelog All Crosscheck;

Example for Oracle 9i:RMAN> crosscheck archivelog all;


Deleting archives alredy backed up

DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;

No comments:

Post a Comment