Hi expert
We are using dataguard on 11.2.0.4 oracle database. Now i want to switchover to physical standby but there is a problem. When i check status of dataguard with
DGMGRL> show database sby2;
Database - sby2
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 14 minutes 10 seconds (computed 6 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 424.00 KByte/s
Real Time Query: OFF
Instance(s):
sby2
Database Status:
SUCCESS
there is always transport lag. Lag time changes 5 min to 50 min. Aplly lag always 0(zero). Database status: SUCCESS
When i check with sqlplus
SQL> select name, value, unit, time_computed from v$dataguard_stats where name in ('transport lag', 'apply lag');
NAME VALUE UNIT TIME_COMPUTED
------------- ------------- ------------------------------ ------------------------------
transport lag +00 00:00:00 day(2) to second(0) interval 05/13/2020 14:01:41
apply lag +00 00:00:00 day(2) to second(0) interval 05/13/2020 14:01:41
SQL>
there is no lag. Always.
When i check this statement
Primary---
SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG
WHERE RESETLOGS_CHANGE# = (SELECT MAX(RESETLOGS_CHANGE#) FROM V$ARCHIVED_LOG)
GROUP BY THREAD#; 2 3
MAX(SEQUENCE#) THREAD#
-------------- ----------
366800 1
Standby---
SQL> SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG
WHERE RESETLOGS_CHANGE# = (SELECT MAX(RESETLOGS_CHANGE#) FROM V$ARCHIVED_LOG)
GROUP BY THREAD#; 2 3
MAX(SEQUENCE#) THREAD#
-------------- ----------
366800 1
both sides primary and standby gives same results. I think my dataguard works fine, but dgmgrl results confuses me.
In this case what can i do, is making switchover safe?
Thanks.