在用delete obsolete 命令删除废弃的备份文件,如果出现如下错误(rman-06207 & rman-06208),那么需要用crosscheck命令来解决:
rman-06207: warning: 2 objects could not be deleted for disk channel(s) due
rman-06208: to mismatched status. use crosscheck command to fix status
crosscheck命令用户核对备份文件,以确保rman资料库与备份文件保持同步。当执行该命令时,如果rman资料库记录的状态与实际备份文件不匹配,则会更新资料库里的状态使其与实际备份文件状态一致;若备份文件处于expired状态,,那么说明该备份已失效,可以删除之;
常用命令介绍:
1.crosscheck backup
用于核对数据库、表空间、数据文件、控制文件、归档日志、spfile的备份集。
crosscheck backup ; --核对所有备份(包括有效和失效的备份)
crosscheck backup of database; --核对除控制文件、归档文件外的备份文件
crosscheck backup of tablespace system;
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
用于 核对特定备份片,该命令需要制定备份片的bp值或备份片名称;
crosscheck backuppiece 24;
crosscheck backuppiece '/u01/app/oracle/rman_backup/ocpyjg_28';
3.crosscheck backupset
用于核对特定的备份集,该命令需要制定备份集的bp值;
crosscheck backupset 24;
4.crosscheck copy
用于核对数据库、表空间、数据文件、控制文件、归档文件的映像副本(即备份是用copy datafile ...... 或backup as copy ......datafile......命令备份数据文件的映像)
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
用于核对特定的数据文件映像副本,该命令需要指定映像副本的文件名或key值;
crosscheck datafilecopy 2;
crosscheck datafilecopy '/u01/app/oracle/rman_backup/tp9.dbf';
6.crosscheck controlfilecopy
用于核对特定的控制文件映像副本,该命令需要指定控制文件映像副本的文件名或key值;
crosscheck controlfilecopy 3;
crosscheck controlfilecopy '/u01/app/oracle/rman_backup/controlfile01.ctl;
7.crosscheck archivelog
用于核对特定的归档日志,该命令需要指定归档日志的文件名或key值或sequence值;
crosscheck archivelog 36;
crosscheck archivelog 'crosscheck archivelog '/u01/app/oracle/product/11g/dbs/arch1_6_813161833.dbf';
crosscheck archivelog sequence 7;
