v$managed_standby Tips Oracle Tips by Burleson Consulting December 3, 2011

From the severity column of the output, it appears that when the log apply service is waiting for archived redo logs from the primary database, it is treated as “Warning.” This is not a problem and is expected behavior.

A similar query on the v$managed_standby view can be useful in tracking the processes involved in the standby recovery. When this query is executed on the primary database, it gives information about the ARCH process.  When it is executed on the standby database, it provides status of ARCH, RFS and MRP processes. Use the managed_stdby.sql script from the code depot to see the status of various processes. The following output is from the managed_stdby.sql script when run on the standby and primary site:

            managed_stdby.sql script

column Process   format a7
column Status    format a12
column Group#    format 999
column Thread#   format 999
column Sequence# format 999999
 
Select
   Process,
   Status,
   Group#,
   Thread#,
   Sequence#
From
   see code depot for full script
   v$managed_standby;

Output from Standby Database:

PROCESS STATUS       GROUP#           THREAD# SEQUENCE#
------- ------------ ---------------  ------- ---------
ARCH    CONNECTED    N/A                    0         0
ARCH    CONNECTED    N/A                    0         0
MRP0    WAIT_FOR_LOG N/A                    1       240
RFS     RECEIVING    1                      1       238