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