ORA-00270: error creating archive log ORA-16055: FAL request rejected

parknkjun發表於2014-11-10
客戶在檢查資料庫alert日誌時發現錯誤,資訊如下:
ORA-00270: error creating archive log 
FAL[server, ARC1]: FAL archive failed, see trace file.
Errors in file c:\app\administrator\diag\rdbms\jzh\jzh\trace\jzh_arc1_5680.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Errors in file c:\app\administrator\diag\rdbms\jzh\jzh\trace\jzh_arc4_5028.trc:
ORA-00270: error creating archive log 
Archived Log entry 265749 added for thread 1 sequence 215193 ID 0xc02abe9 dest 1:
FAL[server, ARC4]: FAL archive failed, see trace file.
Errors in file c:\app\administrator\diag\rdbms\jzh\jzh\trace\jzh_arc4_5028.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing


以上錯誤初步判斷是DG出了問題,於是檢查trace檔案,發現歸檔日誌無法傳送至備庫,登
陸備庫就發現磁碟還剩16M,由於客戶備庫只做測試用處,並且已經測試完成,因此處理方法是:
1.將LOG_ARCHIVE_DEST_STATE_2設定為DEFER;
2.將備庫shutdown。


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

相關文章