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

birk

　　
　　
　　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.
　　[oracle@DB2 ~]$ cd/opt/oracle/product/11.2.0/dbs/
　　[oracle@DB2 dbs]$ ls
　　hc_orcl.dat lkDB2   orapwdg    snapcf_orcl.f
　　init.ora    lkORCL  orapworcl  spfileorcl.ora
　　[oracle@DB2 dbs]$ rm -rf snapcf_orcl.f
　　[oracle@DB2 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.iyunv/database/201310/250284.html
         版权声明：本文为博主原创文章，未经博主允许不得转载。