系统环境
操作系统:AIX 6.1
数据库版本: oracle 11.2.0.2
架构:主库为RAC环境,两个dataguard灾备库,一个为本机房的,一个为异地的,本次出问题为异地的dataguard
问题描述
通过监控V$DATAGUARD_STATS显示dataguard延迟,log也已经不再传到dataugard端
处理过程
1.查看主库alert中报错如下
Errors in file /db/diag/rdbms/xxxshprod/xxxshpd1/trace/xxxshpd1_nsa3_16777216.trc:
ORA-00270: error creating archive log
Wed Jun 05 10:16:09 2013
Archived Log entry 26853 added for thread 1 sequence 5589 ID 0xffffffffd412add4 dest 1:
Wed Jun 05 10:16:50 2013
Thread 1 cannot allocate new log, sequence 5592
Checkpoint not complete
Current log# 8 seq# 5591 mem# 0: +ARCHDG/xxxshprod/onlinelog/redo08.log
Thread 1 advanced to log sequence 5592 (LGWR switch)
Current log# 9 seq# 5592 mem# 0: +ARCHDG/xxxshprod/onlinelog/redo09.log
Wed Jun 05 10:16:59 2013
Archived Log entry 26856 added for thread 1 sequence 5591 ID 0xffffffffd412add4 dest 1:
Wed Jun 05 10:16:59 2013
LNS: Attempting destination LOG_ARCHIVE_DEST_3 network reconnect (270)
LNS: Destination LOG_ARCHIVE_DEST_3 network reconnect abandoned
Error 270 for archive log file 9 to 'XXXSTY'
Errors in file /db/diag/rdbms/xxxshprod/xxxshpd1/trace/xxxshpd1_nsa3_16777216.trc:
ORA-00270: error creating archive log
Wed Jun 05 10:17:01 2013
LNS: Standby redo logfile selected for thread 1 sequence 5592 for destination LOG_ARCHIVE_DEST_2
查看具体的trace文件
More /db/diag/rdbms/xxxshprod/xxxshpd1/trace/xxxshpd1_nsa3_16777216.trc:
*** 2013-03-29 13:25:19.476
*** SESSION ID:(2834.1) 2013-03-29 13:25:19.476
*** CLIENT ID:() 2013-03-29 13:25:19.476
*** SERVICE NAME:(SYS$BACKGROUND) 2013-03-29 13:25:19.476
*** MODULE NAME:() 2013-03-29 13:25:19.476
*** ACTION NAME:() 2013-03-29 13:25:19.476
*** TRACE FILE RECREATED AFTER BEING REMOVED ***
LOG_ARCHIVE_DEST_2 depends upon me, but my destination index 2 does not match its destination index 1
Log file opened [logno 9]
*** 2013-03-29 13:35:18.264
LOG_ARCHIVE_DEST_2 depends upon me, but my destination index 2 does not match its destination index 1
*** 2013-03-29 13:35:18.367
Log file opened [logno 7]
LOG_ARCHIVE_DEST_2 depends upon me, but my destination index 2 does not match its destination index 1
*** 2013-03-29 13:42:05.725
Log file opened [logno 8]
3.通过灾备ASM视图,看到ASM满了,确认为灾备空间引起的,给ASM添加空间后(ASM添加步骤见以前日志)在主库上面执行切换日志操作,发现问题没有解决,于是重启灾备数据库,再尝试切换日志,问题照样存在
alter system switch logfile;
4.找到一篇官方文档[ID 1308804.1],说是Bug 10331312 ,解决方案为下
Set the log_archive_trace to 0 like,
alter system set log_Archive_trace=0;
on both primary and standby if it is set before.
In DGMGRL,
DGMGRL>edit database '' set property LogArchiveTrace=0;
5.,查了一下log_Archive_trace默认就为0,我们之前没有修改好,不过还是照样执行了,问题还是存在,尝试把灾备的ASM实例和灾备数据库实例全部进行重启,重启后问题解决
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21605631/viewspace-763550/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21605631/viewspace-763550/