今天重新建了一個庫，在執行
alter system switch logfile;時一直夯在那裡，於是檢視警報日誌檔案，有如下資訊：
Thu Aug 21 19:25:30 2014
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc0_15710.trc:
ORA-19504: failed to create file "/u01/app/archivelog/dest2/1_4_856205535.dbf"
ORA-27040: file create error, unable to create file
Linux Error: 13: Permission denied
ARC0: Error 19504 Creating archive log file to '/u01/app/archivelog/dest2/1_4_856205535.dbf'
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc0_15710.trc:
ORA-19504: failed to create file "/u01/app/archivelog/dest1/1_4_856205535.dbf"
ORA-27040: file create error, unable to create file
Linux Error: 13: Permission denied
ARC0: Error 19504 Creating archive log file to '/u01/app/archivelog/dest1/1_4_856205535.dbf'
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance orcl - Archival Error
ORA-16038: log 1 sequence# 4 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc0_15710.trc:
ORA-16038: log 1 sequence# 4 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
Thu Aug 21 19:25:32 2014
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance orcl - Archival Error
ORA-16014: log 1 sequence# 4 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc1_15712.trc:
ORA-16014: log 1 sequence# 4 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'

由此我們可知可能檔案已滿，或者歸檔目錄不存在了。
經查明，檔案並未滿，而且目錄也存在。
後來發現時目錄許可權的問題。我的dest1,dest2的許可權是root，應該為oracle才對。
於是修改許可權，問題解決。

ORA-16014: log 1 sequence# 4 not archived, no available destinations

相關文章