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/，如需轉載，請註明出處，否則將追究法律責任。