Oracle Data guard issue

[Former Member]

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

[achmad_dimyati5]

Hi,

The blue dump regarding stop  OracleServiceSID is kindly worried issue.

Could you start and stop the service without starting the oracle standby? Is it OK?

Could you start the standby database with startup nomount and shutdown again. Is it fast?

Please post the instance parameter from primary and standby.

Regards,

Achmad

[Former Member]

Hi,

Mount your database in standby mode, place archive log 637 in archive directory and execute below command:

recover standby database;

auto

Paste the results here.

Regards,

Nick Loy

[Reagan]

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

What does the alert log say when you tried to apply the archived log 637?

If the log file is a corrupted one then it will not be useful.

Transfer a new copy of the log file and apply it.

Regards

RB

[ACE-SAP]

Hello

When you are talking about a 'blue dump' do you mean Windows system is crashing on the primary ?

This is a bad error, check alert log on primary, and consider opening a support message.

You should indeed, as advised by Gaurav, issue a

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

on standby

SAP does not recommend using max avail mode.

Regards

1615380 - Mini Checks

57. Protection mode - Dataguard standby database protection mode

"MAXIMUM PROTECTION" or "MAXIMUM AVAILABILITY" can negatively impact "log file sync" performance and should normally be avoided(note 105047)

[former_member182657]

Hi,

Could you please share alert_<SID>.log file from both ends.Are you using managed recovery mode,if yes then you need to give command at primary end

alter system archive log current

  Please share the output of command at standby end

alter database recover managed standby database disconnect from session;

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

Regards,

Gaurav