RMAN Command cheat sheet

RMAN> list backupset;

RMAN> list backupset of database;

RMAN> list backupset of database completed before '22-NOV-00';

RMAN> list backupset of archivelog all;

RMAN> list backupset of tablespace users;

RMAN> list backupset of datafile 1;

RMAN> list backup summary;

RMAN> list backup;

RMAN> list backup of controlfile;

RMAN> list backup of tablespace SYSTEM;

RMAN> list backup by file;

RMAN> list backup of archivelog all ;

RMAN> list copy of database;

RMAN> list copy of database archivelog all;

RMAN> allocate channel for maintenance type disk;

RMAN> configure channel device type disk clear ;

RMAN> report need backup days=2 database;

RMAN> report need backup days=10 tablespace TEMP;

RMAN> report need backup days=4 datafile 'D:\ORACLE\ORADATA\OR816\TEMP01.DBF';

RMAN> report schema;

RMAN> report obsolete;

RMAN> crosscheck backup;

RMAN> crosscheck backupset;

RMAN> crosscheck copy;

RMAN> crosscheck archivelog all;

RMAN> crosscheck controlfilecopy '/ora01/oracle/admin/BACKUP/demo/demo_controlfile_bak_03-15-11_19:59:11' ;

RMAN> delete noprompt expired backup ;

RMAN> delete noprompt obsolete;

RMAN> delete archivelog all;

RMAN> delete expired archivelog all;

RMAN> delete archivelog all completed before 'sysdate -1';

RMAN> delete noprompt archivelog until time 'sysdate - 1';

RMAN> delete archivelog all backed up 1 times to device type disk completed before 'sysdate-1';

I hope this article helped you. Your suggestions/feedback are most welcome.

Keep learning... Have a great day!!!