Saturday, September 18, 2010

RMAN how to delete archives?

allocate channel for maintenance type disk;
delete archivelog until time "sysdate - 1/24";
change archivelog all crosscheck;
CHANGE ARCHIVELOG all VALIDATE ;

OR

allocate channel for maintenance type disk;
delete archivelog until time "sysdate - 1";
change archivelog all crosscheck;
CHANGE ARCHIVELOG all VALIDATE ;

OR

allocate channel for maintenance type disk;
delete archivelog until sequence 683;
change archivelog all crosscheck;
CHANGE ARCHIVELOG all VALIDATE ;

No comments:

Post a Comment