LLI Wiki — My Digital Knowledge Base

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

Further reading

Mastodon LLIMastodon SocialFosstodon