aiaiDBA

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

13718043309

010-86462881

ORA-01223: RESETLOGS must be specified to set a new database name

ORA-01223: RESETLOGS must be specified to set a new database name
Cause: The SET database name option was specified to CREATE CONTROLFILE, but RESETLOGS was not specified. The database name can only be changed when opening the database with RESETLOGS.
Action: Either add the RESETLOGS option or drop the SET option to CREATE CONTROLFILE.

请先 登录 后评论

1 个回答

小智
ORA-01223:必须指定RESETLOGS才能设置新的数据库名称,
.原因:将SET数据库名称选项指定为CREATE CONTROLFILE,但未指定RESETLOGS。只有在使用RESETLOGS打开数据库时,才能更改数据库名称。,
.操作:添加RESETLOGS选项或将SET选项放到CREATE CONTROLFILE。,
.
请先 登录 后评论