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

delete obsolete; 发现出现报错 ORA-19606: Cannot copy or restore to snapshot control file

解决办法:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f_bak'; --先重命名文件
crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f';
delete expired controlfilecopy '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0.4/db_1/dbs/snapcf_slnngk.f';
CONFIGURE SNAPSHOT CONTROLFILE NAME clear;

原文地址:https://www.cnblogs.com/hxlasky/p/10494625.html