『ORACLE』修改归档时报错:instance recovery required, cannot set ARCHIVELOG mode(11g)

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

 

正常关库、启库使数据库一致性关闭

SQL>shutdown immediate

SQL>startup

在关库、启动到mount状态

SQL>shutdown immediate

SQL>startup mount;

SQL> alter database archivelog;

posted @ 2017-05-01 15:21  九號栈長  阅读(264)  评论(0编辑  收藏  举报