早上在檢查數據庫日誌的時候發現有很多如下的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 destination LOG_ARCHIVE_DEST_2 network reconnect (270)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Thu Jul 2 22:01:35 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_lgwr_19571.trc:
ORA-00270: error creating archive log
LGWR: Error 270 creating archivelog file 'qhdbsb'
LGWR: Failed to archive log 1 thread 1 sequence 4838 (270)
Thread 1 advanced to log sequence 4838
Current log# 1 seq# 4838 mem# 0: /u02/oradata/qhdb01/redo01a.log
Current log# 1 seq# 4838 mem# 1: /u03/oradata/qhdb01/redo01b.log
LNSb started with pid=17, OS id=31867
Thu Jul 2 22:38:45 2009
LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Thu Jul 2 22:38:45 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_lgwr_19571.trc:
ORA-00270: error creating archive log
LGWR: Error 270 creating archivelog file 'qhdbsb'
LGWR: Failed to archive log 2 thread 1 sequence 4839 (270)
Thread 1 advanced to log sequence 4839
Current log# 2 seq# 4839 mem# 0: /u02/oradata/qhdb01/redo02a.log
Current log# 2 seq# 4839 mem# 1: /u03/oradata/qhdb01/redo02b.log
Thu Jul 2 22:43:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:43:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:43:59 2009
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Thu Jul 2 22:43:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-00270: error creating archive log
FAL[server, ARC0]: Error 270 creating remote archivelog file 'qhdbsb'
FAL[server, ARC0]: FAL archive failed, see trace file.
Thu Jul 2 22:43:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Thu Jul 2 22:43:59 2009
ORACLE Instance qhdb01 - Archival Error. Archiver continuing.
Thu Jul 2 22:48:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:48:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:48:59 2009
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Thu Jul 2 22:48:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-00270: error creating archive log
FAL[server, ARC0]: Error 270 creating remote archivelog file 'qhdbsb'
FAL[server, ARC0]: FAL archive failed, see trace file.
Thu Jul 2 22:48:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Thu Jul 2 22:48:59 2009
ORACLE Instance qhdb01 - Archival Error. Archiver continuing.
Thu Jul 2 22:53:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:53:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:53:59 2009
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Thu Jul 2 22:53:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-00270: error creating archive log
FAL[server, ARC0]: Error 270 creating remote archivelog file 'qhdbsb'
FAL[server, ARC0]: FAL archive failed, see trace file.
Thu Jul 2 22:53:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Thu Jul 2 22:53:59 2009
ORACLE Instance qhdb01 - Archival Error. Archiver continuing.
Thu Jul 2 22:58:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:58:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
Thu Jul 2 22:58:59 2009
Suppressing further error logging of LOG_ARCHIVE_DEST_2.
Suppressing further error logging of LOG_ARCHIVE_DEST_2.
Thu Jul 2 22:58:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-00270: error creating archive log
Suppressing further error logging of LOG_ARCHIVE_DEST_2.
FAL[server, ARC0]: FAL archive failed, see trace file.
Thu Jul 2 22:58:59 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Thu Jul 2 22:58:59 2009
ORACLE Instance qhdb01 - Archival Error. Archiver continuing.
Thu Jul 2 23:04:10 2009
Errors in file /u01/app/oracle/admin/qhdb01/bdump/qhdb01_arc0_19621.trc:
ORA-16401: archivelog rejected by RFS
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13023909/viewspace-608236/ ，如需转载，请注明出处，否则将追究法律责任。
