ORA-00265错误的处理

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.