ORA-00270: error creating archive log
来源:互联网 发布:抓取网页数据 编辑:程序博客网 时间:2024/06/05 12:00
今天主库报了如下的错误
******************************************************************
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的路径满了
清空一些备库的空间,报警解除
******************************************************************
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的路径满了
清空一些备库的空间,报警解除
0 0
- ORA-00270: error creating archive log
- Error 270 for archive log file ORA-00270: error creating archive log Error 1033 received logging on
- ARC3: Error 19809 Creating archive log file to '+FRADG'
- FAL[server, ARC3]: FAL archive failed Error 16401 creating standby archive log file at host
- ORA-00257 archive error、noarchivelog
- OCP-043 creating archive log files in ASM
- archive log 日志已满 ORA-00257: archiver error. Connect internal only, until freed 错误的处理方法
- archive log 日志已满 ORA-00257: archiver error. Connect internal only, until freed 错误的处理方法
- ORA-27501: IPC error creating a port
- archive log
- 解决ora-00257 archive error -- 空间不够引起
- Oracle RAC 登录archive error ora-00257错误处理方法
- Error creating assembly archive pack: You must set at least one file.
- ERROR OGG-00524 DDL trace log file [\ggs_ddl_trace.log], error code -20782 error message ORA-207
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- 【Vegas原创】ORA-16040 standby destination archive log file is locked解决
- ORA-01511: error in renaming log/data files
- ORA-20782: Creating GGS_DDL_RULES
- leetcode 6 ZigZag Conversion
- oc UI UIViewController的生命周期及iOS程序执行顺序
- Linux各个版本介绍
- 孪生蜘蛛
- Android系统上部署usb打印机
- ORA-00270: error creating archive log
- 第六周 项目四 成员函数、友元函数和一般函数有区别(3)一般函数
- 导航栏变化背景
- The Ultimate Guide To iPhone Resolutions
- 剑指offer--把字符串转换成整数
- UIViewController切换动画效果设置
- [IOS]关于文件(文件目录)的读写操作
- 关于JQuery easyui中numberbox鼠标点击事件问题
- Spark:java.net.BindException: Address already in use: Service 'SparkUI' failed after 16 retries!