当前位置:   article > 正文

ORA-00270: error creating archive log

ora-00270: error creating archive log
今天主库报了如下的错误
******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
ARC0: Standby redo logfile selected for thread 1 sequence 76 for destination LOG_ARCHIVE_DEST_2
LNS: Standby redo logfile selected for thread 1 sequence 77 for destination LOG_ARCHIVE_DEST_2
2015-04-17 13:08:59.080000 +08:00
ARC2: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC2: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
FAL[server, ARC2]: Error 270 creating remote archivelog file 'proddg'
FAL[server, ARC2]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance prod - Archival Error. Archiver continuing.
2015-04-17 13:09:00.136000 +08:00
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
FAL[server, ARC0]: Error 270 creating remote archivelog file 'proddg'
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance prod - Archival Error. Archiver continuing.
2015-04-17 13:09:01.151000 +08:00
ARC3: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC3: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
FAL[server, ARC3]: Error 270 creating remote archivelog file 'proddg'
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance prod - Archival Error. Archiver continuing.
2015-04-17 13:09:02.351000 +08:00
ARC2: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC2: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
FAL[server, ARC2]: Error 270 creating remote archivelog file 'proddg'
FAL[server, ARC2]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance prod - Archival Error. Archiver continuing.
ARC0: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
ARC0: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
FAL[server, ARC0]: Error 270 creating remote archivelog file 'proddg'
2015-04-17 13:09:03.402000 +08:00
FAL[server, ARC0]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance prod - Archival Error. Archiver continuing.
2015-04-17 13:11:35.871000 +08:00
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;
2015-04-17 13:11:39.381000 +08:00
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
2015-04-17 13:11:41.977000 +08:00
Thread 1 advanced to log sequence 78 (LGWR switch)
  Current log# 3 seq# 78 mem# 0: /u02/oradata/prod/redo03.log
Archived Log entry 85 added for thread 1 sequence 77 ID 0x109a224e dest 1:




查看trace
*** 2015-04-17 10:24:26.578
*** SESSION ID:(136.3) 2015-04-17 10:24:26.578
*** CLIENT ID:() 2015-04-17 10:24:26.578
*** SERVICE NAME:(SYS$BACKGROUND) 2015-04-17 10:24:26.578
*** MODULE NAME:() 2015-04-17 10:24:26.578
*** ACTION NAME:() 2015-04-17 10:24:26.578


Initial buffer sizes: read 1024K, overflow 832K, change 805K
Log read is SYNCHRONOUS though disk_asynch_io is enabled!
Log read is SYNCHRONOUS though disk_asynch_io is enabled!


*** 2015-04-17 12:56:13.526
Log read is SYNCHRONOUS though disk_asynch_io is enabled!
Error 270 creating standby archive log file at host 'proddg'


*** 2015-04-17 13:03:26.934
*** 2015-04-17 13:03:26.934 4329 krsh.c
ARC3: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
*** 2015-04-17 13:03:26.934 4329 krsh.c
ARC3: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
*** 2015-04-17 13:03:26.935 2917 krsi.c
krsi_dst_fail: dest:2 err:270 force:0 blast:1
kcrrwkx: unknown error:270


*** 2015-04-17 13:03:28.957
FAL[server]: Selected inactive destination; resetting temporarily


*** 2015-04-17 13:03:30.173
Error 270 creating standby archive log file at host 'proddg'
*** 2015-04-17 13:03:30.174 4329 krsh.c
ARC3: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (270)
*** 2015-04-17 13:03:30.174 4329 krsh.c
ARC3: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
*** 2015-04-17 13:03:30.174 2917 krsi.c
krsi_dst_fail: dest:2 err:270 force:0 blast:1
kcrrwkx: unknown error:270


发现是备库的standby archive log的路径满了
清空一些备库的空间,报警解除
声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/Cpp五条/article/detail/415748
推荐阅读
相关标签
  

闽ICP备14008679号