High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Real-Time redo apply not working in ACTIVE Dataguard

Hi,

I have configured 11gR2(11.2.0.4 64-Bits) ACTIVE dataguard (physical standby) in maximum performance, default one. It works fine, also following SQL statements to enable Real-Time redo apply are executed successfully, but I am not able to view data at real time on standby rather with a difference of 5 to 10 minutes(same as before enabling real time).

Steps taken to enble Real-Time Apply:

Step-I: Open standby database in read only mode.

Step-II:

SQL> recover managed standby database using current logfile disconnect;

Media recovery complete.


I will really appreciate if someone can help me out to get real-time data at standby site by identifying if I am missing something in my configurations.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center