Detailed description of the cross check command under RMAN

Rman crosscheck command details in the use of delete obsolete command to DELETE the OBSOLETE backup file, if the following error occurs (RMAN-06207 & RMAN-06208), then you need to use the CROSSCHECK command to solve: RMAN-06207: WARNING: 2 objects cocould not be deleted for DISK channel (s) dueRMAN-06208: to mismatched status. use CROSSCHECK command to fix status CROSSCHECK to check the backup file to ensure that the RMAN database is synchronized with the backup file. When you execute this command, if the status recorded in the RMAN database does not match the actual backup file, the status in the database will be updated to make it consistent with the actual backup file status; if the backup file is in the expired status, it indicates that the backup has expired and can be deleted. Common commands: 1. crosscheck backup is used to check BACKUP sets for databases, tablespaces, data files, control files, archived logs, and spfiles. Crosscheck backup; -- check all backups (including valid and invalid backups) crosscheck backup of database; -- check the BACKUP file crosscheck backup of tablespace system except the control file and archive file; crosscheck backup of datafile 1; crosscheck backup of controlfile; crosscheck backup of archivelog all; crosscheck backup of archivelog sequence 3; crosscheck backup of spfile; 2. crosscheck backuppiece is used to check a specific backup piece. This Command requires the back-propagation value or name of the backup piece; crosscheck backuppiece 24; crosscheck backuppiece '/u01/app/oracle/rman_backup/OCPYJG_28'; 3. crosscheck backupset is used to check a specific backup set. This Command requires the Back-Propagation Value of the Backup set; crosscheck backupset 24; 4. crosscheck copy is used to check the image copies of databases, tablespaces, data files, control files, and archive files ...... or backup as copy ...... DATAFILE ...... command to back up the data file image) crosscheck copy; crosscheck copy of database; crosscheck copy of tablespace system; crosscheck copy of datafile 1; crosscheck copy of controlfile; crosscheck copy of archivelog all; crosscheck copy of archivelog from sequence 24 until sequence 32; 5. crosscheck dtafilecopy is used to check the image copy of a specific data file. This command must specify the file name or KEY value of the image copy; crosscheck datafilecopy 2; crosscheck datafilecopy '/u01/app/oracle/rman_backup/tp9.dbf'; 6. crosscheck controlfilecopy is used to check the image copy of a specific control file. This command must specify the file name or KEY value of the control file image copy; crosscheck controlfilecopy 3; crosscheck controlfilecopy '/u01/app/oracle/rman_backup/controlfile01.ctl; 7. crosscheck archivelog is used to check specific archived logs. This command specifies the file name, KEY value, or SEQUENCE Value of the archived log; crosscheck archivelog 36; crosscheck archivelog 'crosscheck archivelog '/u01/app/oracle/product/11g/dbs/arch1_6_813161833.dbf'; crosscheck ARCHIVELOG sequence 7;