Tuesday, December 1, 2009

RMAN "DELETE OBSOLETE" returns ORA-19606 - the solution.

Problem


When trying to delete obsolete backups, rman includes the snapshot control file:
RMAN> DELETE NOPROMPT OBSOLETE;
...
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 23123 19/NOV/2009 13:05:46 /u01/app/oracle/product/11.1.0/db_1/dbs/snapcf_MDMR.f
...
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_DISK_2 channel at 11/26/2009 12:16:48
ORA-19606: Cannot copy or restore to snapshot control file

The command successfully deletes the other files.

Metalink only has one note for ORA-19606: the note (49303.1) that describes ORA-19606.

Solution


Change the snapshot controlfile name in the RMAN configuration, run the delete obsolete command again, and then change the snapshot controlfile name back (if you want).

For example:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u03/FRA/BLOBBY/snapcf1_MDMR.f';

After executing the above command, the snapshot controlfile name is changed to snapcf1_MDMR.f

Now run "delete obsolete" again. It will delete the old snapshot controlfile, but in subsequent runs, it will not include the snapshot controlfile in the list to delete.

You can now change back to original name or continue with the new name.

Joy.

2 comments:

  1. X4P8LV mhxzqqahsqpe, [url=http://uqwlsjsuzehh.com/]uqwlsjsuzehh[/url], [link=http://vzixwrbrrprd.com/]vzixwrbrrprd[/link], http://amidrnfqnxms.com/

    ReplyDelete
  2. Dear, I like your blog very much, I can get many useful information. Hope that we can communicate with each other. By the way, have you ever used clone partition to ssd ? Unfortunately I lost my partition. I do not know how to do.

    ReplyDelete