dataguard server (physical standby) [message #668523] |
Wed, 28 February 2018 01:00 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/69cbc579a152d58eb551354b3e93fa13?s=64&d=mm&r=g) |
daulat01
Messages: 62 Registered: May 2011 Location: Delhi
|
Member |
|
|
Hello Dear,
I am new into Datagurad technology , I have some confusion.Please help
@Primary
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
--------------
471983
@standby
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
--------------
471911
@standby
SQL> select LOW_SEQUENCE#, HIGH_SEQUENCE# from V$ARCHIVE_GAP ;
no rows selected
SQL> select name , value from V$DATAGUARD_STATS where name like '%lag';
NAME VALUE
-------------------------------- ----------------------------------------------------------------
transport lag +00 00:08:43
apply lag +00 06:29:31
Can you please let me know , my dataguard is in sync with primary or not because there is no V$ARCHIVE_GAP ; but V$DATAGUARD_STATS shows lag time. Can you please let me know what I should do in this case.
Thanks,
|
|
|
|
|
|