ORA-16014: log 1 sequence# 4 not archived, no available destinations
今天重新建了一個庫，在執行
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'
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才對。
於是修改許可權，問題解決。
經查明，檔案並未滿，而且目錄也存在。
後來發現時目錄許可權的問題。我的dest1,dest2的許可權是root，應該為oracle才對。
於是修改許可權，問題解決。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29800581/viewspace-1255807/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-16014: log 1 sequence# 857 not archived, no available destinationsHiveAI
- ORA-16014: log 2 sequence# 59 not archived, no available destinationsHiveAI
- 【oracle】ORA-16038: log 2 sequence# 98 cannot be archivedOracleHive
- Archived redolog is (significant) smaller than the redologfileHiveNifi
- 【REDO】Archived redolog is (significant) smaller than the redologfileHiveNifi
- Archived redolog is (significant) smaller than the redologfile_1356604.1HiveNifi
- RMAN-05541: no archived logs found in target databaseHiveDatabase
- OGG-00446 ERROR: Could not find archived logErrorHive
- RMAN-08137: WARNING: Archived Log Not DeletedHivedelete
- ogg GGS ERROR 500 Could not find archived logErrorHive
- Managing multiple archive log destinations with RMAN (Doc ID 443814.1)Hive
- Log actively being archived by another process問題解決Hive
- oracle 9i physical standby database 上的v$archived_logOracleDatabaseHive
- Archived Redo Logs歸檔重做日誌介紹及其優點Hive
- 清除Oracle控制檔案中的歸檔資訊v$archived_logOracleHive
- RMAN-08137: WARNING: archived log not deleted, needed for standby or upstreamHivedelete
- Alert.log shows No Standby Redo Logfiles Of Size 153600 Blocks AvailableBloCAI
- RMAN-06054: media recovery requesting unknown archived log for thread...Hivethread
- RMAN 中V$ARCHIVED_LOG 中STATUS 為"X" 的檔案處理Hive
- weblogic.common.ResourceException: No good connections available.WebExceptionGoAI
- rman 刪除v$archive_log檢視裡的記錄（Removing entries in v$archived_log）HiveREM
- Alert.log shows No stdby Redo Logfiles Of Size 153600 Blocks Available-405836.1BloCAI
- Used+Available不等於1K-blocksAIBloC
- Archiving not possible: No primary destinations errorsError
- 【實驗】【Archived Log】歸檔日誌格式和歸檔路徑之change趣談Hive
- Git bash Error: Could not fork child process: There are no available terminals (-1)GitErrorAI
- exclude Log4j print Log
- 資料庫關不掉，報No primary destinations資料庫
- 帶你深入Java Log框架，徹底搞懂Log4J、Log4J2、LogBack，SLF4JJava框架
- log4plsqlSQL
- log4net
- weblogic 1Web
- No qualifying bean of type 'javax.sql.DataSource' available: expected at least 1BeanJavaSQLAIAST
- ClassCastException Log4jLoggerFactory LoggerContexASTException
- proferosec/log4jScanner：log4j漏洞掃描工具ROSJS
- Java的Log架構（Log4j2 + Slf4j）Java架構
- log4j2使用及log4j2.xml分析XML
- InputStream之available()AI