ORACLE10G修改成为ARCHIVELOG模式时报错:
SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode ORA-00265: instance recovery required, cannot set ARCHIVELOG mode Cause: The database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles. Action: Open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option.
问题是实例可能是出现故障或是在关闭数据库的时候使用了AROBT选项。
处理方法是打开数据库后然后使用normal或immediate选项来关闭数据库
后再重启数据库
SQL> shutdown abort; ORACLE instance shut down.
重新OPEN开数据库后,正常关闭数据库。然后执行ARCHIVELOG模式修改,一切顺利执行。
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 71305244 bytes Database Buffers 130023424 bytes Redo Buffers 2973696 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered.