ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Dataguard报错DEPENDS UPON ME, BUT MY DESTINATION INDEX处理过程

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

原创 Linux操作系统 作者:eymit 时间:2013-06-08 18:14:06 0 删除 编辑

系统环境

 

操作系统: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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-05-09

  • 博文量
    65
  • 访问量
    330913