ORA-19606 控制文件的镜像文件被标记过期

denglj

数据库：oracle 11.2.0.4

系统：Window Server 2008 R2

问题描述：控制文件中登记的控制文件的镜像文件被标记过期，但通过rman命令却无法删除，报错ORA-19606，如下：

解决方案：

1、配置新的用于快照控制文件的Rman参数
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原快照控制文件

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;