ORA-00265:修改Oracle歸檔模式錯誤分析

今天開啟資料庫，想修改Oracle的歸檔模式結果出現以下錯誤：

1. SQL> alter database archivelog;
2. alter database archivelog
5. *
6. ERROR at line 1:
7. ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

上網查了下，原來是上次系統的非正常關閉導致。需要重新開啟資料庫，使資料檔案，控制檔案，日誌檔案同步，再修改歸檔模式。

1. SQL> alter database open;
3. Database altered.
5. SQL> shutdown immediate;
6. Database closed.
7. Database dismounted.
8. ORACLE instance shut down.
9. SQL> startup mount;
10. ORACLE instance started.
12. Total System Global Area 301305856 bytes
13. Fixed Size 1336148 bytes
14. Variable Size 167775404 bytes
15. Database Buffers 125829120 bytes
16. Redo Buffers 6365184 bytes
17. Database mounted.
18. SQL> alter database archivelog;
20. Database altered.
22. SQL> alter database open;
24. Database altered.

重新檢視資料庫歸檔模式：

1. SQL> archive log list
2. Database log mode Archive Mode
3. Automatic archival Enabled
4. Archive destination USE_DB_RECOVERY_FILE_DEST
5. Oldest online log sequence 6
6. Next log sequence to archive 8
7. Current log sequence 8

OK。