ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-00270:ORA-16401:ORA-16055

ORA-00270:ORA-16401:ORA-16055

原创 Linux操作系统 作者:janeting 时间:2009-07-03 12:46:00 0 删除 编辑

早上在檢查數據庫日誌的時候發現有很多如下的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博客 ” ,链接:http://blog.itpub.net/13023909/viewspace-608236/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-09-12

  • 博文量
    22
  • 访问量
    48612