RMAN-06214: Datafile Copy的处理

王亮

在每天的rman备份中，提示RMAN-06214,有一个文件删除不了，报错如下

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy   /u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl1.f


先根据提示对上面的那个文件进行controlfilecopy进行crosscheck操作

RMAN> crosscheck copy;

released channel: ORA_DISK_1

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=2018instance=jbhisdb2 device type=DISK

specification does not match any datafilecopy in the repository

validation failed for control file copy

control file copy filename=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl1.f RECID=1STAMP=1026940278

Crosschecked 1 objects

尝试删除

MAN> delete obsolete;

RMAN retention policy will be applied tothe command

RMAN retention policy is set to redundancy1

using channel ORA_DISK_1

Deleting the following obsolete backups andcopies:

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ --------------------------------------

Control File Copy     1     13-DEC-19         /u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl1.f

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/dbhome_1/dbs/snapcf_orcl1.f RECID=1STAMP=1026940278

Deleted 1 objects

删除成功，同时修改一下snapshot controlfile备份的位置

在rman中使用show all先查看一下数据库当前的控制文件快照设置的备份位置

RMAN> show all;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO'/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl1.f'; # default

修改snapshot controlfile备份的位置

RMAN> CONFIGURE SNAPSHOT CONTROLFILENAME TO '+DATA/oradata/snapcf_orcl1.f';

然后再执行一下备份脚本，查看是否会报错，同时检查新的位置中，是否有生成相应的备份文件