apply log on standby has stopped after network disconnect
edited Dec 8, 2010 8:22PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 20 commentsAnswered
Hi all,
My network connection between my primary db and standby db broke. But now it is up again, but automatic apply on my standby database had stopped since the network stopped.
MRP0 1 2560 0 0
See above where the apply had stopped. But now, the sequence has reached 2813, but MRP0 is still at 2560.
see below,
SQL> select process,thread#, sequence#, block#, blocks
from v$managed_standby
PROCESS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ---------- ---------- ---------- ----------
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
PROCESS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ---------- ---------- ---------- ----------
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
My network connection between my primary db and standby db broke. But now it is up again, but automatic apply on my standby database had stopped since the network stopped.
MRP0 1 2560 0 0
See above where the apply had stopped. But now, the sequence has reached 2813, but MRP0 is still at 2560.
see below,
SQL> select process,thread#, sequence#, block#, blocks
from v$managed_standby
PROCESS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ---------- ---------- ---------- ----------
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
PROCESS THREAD# SEQUENCE# BLOCK# BLOCKS
--------- ---------- ---------- ---------- ----------
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
ARCH 0 0 0 0
0