This content has been marked as final. Show 4 replies
Kavanagh wrote:THat wont help, check v$archived_log
Platform : Oracle Enterprise Linux
I remember one of my colleague using v$datafile_header to check if the Standby and Primary are in Sync. Any idea how this is done ? Is this a reliable way to check if Primary and Standby are in Sync ?
you can also use script http://www.visi.com/~mseberg/data_guard/monitor_data_guard_transport.html
v$dataguard_stats in the standby is the easiest single line query to check the status of redo transport and apply.
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG
ORDER BY SEQUENCE#;
In the end search for v$datafile_header;