Skip to Content
0
Former Member
Apr 18, 2014 at 12:05 AM

Oracle Data guard issue

395 Views

Hi,

We are on ECC 6.0, Oracle 11.2.0.3, windows environment

Whenever our link between Primary and DR site goes down we face this issue, Our DR configured on Max availability

We register /apply missing redo log

Primary -

alter system set log_archive_dest_state_2=defer scope = both sid = 'EC6'

Standby

SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

SQL> ALTER DATABASE REGISTER LOGFILE 'G:\oracle\EC6\oraarch\EC6ARCHARC00637_0747680046.001';

in case redo sequence number 637 is missing.

when we ENABLE from Defer on Primary we execute below on Standby

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE;

Though missing 637 redo log file is getting registered it is not getting applied, STATUS it is showing NO

When I Shutdown Standby it is not Shutting down with Shutdown immediate command, waited for around 30 min.

When I stop the service OracleServiceSID on Standby, we are getting BLUE Dump error on Primary. we need to Hard boot Primary. After starting servers, both works fine.

Pls help us so that we need not stop the OracleServiceSID, log automatically get apply after

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE;

This was working fine when we were on earlier on 10.2 release