Find the latest SCN # in phisical standby

From: Jiang, Lu <>
Date: Tue, 12 Jan 2010 17:43:20 -0500
Message-ID: <>

Hi all,  

I have set up a real time apply physical standby and trying to find how Real Time it is. However it seems that it is hard to find the latest SCN# on physical standby database, v$database (current_scn) only gets updated to the last scn which has been archived. Here is what I got:  

SQL> select recovery_mode from v$archive_dest_status where dest_id=2;


MANAGED REAL TIME APPLY   SQL> select name, value, time_computed from v$dataguard_stats where name='apply lag';

NAME            VALUE                TIME_COMPUTED

--------------- -------------------- ------------------------------
apply lag +00 00:00:00 12-JAN-2010 15:26:02

Primary last change time:  

SQL> select scn_to_timestamp(current_scn) from v$database;



12-JAN-10 PM     Standby last change time: - not updated after last log archived  

SQL> select current_scn from v$database;



SQL> select scn_to_timestamp(579664324) from v$database;



11-JAN-10 PM   SQL> select max(FIRST_CHANGE#),max(NEXT_CHANGE#) from v$archived_log;


  • -----------------

         579266831 579664325  

Could someone share some light on this?  



Received on Tue Jan 12 2010 - 16:43:20 CST

Original text of this message