How to verify DR lag ?
To verify Disaster Recovery lag
Connect to DR / standby server
select NAME, OPEN_MODE, LOG_MODE, FORCE_LOGGing, DATABASE_ROLE, INSTANCE_name, HOST_NAME, STARTUP_TIME from v$database,v$instance;
NAME OPEN_MODE LOG_MODE FOR DATABASE_ROLE INSTANCE_NAME HOST_NAME STARTUP_T
——— ——————– ———— — —————- —————- ——————– ———
STDBYP MOUNTED ARCHIVELOG YES PHYSICAL STANDBY STDBYP DRSRVR 04-OCT-17
MRP Process Status:
| SQL> select ‘Number_Of_MRP_Processes_is_’ || count(*) as RESULT from V$MANAGED_STANDBY where process like ‘MRP%’; 2 3 |
RESULT
| ——————————————————————- Number_Of_MRP_Processes_is_1 SQL> Select Thread#, max(sequence#) from gv$archived_log group by thread#; THREAD# MAX(SEQUENCE#) ———- ————– 1 7302 |
| SQL> select Thread#, max(sequence#) from v$archived_log where applied=’YES’ group by thread#; THREAD# MAX(SEQUENCE#) ———- ————– 1 7302 |
| SQL> SELECT a.thread#, b. last_seq, a.applied_seq, a. last_app_timestamp, b.last_seq-a.applied_seq ARC_DIFF FROM (SELECT thread#, MAX(sequence#) applied_seq, MAX(next_time) last_app_timestamp FROM gv$archived_log WHERE applied = ‘YES’ GROUP BY thread#) a, (SELECT thread#, MAX (sequence#) last_seq FROM gv$archived_log GROUP BY thread#) b WHERE a.thread# = b.thread#; |
|
THREAD |
LAST_SEQ |
APPLIED_SEQ |
LAST_APP_TIMESTAMP |
ARC_DIFF |
|
1 |
7302 |
7302 |
08-sep-2017 00:52:19 |
0 |
See Also: