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

MOSC Banner

Apply Lag-Active Dataguard

Hi Gurus, 11203 RAC RHEL 6.1

I have a RAC active dataguard setup with RAC primary(3 -node).There is a Lag of few seconds goes upto 10 mins which is unacceptable for real time reporting.I need to fix the apply lag so that the lag is 0 secs.I have securefile LOBS(XMLTYPE) in the db and network encryption enabled.

Please let me know how to tune the apply lag.

Dataguard_stats:

transport lagday(2) to second(0) interval01/12/2015 10:22:41
apply lag+00 00:00:08day(2) to second(0) interval01/12/2015 10:22:4101/12/2015 10:22:40
apply finish timeday(2) to second(3) interval01/12/2015 10:22:41
estimated startup time52second01/12/2015 10:22:41

MRP wait event:

class slave wait02
class slave wait

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