aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

RMAN-06170: no control file copy found with offline range RECID string STAMP string datafile string

RMAN-06170: no control file copy found with offline range RECID string STAMP string datafile string
Cause: This offline range is needed for recovering the specified data file, but the offline range record has aged out of the current control file and no control file copy with the record could be accessed. At least 1 control file copy containing the offline range was found in the recovery catalog and was in AVAILABLE status.
Action: Query the RC_CONTROLFILE_COPY view for the names of all control file copies, then issue a CHANGE CONTROLFILECOPY ... VALIDATE; command for them. Then reissue the RECOVER command.

请先 登录 后评论

1 个回答

小智
RMAN-06170:未找到具有脱机范围的控制文件副本RECID 字符串 STAMP 字符串数据文件字符串,
.原因:恢复指定的数据文件需要此脱机范围,但脱机范围记录已超出当前控制文件,并且不能访问具有该记录的控制文件副本。在恢复目录中找到至少一个包含脱机范围的控制文件副本,并且处于AVAILABLE状态。,
.操作:查询RC_CONTROLFILE_COPY视图以查找所有控制文件副本的名称,然后发出CHANGE CONTROLFILECOPY ... VALIDATE; 命令为他们。然后重新发出RECOVER命令。,
.
请先 登录 后评论