ORA-00270:ORA-16401:ORA-16055

早上在檢查數據庫日誌的時候發現有很多如下的ora錯誤:

ORA-00270: error creating archive log

ORA-16401: archivelog rejected by RFS

ORA-16055: FAL request rejected

在另外一臺數據庫的同一時間也發現了同樣的錯誤.由於兩臺數據庫都用一臺standby.於是在standby上面查找原因,后發現是由於standby主機的archive分區空間已滿.故有此錯誤出現,清理已滿的磁盤分區即可恢復正常.

看來standby的點檢也不能馬虎大意,也要把它放在重點照顧的位置上.

 

Thu Jul  2 21:33:20 2009

LGWR: Standby redo logfile selected to archive thread 1 sequence 4836

LGWR: Standby redo logfile selected for thread 1 sequence 4836 for destination LOG_ARCHIVE_DEST_2

Thread 1 advanced to log sequence 4836

  Current log# 2 seq# 4836 mem# 0: /u02/oradata/qhdb01/redo02a.log

  Current log# 2 seq# 4836 mem# 1: /u03/oradata/qhdb01/redo02b.log

Thu Jul  2 21:39:36 2009

LGWR: Standby redo logfile selected to archive thread 1 sequence 4837

LGWR: Standby redo logfile selected for thread 1 sequence 4837 for destination LOG_ARCHIVE_DEST_2

Thread 1 advanced to log sequence 4837

  Current log# 3 seq# 4837 mem# 0: /u02/oradata/qhdb01/redo03a.log

  Current log# 3 seq# 4837 mem# 1: /u03/oradata/qhdb01/redo03b.log

Thu Jul  2 22:01:35 2009

LGWR: Attempting destin