RMAN Quick Reference
-- List backups
list backup;

-- Delete obsolete backups
delete obsolete;
DELETE OBSOLETE RECOVERY WINDOW OF 7 DAYS;
DELETE OBSOLETE REDUNDANCY = 3;
DELETE EXPIRED ARCHIVELOG ALL;

-- Show configuration
show all;

-- Crosscheck 
CROSSCHECK BACKUP;
CROSSCHECK ARCHIVELOG ALL;


-- Catalog backups
-- Cataloging Files in the Flash Recovery Area
CATALOG RECOVERY AREA NOPROMPT;

-- Catalog the backup pieces held in the location set for db_recovery_file_dest parameter:
catalog db_recovery_file_dest;

-- archived logs
CATALOG ARCHIVELOG '?/oradata/archive1_30.dbf', '?/oradata/archive1_31.dbf', '?/oradata/archive1_32.dbf';

-- backup pieces
CATALOG BACKUPPIECE '?/oradata/01dmsbj4_1_1.bcp';