--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; |
Wednesday, 10 February 2010
Oracle Dataguard : Check status from SQL
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment