aiaiDBA

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

13718043309

010-86462881

ORA-19838: Cannot use this control file to open database

ORA-19838: Cannot use this control file to open database
Cause: This control file was restored by a DUPLICATE operation used only to restore and recover the datafiles of the new database. It is not meant to be used for opening the database, as allowing so might corrupt datafiles or online redo logs of the target database or both.
Action: Re-create control file manually specifying all names of datafiles and online redo logs. Do not forget to use NID to change the name or DBID or both of the new database.

请先 登录 后评论

1 个回答

小智
ORA-19838:无法使用此控制文件打开数据库,
.原因:此控制文件由仅用于还原和恢复新数据库的数据文件的DUPLICATE操作恢复。它并不意味着用于打开数据库,因为这样可能会损坏目标数据库的数据文件或联机重做日志,或两者兼而有之。,
.操作:重新创建控制文件,手动指定数据文件和联机重做日志的所有名称。不要忘记使用NID来更改新数据库的名称或DBID或两者。,
.
请先 登录 后评论