ORA-00257:archiver error. Connect internal only,until freed.

ywxj_001發表於2018-10-06

連線資料庫報錯:

查詢資料庫的歸檔盤,發現歸檔磁碟被寫滿了。

清理歸檔日誌。

登入恢復正常。

歸檔報錯:

Tue Oct 02 16:48:01 2018

Thread 2 advanced to log sequence 122718 (LGWR switch)

  Current log# 15 seq# 122718 mem# 0: +DATA/scprd/onlinelog/group_15.374.982183663

Tue Oct 02 16:48:01 2018

LNS: Standby redo logfile selected for thread 2 sequence 122718 for destination LOG_ARCHIVE_DEST_2

Tue Oct 02 16:48:01 2018

ARC0: Error 19504 Creating archive log file to '+FRA'

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance SCPRD2 - Archival Error

ORA-16038: log 14 sequence# 122717 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 14 thread 2: '+DATA/scprd/onlinelog/group_14.373.982183653'

Tue Oct 02 16:48:01 2018

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance SCPRD2 - Archival Error

ORA-16014: log 14 sequence# 122717 not archived, no available destinations

ORA-00312: online log 14 thread 2: '+DATA/scprd/onlinelog/group_14.373.982183653'


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2215475/,如需轉載,請註明出處,否則將追究法律責任。

相關文章