| dataguard server (physical standby) [message #668523] |
Wed, 28 February 2018 01:00  |
 |
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,
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
