RMAN Check-List

1. How to synchronize Archivelog if it has been deleted through OS
RMAN-03002: failure of backup command
RMAN-06059:expected archived

If archivelogs have been deleted through the OS, RMAN can be used to re-synchronized using following command

RMAN target /
RMAN>allocate channel for maintenance type disk;
RMAN>crosscheck archivelog all;


2. How to delete Expired Archivelog files
Below commands can be used to delete expired archivelog files through RMAN

RMAN>list expired archivelog all;

RMAN>crosscheck archivelog all;

RMAN>delete noprompt expired archivelog all;


3. Delete arhivelog based on log sequence number
RMAN Target /
RMAN>allocate channel for maintenance type isk;
RMAN>delete archivelog from logseq=<start number> until logseq=<end number>;


4. Crosscheck command in RMAN to validate backup

RMAN Target /
RMAN>crosscheck backup of database;
RMAN>crosscheck backup of archivelog all;
RMAN>crosscheck backup of controlfile;


5. Use No Prompt in RMAN to avoid being prompted for each file before delete
RMAN>delete noprompt expired archivelog all;

6. List archivelog based on sequence  and time
RMAN>list archivelog until time "sysdate-1";
RMAN>list archivelog from time "sysdate-30";
RMAN>list archivelog from time "sysdate-7" until time "sysdate-10";
RMAN>list archivelog from sequence 10000;
RMAN>list archivelog until sequence 10000;
RMAN>list archivelog from sequence 10000 until sequence 12000;

7. Delete archivelog based on sequence  and time
RMAN>delete archivelog until time "sysdate-1";
RMAN>delete archivelog from time "sysdate-30";
RMAN>delete archivelog from time "sysdate-7" until time "sysdate-10";
RMAN>delete archivelog from sequence 10000;
RMAN>delete archivelog until sequence 10000;
RMAN>delete archivelog from sequence 10000 until sequence 12000;