Stand Alone Commands

• REPORT Command:

RMAN> report schema;

RMAN> report need backup;

RMAN> report need backup redundancy 2;

RMAN> report need backup recovery window of 3 days;

• LIST Command:

RMAN>list backup;

RMAN>list backup of tablespace users;

RMAN>list backup of datafile 4;

RMAN>list copy of datafile 4;

RMAN>list backup of database;

RMAN>list archivelog all;

RMAN>list backup of archivelog all;

• DELETE Command:

RMAN> delete backup;

RMAN> delete backup of archivelog all;

RMAN> delete backup of datafile 5;

RMAN> delete backupset 1;

• CROSS CHECK Commands:

RMAN> crosscheck archivelog all;

RMAN> crosscheck backup;

• EXPIRED BACKUP:

RMAN> list expired archivelog all;

RMAN> list expired backup;

• OBSOLETE BACKUPS:

RMAN> report obsolete;

RMAN> delete obsolete;

• BACKUP COMMANDS

RMAN> backup datafile 5,6,7;

RMAN> backup tablespace mumbai;

RMAN> backup database;

RMAN> backup datafile 5 tag='chicken';

RMAN> backup tag 'vivek' datafile 1,4,6;

RMAN> list backup tag='vivek';

RMAN> delete backupset tag 'vivek';

-----------------------------------------------------

RMAN> backup incremental level 0 database;

RMAN> backup incremental level 0 tablespace mumbai;

RMAN> backup tag 'sqlstar' incremental level 0 datafile 7;

RMAN> backup incremental level 1 tablespace mumbai;

RMAN> backup incremental level 1 database;

RMAN> backup tag 'starsql' incremental level 1 tablespace mumbai;

RMAN> backup incremental level 1 cumulative database;

RMAN> backup incremental level 1 cumulative tablespace mumbai;

RMAN> backup tag 'vivek' incremental level 1 cumulative datafile 6;