重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-00270: error creating archive log [打印本页]

作者: mahan    时间: 2023-10-22 18:47
标题: 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的路径满了
清空一些备库的空间,报警解除






欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2