Logical standby Apply stuck in Initializaing State.
edited Aug 5, 2013 4:41PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 1 commentAnswered
Dear Experts,
I created a new Logical standby database and the Apply process is stuck in INITIALIZING state.
SQL> select * from v$logstdby_state;
PRIMARY_DBID SESSION_ID REALTIME_APPLY STATE
------------ ---------- ---------------------------------------------------------------- ---------------------
3652740631 1 Y INITIALIZING
Please can someone help in understand why it is like this. 11.2.0.2 on Windows. Attached is the Parameter file of the Logical standby.
I see the below lines in Alert Log when I start the Apply process,
alter database start logical standby apply immediate
with optional part
IMMEDIATE
Attempt to start background Logical Standby process
Mon Aug 05 17:43:01 2013
LSP0 started with pid=41, OS id=6244
Completed: alter database start logical standby apply immediate
0