解决: --1. Set new name (or location) for RMAN to use for snapshot controlfile:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORA new';
新的 RMAN 配置参数:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORAnew';
已成功存储新的 RMAN 配置参数
--2. Remove the snapshot controlfile from the RMAN information as a controlfile copy.
delete 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORA' on operating system.
--3. Crosscheck and delete the file from RMAN:
RMAN> crosscheck controlfile copy 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORA';
是否确定要删除以上对象 (输入 YES 或 NO)? yes
已删除控制文件副本
控制文件副本文件名D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORA RECID=1 STAMP=774635982
1 EXPIRED 对象已删除
--4. Set the snapshot controlfile name (or location) to original:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORA';
旧的 RMAN 配置参数:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORAnew';
新的 RMAN 配置参数:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORA';
已成功存储新的 RMAN 配置参数
--5. To set the snapshot controlfile name back to default value:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME clear;
旧的 RMAN 配置参数:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE_DB\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFTJ.ORA';
RMAN 配置参数已成功重置为默认值
参考:metalink ID 1215493.1