在执行RMAN脚本时,删除过期备份出现了这样的报错
RMAN-06214: Datafile Copy /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak
解决方法:
RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak'; allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1654 device type=DISK
validation failed for control file copy
control file copy file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak RECID=6 STAMP=1022315092
Crosschecked 1 objects
RMAN> delete expired controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak';
也可以直接crosscheck copy;
RMAN> crosscheck copy;
RMAN> delete obsolete;
|