A simple way to confirm the state of physical standby:
ODM TEST Case
===================
Name = Tc#1010_3
####primary####
Sql> Set Line 200
Col name for A100sql>
Sql> select Instance_name,status from V$instance;
instance_name STATUS
------------------------------------------------ ------------------------------------
ORCL OPEN
Sql> select Database_role from V$database;
Database_role
------------------------------------------------
Primary★primary
Sql> Select Sequence#-1 from V$log where status= ' current ';
Sequence#-1
-----------
61★on Primary, Latest ONLINE Redo number is 61
####standby####
Sql> Set Line 200
Col name for A100sql>
Sql> select Instance_name,status from V$instance;
instance_name STATUS
------------------------------------------------ ------------------------------------
Orcls OPEN
Sql> select Database_role from V$database;
Database_role
------------------------------------------------
Physical Standby★physical STANDBY
Sql> Select sequence#, name, applied from V$archived_log where resetlogs_change# = (select resetlogs_change# from V$dat Abase) Order by sequence#;
sequence# NAME Applied
---------- ---------------------------------------------------------------------------------------------------- - --------------------------
Wu YES
55/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_01_09/o1_mf_1_55_d768d472_.arc YES
56/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_01_09/o1_mf_1_56_d768dvdr_.arc in-memory★
57/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_57_dsb0ljby_.arc NO
58/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_58_dsb0lgkq_.arc NO
59/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_59_dsb0lgk1_.arc NO
60/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_60_dsb0ljc1_.arc NO
61/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_61_dsb0mg3z_.arc No★on Standby,no Redo Transportation Rag, but there is Redo application rag.
8 lines が drivers されました.
sql> Recover managed Standby database using current logfile disconnect; ★start REDO Application
メディア?リカバリが finished しました.
Sql> Select process,pid,status,thread#,sequence# from V$managed_standby where process= ' MRP0 '; ★MRP process is on (if there are no record here, it means MRP isn't on)
PROCESS PID STATUS thread# sequence#
--------------------------- ---------- ------------------------------------ ---------- ----------
MRP0 2898 Applying_log 1 62
Sql> Select sequence#, name, applied from V$archived_log where resetlogs_change# = (select resetlogs_change# from V$dat Abase) Order by sequence#;
sequence# NAME Applied
---------- ---------------------------------------------------------------------------------------------------- - --------------------------
Wu YES
55/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_01_09/o1_mf_1_55_d768d472_.arc YES
56/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_01_09/o1_mf_1_56_d768dvdr_.arc YES
57/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_57_dsb0ljby_.arc YES
58/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_58_dsb0lgkq_.arc YES
59/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_59_dsb0lgk1_.arc YES
60/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_60_dsb0ljc1_.arc YES
61/u01/app/oracle/fast_recovery_area/orcls/archivelog/2017_08_17/o1_mf_1_61_dsb0mg3z_.arc in-memory★if Ther E is no REDO application rag and REDO transportation Rag on Standby, the "Applied" column of Latest SEQUENCE should are "in -memory "(Expected behavior)
8 lines が drivers されました.
[Oracle] [DATAGUARD] Method for confirming the state of physical standby in the same period