Hello,
I am trying to create a physical standby database with Data Guard. I am following setup instructions (https://docs.oracle.com/database/121/SBYDB/create_ps.htm#SBYDB00424).
When I get to the last step, '3.2.7 Creating a Physical Standby Task 7: Verify the Physical Standby Database Is Performing Properly', and run the query
SQL> SELECT CLIENT_PROCESS, PROCESS, THREAD#, SEQUENCE#, STATUS FROM
V$MANAGED_STANDBY WHERE CLIENT_PROCESS='LGWR' OR PROCESS='MRP0';
I get
CLIENT_PROCESS PROCESS THREAD# SEQUENCE# STATUS
--------------------------- --------------- -------------- ------------------ -----------------------
N/A MRP0 1 31 WAIT_FOR_LOG
instead of
CLIENT_PROCESS PROCESS THREAD# SEQUENCE# STATUS
--------------------------- --------------- -------------- ------------------ -----------------------
N/A MRP0 1 80 APPLYING_LOG
LGWR RFS 1 80 IDLE
So I do not believe I have it working correctly.
Any suggestions on what I should look at?
Thank you in advance