rman备份的时候发现有如下报错:
RMAN-06207: WARNING: 3 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02
RMAN-06214: Backup Piece /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210923-00
RMAN-06214: Backup Piece /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210923-01
处理:
RMAN> crosscheck backuppiece '/data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02';
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=116 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02 RECID=2241 STAMP=1079003876
Crosschecked 1 objects
RMAN> delete backupset 2241;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
2241 2241 1 1 EXPIRED DISK /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02 RECID=2241 STAMP=1079003876
Deleted 1 objects
控制文件报错:
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak
处理:
RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak';
RMAN> delete expired controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak';




