aiaiDBA

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

13718043309

010-86462881

RMAN-06146: changes found for file number beyond offline SCN

RMAN-06146: changes found for file number beyond offline SCN
Cause: A CHANGE or REPORT command needs to compute the list of backups that are redundant and may be deleted. A backup was found for a file which is shown as offline in the target database control file, but the backup contains changes beyond the system change number(SCN) when the file went offline. This is most likely because the target database control file is not really current, but is a restored copy of an older control file.
Action: Mount a current control file or a backup control file.

请先 登录 后评论

1 个回答

小智
RMAN-06146:找到的文件编号超出脱机SCN的更改,
.原因: CHANGE或REPORT命令需要计算冗余并可能被删除的备份列表。已找到在目标数据库控制文件中显示为脱机的文件的备份,但该文件脱机时,该备份包含超出系统更改编号(SCN)的更改。这很可能是因为目标数据库控制文件不是真正当前的,而是旧控制文件的恢复副本。,
.操作:装载当前控制文件或备份控制文件。,
.
请先 登录 后评论