解决方案：
1、配置新的用于快照控制文件的Rman参数
RMAN> configure snapshot controlfile name to'D:\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\SNCFLISORCL.ORA.NEW';
RMAN> configure snapshot controlfile name to'D:\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\SNCFLISORCL.ORA.NEW';
new RMAN configuration parameters:
CONFIGURE SNAPSHOTCONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\SNCFLISORCL.ORA.NEW';
new RMAN configurationparameters are successfully stored
2、手动删除SNCFLISORCL.ORA原快照控制文件
2、手动删除SNCFLISORCL.ORA原快照控制文件
3、从Rman中删除原快照控制文件
RMAN> crosscheck controlfilecopy 'D:\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\SNCFLISORCL.ORA';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=68 devicetype=DISK
validation failed for control file copy
control file copy file name= D:\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\SNCFLISORCL.ORARECID=11 STAMP=1089247332
Crosschecked 1 objects
RMAN> delete expired controlfilecopy 'D:\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\SNCFLISORCL.ORA';
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=68 devicetype=DISK
List of Control File Copies
===========================
Key S Completion Time Ckp SCN CkpTime
------- - --------------- -------------------------
11 X 22-NOV-21 1320651 22-NOV-21
Name: D:\ORACLE\PRODUCT\11.2.0\DB_1\DATABASE\SNCFLISORCL.ORA
Tag: TAG20211122T004212
Do you really want to delete the aboveobjects (enter YES or NO)? yes
deleted control file copy
control file copy filename=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl151.f RECID=11STAMP=1089247332
Deleted 1 EXPIRED objects
4、设置快照控制文件名为默认值
RMAN> configure snapshot controlfilename clear;
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |