ORA-19606: Cannot copy or restore to snapshot control file

Error:

      ORA-19606: Cannot copy or restore to snapshot control file

Cause for the Error Code from Oracle:

      A control file copy or restore operation specified the name of the snapshot control file as the output file. It is not permitted to overwrite the snapshot control file in this manner. Other methods are available to create the snapshot control file. 

Action to fix the error as per Oracle:

      Specify a different file name and retry the operation. If this is a restore, then the restore conversation remains active and more files may be specified.

Issue faced and exact Error observed in my system:

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Control File Copy     25     16-MAR-12          ~/oracle/base/product/11.2.0/dbhome_1/dbs/snapcf_wcs.f

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of delete command on ORA_DISK_1 channel at 06/06/2013 07:49:40

ORA-19606: Cannot copy or restore to snapshot control file

Solution to resolve the issue:

Solution -1:

Execute the below command before calling Command "DELETE NOPROMPT EXPIRED BACKUP":

“configure snapshot controlfile name to '/opt/oracle/base/product/11.2.0/dbhome_1/dbs/snapcf_wcs.f';".

Solution-2:


1) Run command “delete obsolete” in RMAN mode. This command will return snapfile

  RMAN> delete obsolete;                                                                                                                                                                                         
  Type                 Key    Completion Time    Filename/Handle
  -------------------- ------ ------------------ --------------------
  Control File Copy     40     30-11-2009 18:41:15 ~/oracle/product/11.2.0/dbhome_1/dbs/snapcf_tetris.f

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

  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/dbhome_1/dbs/snapcf_tetris.f

2) Crosscheck the file. Like below

RMAN> crosscheck datafilecopy '~/oracle/product/11.2.0/dbhome_1/dbs/snapcf_tetris.f';                                                                                                                  

  using target database control file instead of recovery catalog

  allocated channel: ORA_DISK_1
  channel ORA_DISK_1: SID=148 device type=DISK
  allocated channel: ORA_DISK_2
  channel ORA_DISK_2: SID=140 device type=DISK

  RMAN-00571: ===========================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  RMAN-00571: ===========================================================
  RMAN-03002: failure of crosscheck command at 11/30/2009 19:09:43
  RMAN-20230: datafile copy not found in the repository
  RMAN-06015: error while looking up datafile copy name: ~/oracle/product/11.2.0/dbhome_1/dbs/snapcf_tetris.f

3) Cross check the controlfile

  RMAN> crosscheck controlfilecopy '~/oracle/product/11.2.0/dbhome_1/dbs/snapcf_tetris.f';                                                                                                               

  released channel: ORA_DISK_1
  released channel: ORA_DISK_2
  allocated channel: ORA_DISK_1
  channel ORA_DISK_1: SID=148 device type=DISK
  allocated channel: ORA_DISK_2
  channel ORA_DISK_2: SID=140 device type=DISK

  validation failed for control file copy
  control file copy file name=~/oracle/product/11.2.0/dbhome_1/dbs/snapcf_tetris.f

  RECID=40 STAMP=704313675
  Crosschecked 1 objects