aiaiDBA

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

13718043309

010-86462881

RMAN-06118: a backup control file older than SCN string must be used for this recovery

RMAN-06118: a backup control file older than SCN string must be used for this recovery
Cause: An attempt was made to recover the database, but some files had no backup, and were not present in the control file at the beginning of the restore. This happens when the control file used during the recovery is a backup control file taken before the creation of some of the files that had no backup. In this situation, the control file that is used must be taken before the creation of all files that have no backup. This will enable RMAN to automatically re-create all of the files that had no backup.
Action: Restore a control file that was backed up before the specified system change number (SCN). The following RMAN commands can be used to do this: SET UNTIL SCN ; (where is the SCN displayed in the message) RESTORE CONTROLFILE;

请先 登录 后评论

1 个回答

小智
RMAN-06118:此恢复必须使用早于SCN 字符串的备份控制文件,
.原因:尝试恢复数据库,但有些文件没有备份,并且在恢复开始时不存在于控制文件中。当恢复期间使用的控制文件是在创建没有备份的某些文件之前获取的备份控制文件时,会发生这种情况。在这种情况下,必须在创建所有没有备份的文件之前使用所使用的控制文件。这将使RMAN能够自动重新创建所有没有备份的文件。,
.操作:恢复在指定的系统更改号(SCN)之前备份的控制文件。以下RMAN命令可用于执行此操作:SET UNTIL SCN ; (其中是消息中显示的SCN)RESTORE CONTROLFILE;,
.
请先 登录 后评论