Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle 11gr2 DG Broker error

User321378May 22 2013 — edited May 22 2013

Hi all,

i have setup the Dataguard from Primay to standby and configured the DG Broker for easy swicthover and failovers.
all seems to be fine and i was able to perform switchover and failovers and Reinstaing all without any errors using DG BROKER.

but whenever i query the show database for standby DB it always says or displays message as Transport Lag: (unknown).

please help me its 11GR2 (11.2.0.3) in OLE.

DGMGRL> show database 'TEST_DG'

Database - TEST_DG

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: (unknown)
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
TEST_DG

Database Status:
SUCCESS

Please help , Im very curious to know , from where this value is pciked by DG_Broker.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2013

Added on May 22 2013

#data-guard, #performance-availability

14 comments

2,929 views