ORACLE10G修改成為ARCHIVELOG模式時報錯:

SQL> alter database archivelog;

alter database archivelog

*

ERROR at line 1:

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.

ORA-00265錯誤的處理

相關文章