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

RMAN> crosscheck copy;

using target database control file insteadof recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=44 device type=DISK

specification does not match any datafilecopy in the repository

validation faild for control file copy

control file copy filename=/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f RECID=3 STAMP=856022420

validation succeeded for archived log

archived log filename=/dbdat/orclprd/oracle/archivelog/1_8402_840379839.dbf RECID=23STAMP=858385729

validation succeeded for archived log

archived log filename=/dbdat/orclprd/oracle/archivelog/1_8403_840379839.dbf RECID=24STAMP=858414268

RMAN> delete expired copy;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=44 device type=DISK

specification does not match any datafilecopy in the repository

specification does not match any archivedlog in the repository

List of Control File Copies

===========================

Key    S Completion Time     Ckp SCN    Ckp Time          

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

3      X 2014-08-19 16:00:20 3033671887 2014-08-19 15:58:47

       Name: /opt/oracle/product/11.2.0/dbs/snapcf_orcl.f

       Tag: TAG20140819T160019

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

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

RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============

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

RMAN-03009: failure of delete command onORA_DISK_1 channel at 09/22/2014 09:18:22

ORA-19606: Cannot copy or restore tosnapshot control file

RMAN> show all;

RMAN configuration parameters for databasewith db_unique_name DB2 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

CONFIGURE BACKUP OPTIMIZATION OFF; #default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; #default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; #default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' ASOF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TOSHIPPED TO ALL STANDBY;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f';

RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f.bak';

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f.bak';

new RMAN configuration parameters aresuccessfully stored

RMAN> exit

Recovery Manager complete.

[[email protected] ~]$ cd/opt/oracle/product/11.2.0/dbs/

[[email protected] dbs]$ ls

hc_orcl.dat lkDB2   orapwdg    snapcf_orcl.f

init.ora    lkORCL  orapworcl  spfileorcl.ora

[[email protected] dbs]$ rm -rf snapcf_orcl.f

[[email protected] dbs]$ rman target /

Recovery Manager: Release 11.2.0.1.0 -Production on Mon Sep 22 09:21:01 2014

Copyright (c) 1982, 2009, Oracle and/or itsaffiliates.  All rights reserved.

connected to target database: ORCL(DBID=1368160572)

RMAN> delete expired controlfilecopy'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f';

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=44 device type=DISK

List of Control File Copies

===========================

Key    S Completion Time     Ckp SCN    Ckp Time          

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

3      X 2014-08-19 16:00:20 3033671887 2014-08-19 15:58:47

       Name: /opt/oracle/product/11.2.0/dbs/snapcf_orcl.f

       Tag: TAG20140819T160019

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

deleted control file copy

control file copy filename=/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f RECID=3 STAMP=856022420

Deleted 1 EXPIRED objects

RMAN> show all;

RMAN configuration parameters for databasewith db_unique_name DB2 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

CONFIGURE BACKUP OPTIMIZATION OFF; #default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; #default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; #default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FORDEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICETYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FORDEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; #default

CONFIGURE ENCRYPTION FOR DATABASE OFF; #default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; #default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' ASOF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TOSHIPPED TO ALL STANDBY;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f.bak';

RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f';   

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f.bak';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f';

new RMAN configuration parameters aresuccessfully stored

RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME clear;

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/opt/oracle/product/11.2.0/dbs/snapcf_orcl.f';

RMAN configuration parameters are successfullyreset to default value

关于快照控制文件的详解http://www.2cto.com/database/201310/250284.html