Database Software

Hi,

We patched our primary and two standby DBs. Patched was successful and didn't report any error. The real problem starts with only one of standby Db.

We open our standby Db in read only mode and started logs in real time. But its MRP0 process always showing WAIT_FOR_LOG status.

-- Faulty Standby
SQL> select PROCESS,STATUS,SEQUENCE#,BLOCK# from v$managed_standby;

PROCESS STATUS SEQUENCE# BLOCK#
--------- ------------ ---------- ----------
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
RFS IDLE 27281 227
RFS IDLE 0 0
RFS IDLE 0 0
MRP0 WAIT_FOR_LOG 27281 0

--------

Other standby working fine and showing right result. pleas see below.

--- Right Standby

SQL> select PROCESS,STATUS,SEQUENCE#,BLOCK# from v$managed_standby;

PROCESS STATUS SEQUENCE# BLOCK#
--------- ------------ ---------- ----------
ARCH CONNECTED 0 0
ARCH CLOSING 27279 1
ARCH CONNECTED 0 0
ARCH CONNECTED 0 0
ARCH CLOSING 27280 4097
RFS IDLE 27281 337
RFS IDLE 0 0
RFS IDLE 0 0
MRP0 APPLYING_LOG 27281 336


-------------------------------------------------------

Here is result from primary Db.

select process, status, sequence#, block# from v$managed_standby;

PROCESS STATUS SEQUENCE# BLOCK#
--------- ------------ ---------- ----------
ARCH CLOSING 27280 4097
ARCH CLOSING 27201 1
ARCH CLOSING 27278 1
ARCH CLOSING 27278 1
ARCH CLOSING 27279 1
LNS WRITING 27281 408
LNS WRITING 27281 408


-------------------------
I used same command to start real time appy in both Standby Dbs.

alter database recover managed standby database using current logfile disconnect from session parallel 2;


But I am getting problem with one standby. sequences are in sink with primary Db and there is no missing logs.

Please share you views and ideas if I am missing anything here.

Regards.