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

因发现 flash area 不多了，通过 select * from v$flash_recovery_area_usage ；发现是备份集占用空间太多。
于是delete obsolete; 发现出现报错 ORA-19606: Cannot copy or restore to snapshot control fileRMAN> delete obsolete;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=174 device type=DISK
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Control File Copy 1 23-AUG-13 /u01/app/Oracle/product/11.2.0/dbhome_1/dbs/snapcf_finaprim.f
Backup Set 560 20-SEP-13
Backup Piece 560 20-SEP-13 +DATADG/finaprim/backupset/2013_09_20/annnf0_tag20130920t233259_0.1829.826673579
Backup Set 561 20-SEP-13
Backup Piece 561 20-SEP-13 +DATADG/finaprim/autobackup/2013_09_20/s_826673580.945.826673581
Backup Set 562 21-SEP-13
Backup Piece 562 21-SEP-13 +DATADG/finaprim/backupset/2013_09_21/annnf0_tag20130921t233004_0.623.826759805
Backup Set 563 21-SEP-13
Backup Piece 563 21-SEP-13 +DATADG/finaprim/backupset/2013_09_21/nnndf0_tag20130921t233011_0.693.826759813
Backup Set 564 21-SEP-13
Backup Piece 564 21-SEP-13 +DATADG/finaprim/backupset/2013_09_21/annnf0_tag20130921t233257_0.807.826759977
Backup Set 565 21-SEP-13
Backup Piece 565 21-SEP-13 +DATADG/finaprim/autobackup/2013_09_21/s_826759979.743.826759979
Backup Set 566 22-SEP-13
Backup Piece 566 22-SEP-13 +DATADG/finaprim/backupset/2013_09_22/annnf0_tag20130922t233005_0.1800.826846207
Backup Set 567 22-SEP-13
Backup Piece 567 22-SEP-13 +DATADG/finaprim/backupset/2013_09_22/nnndf0_tag20130922t233021_0.624.826846223
Backup Set 568 22-SEP-13
Backup Piece 568 22-SEP-13 +DATADG/finaprim/backupset/2013_09_22/annnf0_tag20130922t233307_0.1887.826846387
Backup Set 569 22-SEP-13
Backup Piece 569 22-SEP-13 +DATADG/finaprim/autobackup/2013_09_22/s_826846388.1891.826846389
Backup Set 570 23-SEP-13
Backup Piece 570 23-SEP-13 +DATADG/finaprim/backupset/2013_09_23/annnf0_tag20130923t233004_0.1041.826932605
Backup Set 571 23-SEP-13
Backup Piece 571 23-SEP-13 +DATADG/finaprim/backupset/2013_09_23/nnndf0_tag20130923t233020_0.776.826932621
Backup Set 572 23-SEP-13
Backup Piece 572 23-SEP-13 +DATADG/finaprim/backupset/2013_09_23/annnf0_tag20130923t233306_0.1895.826932787
Backup Set 573 23-SEP-13
Backup Piece 573 23-SEP-13 +DATADG/finaprim/autobackup/2013_09_23/s_826932787.1061.826932789
Backup Set 574 24-SEP-13
Backup Piece 574 24-SEP-13 +DATADG/finaprim/backupset/2013_09_24/annnf0_tag20130924t233005_0.1082.827019005Do 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 09/25/2013 09:16:59
ORA-19606: Cannot copy or restore to snapshot control file
解决办法：
就是把SNAPSHOT CONTROLFILE的配置路径改变,然后删除控制文件快照
---重命名SNAPSHOT 文件
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_finaprim.f_bak";new RMAN configuration parameters:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_finaprim.f_bak";
new RMAN configuration parameters are successfully stored
---- crosscheck
RMAN> crosscheck controlfilecopy "/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_finaprim.f";released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=174 device type=DISK
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_finaprim.f RECID=1 STAMP=824231734
Crosschecked 1 objects相关阅读：SPFILE 错误导致数据库无法启动（ORA-01565） http://www.linuxidc.com/Linux/2013-08/88932.htmORA-01172、ORA-01151错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htmORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htmORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htmORA-00471 处理方法笔记 http://www.linuxidc.com/Linux/2013-09/90017.htmORA-00314,redolog 损坏，或丢失处理方法 http://www.linuxidc.com/Linux/2013-09/90646.htmORA-00257 归档日志过大导致无法存储的解决办法 http://www.linuxidc.com/Linux/2013-09/90594.htm

Oracle 11g RAC 停机之后启动rac 时报 CRS-0184: Cannot communicate with the CRS daemon.Oracle 监听日志文件过大,导致监听无法启动相关资讯 ORA-19606 本文评论查看全部评论（0）