『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;