Wednesday 10 February 2010

Oracle Dataguard : Check status from SQL

--On secondary
select current_scn from v$database

--On primary
select scn_to_timestamp(287481398) from v$database
union all
select scn_to_timestamp(current_scn) from v$database;

If too far apart may need to force log switch on primary

ALTER SYSTEM SWITCH LOGFILE;

Also see
select * from  V$DATAGUARD_STATUS;

0 comments: