RMAN-06207: WARNING: 1 objects c…

记录一下错误：

Do you really want to delete the above objects (enter YES or NO)?y

RMAN-06207: WARNING: 1 objects could not be deletedfor DISK channel(s) due
RMAN-06208:         to mismatched status.  Use CROSSCHECK command tofix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   ObjectType   Filename/Handle
RMAN-06213: ------------------------------------------------------------------
RMAN-06214: Datafile Copy  /oracle_ebs/prod/db/tech_st/11.1.0/dbs/snapcf_PROD.f

 

 

 

 

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.7 andlater   [Release:11.1 and later ]
Information in this document applies to any platform.

Symptoms

The backup piece exists on the file system, but not in thecatalog.  What is the best way to remove it?

RMAN>DELETE NOPROMPT OBSOLETEDEVICE TYPE DISK;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 31 days
released channel: ORA_DISK_1
released channel: ORA_DISK_2
released channel: ORA_DISK_3
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1569 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1475 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1467 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ --------------------------------------
Control File Copy 195 25-APR-11/u01/app/oracle/product/11.1.0/db_bbprod/dbs/snapcf_bbprod.f

RMAN-06207: WARNING: 1 objects could not be deleted for DISKchannel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fixstatus
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: ------------------------------------------------------------------
RMAN-06214: Datafile Copy/u01/app/oracle/product/11.1.0/db_bbprod/dbs/snapcf_bbprod.f

If CROSSCHECK command is used:

RMAN>connect target /;

connected to target database: BBPROD (DBID=4030418788)

RMAN>connect catalog rman_bbprod/xxxxx@rman2;

connected to recovery catalog database

RMAN>CROSSCHECK BACKUPPIECE'/u01/app/oracle/product/11.1.0/db_bbprod/dbs/snapcf_bbprod.f';

starting full resync of recovery catalog
full resync complete
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1475 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1498 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1504 device type=DISK
RMAN-00571:===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS===============
RMAN-00571:===========================================================
RMAN-03002: failure of crosscheck command at 06/14/201108:18:06
RMAN-06004: ORACLE error from recovery catalog database:RMAN-20260: backup piece not found in the recovery catalog
RMAN-06092: error while looking up backup piece

Changes

Solution

There are two options to remove the snapshot controlfile:

RMAN>DELETE FORCE NOPROMPT OBSOLETE DEVICE TYPEDISK;

If RMAN-06214 still occurs, then try

RMAN>CROSSCHECK COPY OF CONTROLFILE;