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.
