Question Re: Issue in Oracle DR setup in Additional Q&A

Issue in Oracle DR setup

Former Member — Tue, 07 Apr 2015 08:18:10 GMT

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

Re: Issue in Oracle DR setup

former_member182657 — Tue, 07 Apr 2015 08:42:18 GMT

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,

Re: Issue in Oracle DR setup

Former Member — Tue, 07 Apr 2015 11:04:22 GMT

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

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

Re: Issue in Oracle DR setup

Former Member — Tue, 07 Apr 2015 14:13:53 GMT

please find the alert<SID>.log attached

Re: Issue in Oracle DR setup

former_member182657 — Tue, 07 Apr 2015 14:23:32 GMT

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,

Re: Issue in Oracle DR setup

Former Member — Wed, 08 Apr 2015 07:39:54 GMT

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.

Re: Issue in Oracle DR setup

former_member182657 — Wed, 08 Apr 2015 07:55:40 GMT

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.

Re: Issue in Oracle DR setup

former_member182657 — Wed, 08 Apr 2015 07:59:18 GMT

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

Good luck !!