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

MOSC Banner

Logical standby database not applying

Hello Experts,

   Our logical standby database halted the apply, I couldnt see any event in dbs_logstdby_events and the output of v$logstdby_state is

   SQL> select * from v$logstdby_state;

PRIMARY_DBID SESSION_ID REALTIME_APPLY                                                   STATE
------------ ---------- ---------------------------------------------------------------- ---------------------------------------------
                                 1             N                                                                APPLYING

   I could see some entries in the alert log as

  LSP0: warning -- apply server 3, sid 280 waiting for event (since 10944 seconds):
LSP0: warning -- apply server 5, sid 356 waiting for event (since 10944 seconds):
Thu Jun 21 09:09:52 2012
LSP0: warning -- apply server 2, sid 240 waiting for event (since 560 seconds):
Thu Jun 21 09:38:54 2012
LSP0: warning -- apply server 1, sid 201 waiting for event (since 1742 seconds):

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