RMAN-06207 RMAN-06208 RMAN-06214

Problems while deleting the snapshot controlfile during backup process.

Take a hot backup.

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   D:\ROMFORD\APP\MPOOJARI\PRODUCT\11.2.0\DBHOME_1\DATA
BASE\SNCFROMFORD.ORA

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 01/25/2011 14:54:34
RMAN-06209: List of failed objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece    D:\ROMFORD\APP\MPOOJARI\PRODUCT\11.2.0\DBHOME_1\DATA
BASE\SNCFROMFORD.ORA

Solution

RMAN> crosscheck copy of controlfile;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=23 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=149 device type=DISK
validation failed for control file copy
control file copy file name=D:\ROMFORD\APP\MPOOJARI\PRODUCT\11.2.0\DBHOME_1\DATA
BASE\SNCFROMFORD.ORA RECID=3 STAMP=740675828
Crosschecked 1 objects

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     3      17-JAN-11          D:\ROMFORD\APP\MPOOJARI\PRODUCT\
11.2.0\DBHOME_1\DATABASE\SNCFROMFORD.ORA

Safe method:

RMAN> DELETE CONTROLFILECOPY 'D:\ROMFORD\APP\MPOOJARI\PRODUCT\
11.2.0\DBHOME_1\DATABASE\SNCFROMFORD.ORA';

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     3      17-JAN-11          D:\ROMFORD\APP\MPOOJARI\PRODUCT\
11.2.0\DBHOME_1\DATABASE\SNCFROMFORD.ORA

Do you really want to delete the above objects (enter YES or NO)? YES
control file copy file name=D:\ROMFORD\APP\MPOOJARI\PRODUCT\11.2.0\DBHOME_1\DATA
BASE\SNCFROMFORD.ORA RECID=3 STAMP=740675828
Deleted 1 objects

Do not run the below command if the report obsolete shows more than one file(may be a valid backup piece or controlfile copy)

RMAN> delete noprompt obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
using channel ORA_DISK_2
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     3      17-JAN-11          D:\ROMFORD\APP\MPOOJARI\PRODUCT\
11.2.0\DBHOME_1\DATABASE\SNCFROMFORD.ORA
deleted control file copy
control file copy file name=D:\ROMFORD\APP\MPOOJARI\PRODUCT\11.2.0\DBHOME_1\DATA
BASE\SNCFROMFORD.ORA RECID=3 STAMP=740675828
Deleted 1 objects

The next time I ran the backup, I found no errors in the log file.

Advertisements

About mpoojari
Oracle Database/Applications Administrator

One Response to RMAN-06207 RMAN-06208 RMAN-06214

  1. cindy says:

    Thank You..just what i was looking for , saved me the hassel of openning an sr.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: