My Oracle Support Banner

RMAN-06207 or Rman-20260 on snapshot controlfile (Doc ID 1330173.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

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

RMAN> DELETE NOPROMPT OBSOLETE DEVICE 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 /<DIR>/<DB_NAME>/dbs/<FILE_NAME>.f

RMAN-06207: WARNING: 1 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: Datafile Copy /<DIR>/<DB_NAME>/dbs/<FILE_NAME>.f


If CROSSCHECK command is used:

RMAN> connect target /;

connected to target database: <DATABASE_NAME> (DBID=xxxxxxxx)

RMAN> connect catalog <USER>/xxxxx@<ALIAS>;

connected to recovery catalog database

RMAN> CROSSCHECK BACKUPPIECE '/<FILE_NAME>/<DATABASE_NAME>/dbs/<FILE_NAME>.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/2011 08: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



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.