重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-19606: Cannot copy or restore to snapshot control file [打印本页]

作者: 郑全 时间: 2019-4-26 11:19
标题: ORA-19606: Cannot copy or restore to snapshot control file

rman>delete obsolete;

Do 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';

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)