Re: Dataguard logs

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Dataguard-logs-tp1478p1482.html

For 9i; In short you will check the applied logs using the below query;

run this query in both primary and standby site and compare the result.

select sequence#, applied,
  to_char(first_time, 'mm/dd/yy hh24:mi:ss') first
  from v$archived_log
  order by first_time;