RMAN delete obsolete = ORA-19606: Cannot copy or restore to snapshot control file, RMAN-06214: Datafile Copy, etc…

Problem

RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     18660437 15-JUL-10          /oracle/product/11.2.0.2/dbs/snapcf_P10AC.f
Backup Set           18667103 19-JUL-10
  Backup Piece       18667105 19-JUL-10          /oraback/P10AC/autobackup/2010_07_19/o1_mf_s_724801673_64b73c6t_.bkp

Do you really want to delete the above objects (enter YES or NO)? YES
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_1 channel at 07/22/2010 14:44:43
ORA-19606: Cannot copy or restore to snapshot control file

Another common problem that can be solved the same way (if the easier “crosscheck controlfile copy” doesn’t work):

RMAN> delete noprompt obsolete;
using target database control file instead of recovery catalog
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4 device type=DISK
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy     2      03-JUN-13          /oracle/product/11.2.0.3/dbs/snapcf_P10VQA.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   /oracle/product/11.2.0.3/dbs/snapcf_P10VQA.f

Solution

Not sure why this happens, but the solution is to configure a different snapshot controlfile name so that RMAN can use that, thus allowing you to remove the “old” one. Then configure back to what you had:

configure snapshot controlfile name to '/tmp/it.f';
crosscheck controlfilecopy "/oracle/product/11.2.0.2/dbs/snapcf_P10AC.f";
delete expired controlfilecopy "/oracle/product/11.2.0.2/dbs/snapcf_P10AC.f";
delete noprompt obsolete;
configure snapshot controlfile name to '/oracle/product/11.2.0.2/dbs/snapcf_P10AC.f';


MismatchED Datafile Copy

This is another similar issue but with a different solution.

RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 3
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 4 11-NOV-11 /tmp/control00.ctl
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 /tmp/control00.ctl

and the solution is:

RMAN> crosscheck copy;
RMAN> delete noprompt expired copy;
Advertisements

12 responses to “RMAN delete obsolete = ORA-19606: Cannot copy or restore to snapshot control file, RMAN-06214: Datafile Copy, etc…

  1. Pingback: RMAN delete obsolete = ORA-19606: Cannot copy or restore to snapshot control file | Jed's

  2. Hector Sanchez

    Thanks for the information. Your instructions solved my problem.

  3. Thanks. This also helped me.

  4. Thanks for posting the solution. I had same problem which i never saw before. Your solution works perfect. Thx

  5. Thanks for the information. Your instructions solved my problem!

  6. Thanks for the information. Your instructions solved my problem!

  7. Thank you for the information. My snapshot controlfile location was wrong and I have not seen this before!

  8. Thanks for the information. Very clear and it fixed my problem! One to add to the bag of tricks!

  9. Thanks for your help! Very appreciated.

  10. Fantastic, appreciate that you posted this information. It helped me resolved a problem last night.

  11. Tanks for information. very useful

  12. suhail akhter

    Perfect solution for this RMAN-03009: failure of delete command on ORA_DISK_1 channel at 07/22/2010 14:44:43

Leave a Reply

Fill in your details below or click an icon to log in:

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