Issue in Oracle DR setup

[Former Member]

Hi All,

We are facing issue in DR configuration. Standby database is giving error

ORA-16766: Redo Apply is stopped

DGMGRL> show database bwp;

show database bwp;

     ^

Syntax error before or at "database"

DGMGRL> show database bwp;

Database - bwp

  Role:            PRIMARY

  Intended State:  TRANSPORT-ON

  Instance(s):

    BWP

Database Status:

SUCCESS

DGMGRL> show database bwp_standby;

Database - bwp_standby

  Role:            PHYSICAL STANDBY

  Intended State:  APPLY-ON

  Transport Lag:   (unknown)

  Apply Lag:       (unknown)

  Real Time Query: OFF

  Instance(s):

    BWP

  Database Error(s):

    ORA-16766: Redo Apply is stopped

Database Status:

ERROR

Please help in resolving issue

[former_member182657]

Addition to it suggest you to recopy log ( BWParch1_52_871817369.dbf ) from the primary & after that try to recover standby database.

Good luck !!

[former_member182657]

Hi,

ORA-16766: Redo Apply is stopped

Could you share alert_<SID>.log file for analysis.In addition share STANDBY_FILE_MANAGEMENT parameter value.

Regards,

[Former Member]

Hi,

Please find alert<SID>.log file attached. Also please find the standby_file_management parameter value in Standby database.

sapbwprod:orabwp 1> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Apr 7 16:27:10 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter standby_file_management;

NAME                                TYPE        VALUE

------------------------------------ ----------- ------------------------------

standby_file_management              string      auto

Regards

Mahesh

alertBWP.txt.zip

[Former Member]

please find the alert<SID>.log attached

alert_BWP.txt.zip

[former_member182657]

Hi Mahesh,

Are you using data guard broker method ? Please confirm.

Also try to execute SQL command & check again.

Alter database recover managed standby database using current logfile disconnect;

If still issue persists reshare the updated alert_<SID>.log file.

Regards,

[Former Member]

Hi Gaurav,

Yes, we are using data guard broker. I have already executed the above command still error remains same.

Please find latest alert log file attached.

alert_BWP.txt.zip

[former_member182657]

Hi Mahesh,

ORA-00326: log begins at change 6545391, need earlier change 6534638
ORA-00334: archived log: '/oracle/BWP/oraarch/BWParch1_52_871817369.dbf'
Recovery interrupted!

Issue here with recovery of database.For this i would suggest you to follow solution under SAP Note   424102 - Restarting BRARCHIVE after creating a standby database

& try to recover standby database .

Hope this will help you.