Oracle RMAN: failure diagnosis and backup check commands
RMAN commands to list failures, check backups and delete expired backups.
A cheat sheet of RMAN commands to diagnose a failure, check backups and clean up expired ones.
Diagnose and repair a failure
RMAN> LIST FAILURE;
RMAN> ADVISE FAILURE;
RMAN> REPAIR FAILURE;
LIST FAILURE shows the known failures, ADVISE FAILURE proposes a repair strategy and REPAIR FAILURE carries it out.
List and check backups
list backup summary;
list backup ;
crosscheck backup;
delete noprompt expired backup;
| Command | Effect |
|---|---|
list backup summary |
Summary of the backups |
list backup |
Detailed list of the backups |
crosscheck backup |
Checks that the pieces recorded in the catalog still exist; missing ones are marked EXPIRED |
delete noprompt expired backup |
Deletes without prompting the backups marked EXPIRED |