1. SHOW Command:
Display RMAN configuration: RMAN> show all;
2. REPORT Command:
2.1、RMAN> report schema Report the physical structure of the target database;
2.2、RMAN>report need backup days=3; Report datafiles that have not been backed up in the last 3 days;
2.3、RMAN> report need backup days 3 tablespace users; Datafiles in the USERS tablespace not backed up for 3 days;
2.4、RMAN> report need backup incremental 3; Report datafiles requiring more than 3 incremental backups for recovery;
2.5、RMAN> report need backup redundancy 2 database; Report all datafiles with fewer than 2 backup copies;
RMAN>report need backup redundancy=2;
2.6、RMAN> report need backup recovery window of 6 days; Report datafiles requiring more than 6 days of archived logs for recovery;
2.7、RMAN> report unrecoverable; Report all unrecoverable datafiles in the database;
2.8、RMAN> report obsolete redunndancy 2; Report obsolete backups with more than 2 backup copies;
2.9、RMAN>report obsolete; Report redundant backups;
3. LIST Command: List Backup Information
3.1、List Datafile Backup Sets
RMAN>list backup List detailed backups;
RMAN>list expired backup List expired backups;
RMAN> list backup of database; List backup sets for all datafiles;
RMAN> list backup of tablespace user01; List all datafile backup sets for a specific tablespace;
3.2、RMAN> list backup of controlfile List control file backup sets;
3.3、RMAN> list backup of archivelog all List detailed information for archived log backup sets;
RMAN>list archivelog all; List summary information for archived log backup sets
3.4、RMAN> list backup of spfile List SPFILE backup sets;
3.5、RMAN> list copy of datafile 5 List datafile image copies;
3.6、RMAN> list copy of controlfile List control file image copies;
3.7、RMAN> list copy of archivelog all List archived log image copies;
3.8、RMAN> list incarnation of database List database incarnations/copies;
3.9、RMAN>list backup summary; Summarize available backups;
B indicates backup
F indicates FULL
A indicates archive log
0 1 indicates incremental backup
S indicates backup status (A AVAILABLE X EXPIRED )
3.10、RMAN>list backup by file List backups by type;
Lists by datafile backup, archived log backup, control file backup, and server parameter file backup
4. CROSSCHECK Command: Verify Backup Information
4.1、RMAN> crosscheck backup Crosscheck all backup sets;
4.2、RMAN> crosscheck backup of database Crosscheck backup sets for all datafiles;
4.3、RMAN> crosscheck backup of tablespace users Crosscheck backup sets for a specific tablespace;
4.4、RMAN> crosscheck backup of datafile 4 Crosscheck backup sets for a specific datafile;
4.5、RMAN> crosscheck backup of controlfile Crosscheck backup sets for the control file;
4.6、RMAN> crosscheck backup of spfile Crosscheck backup sets for the SPFILE;
4.7、RMAN> crosscheck backup of archivelog sequence 3 Crosscheck backup sets for archived logs;
4.8、RMAN> crosscheck copy Crosscheck all image copies;
4.9、RMAN> crosscheck copy of database Crosscheck image copies for all datafiles;
4.10、RMAN> crosscheck copy of tablespace users Crosscheck image copies for a specific tablespace;
4.11、RMAN> crosscheck copy of datafile 6 Crosscheck image copies for a specific datafile;
4.12、RMAN> crosscheck copy of archivelog sequence 4 Crosscheck image copies for archived logs;
4.13、RMAN> crosscheck copy of controlfile Crosscheck image copies for the control file;
4.14、RMAN> crosscheck backup tag='SAT_BACKUP';
4.15、RMAN> crosscheck backup completed after 'sysdate – 2'
4.16、RMAN> crosscheck backup completed between 'sysdate – 5' and 'sysdate -2 '
4.17、RMAN> crosscheck backup device type sBT;
4.18、RMAN> crosscheck archivelog all;
4.19、RMAN> crosscheck archivelog like '%ARC00012.001'
4.20、RMAN> crosscheck archivelog from sequence 12;
4.21、RMAN> crosscheck archivelog until sequence 522;
5. DELETE: Delete Backups
5.1、RMAN> delete obsolete; Delete obsolete backups;
5.2、RMAN> delete expired backup; Delete EXPIRED backups
5.3、RMAN> delete expired copy; Delete EXPIRED copies;
5.4、RMAN> delete backupset 19; Delete a specific backup set;
5.5、RMAN> delete backuppiece ''d:/backup/DEMO_19.bak'' Delete a specific backup piece;
5.6、RMAN> delete backup Delete all backup sets;
5.7、RMAN> delete datafilecopy ''d:/backup/DEMO_19.bak'' Delete a specific image copy;
5.8、RMAN> delete copy Delete all image copies;
5.9、RMAN> delete archivelog all delete input;
RMAN> delete backupset 22 format = ''d:/backup/%u.bak'' delete input
Delete input objects after backing up;
5.10、RMAN> delete backupset id; Delete backup set