Common RMAN commands

Common RMAN commands common rman commands crosscheckreportobsolete

1. SHOW command: 1.1, RMAN> show all; display rman parameter configuration 2. REPORT command: 2.1. RMAN> report schema the physical structure of the target database 2.2. RMAN> report need backup days = n; report data files not backed up in the last n days 2.3, RMAN> report need backup days n tablespace [name]; data Files not backed up for n days in the [name] tablespace 2.4, RMAN> report need backup incremental n; report that the number of incremental backups required for data file recovery exceeds n times. 2.5 of the data files, RMAN> report need backup redundancy n database; report all data files with less than n copies of the backup files RMAN> report need backup redundancy = n; 2.6, RMAN> report need backup recovery window of n days; data Files 2.7 and RMAN> report unrecoverable that require more than n days to restore the report file report; Reports 2.8 and RMAN> report obsolete redunndancy n of all unrecoverable data files in the database; 2.9 and RMAN> report obsolete of old backups with more than n times reported; 3. LIST command: list backup information 3.1, list data file backup sets RMAN> list backup list Detailed backup RMAN> list expired backup RMAN> list backup of database; list the backup sets of all data files. RMAN> list backup of tablespace [name]; list all data file backup sets for a specific tablespace 3.2, RMAN> list backup of controlfile list control file backup set 3.3, RMAN> list backup of archivelog all list archived log backup set details RMAN> list archivelog all; list brief information about archiving log backup sets 3.4, RMAN> list backup of spfile list SPFILE backup set 3.5, RMAN> list copy of datafile [file #] list copies of data files 3.6, RMAN> list copy of controlfile list control file image copies 3.7, RMAN> list copy of archivelog all list archive log image copies 3.8, RMAN> list incarnation of database list counterparts/list database copies 3.9, RMAN> list backup summary; overview AVAILABLE backup B indicates backup F indicates FULL A indicates archive log 0 1 indicates the Incremental backup level S indicates the backup status (A indicates AVAILABLE, X indicates EXPIRED) 3.10. RMAN> list backup by file: list backups (data files, archiving logs, control files, and server parameter files) by backup file type. 4. CROSSCHECK command: check backup information 4.1, RMAN> crosscheck backup check all backup sets 4.2, RMAN> crosscheck backup of database check all backup sets 4.3, RMAN> crosscheck backup of tablespace [name] Check specific tablespace backup set 4.4, RMAN> crosscheck backup of datafile [file #] Check the backup set of a specific data file 4.5, RMAN> crosscheck backup of controlfile check the backup set of the control file 4.6, RMAN> crosscheck backup spfile checks the SPFILE backup set 4.7 and RMAN> crosscheck backup of archivelog sequence [Seq] to check the backup set 4.8 and RMAN> crosscheck backup tag = [Tag] for specific archived logs. check the specific backup set 4.9, RMAN> crosscheck backup completed after [Completion] Verify the completed backup set RMAN> crosscheck backup completed between [Completion] and [Completion] 4.10, RMAN> crosscheck archivelog all; check the backup sets of all archived logs 4.11, RMAN> crosscheck archivelog like '% archivename' Check the backup sets of specific archived logs 4.12, RMAN> crosscheck archivelog from sequence [Seq]; 4.13. RMAN> crosscheck archivelog until sequence [Seq]; 4.14. RMAN> crosscheck backuppiece [BP Key]; check the specific backup file RMAN> crosscheck backuppiece [Piece Name]; 4.15. RMAN> crosscheck copy: Check all image copies. 4.16. RMAN> crosscheck copy of database: Check the image copies of all data files. 4.17. RMAN> crosscheck copy of tablespace [name]: Check the specific tablespace image copy 4.18, RMAN> crosscheck copy of datafile [file #] Check the image copy of a specific data file 4.19, RMAN> crosscheck copy of archivelog sequence [Seq] Check the image copy of the archive log 4.20, RMAN> crosscheck copy of controlfile check control file image copy 5, DELETE: delete backup 5.1, RMAN> delete obsolete; delete old backup 5.2, RMAN> delete expired backup; delete EXPIRED backup 5.3, RMAN> backup archivelog all delete input; delete the input object 5.4, RMAN> delete backupset [BP Key] After the backup; delete a specific backup set 5.5, RMAN> delete backuppiece [Piece Name] delete a specific backup set 5.6, RMAN> delete backup set delete all backup sets 5.7, RMAN> delete datafilecopy [path] delete a specific image copy 5.8, RMAN> delete copy delete all image copies