Dataguard报错DEPENDS UPON ME, BUT MY DESTINATION INDEX处理过程

系统环境

 

操作系统：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/