Find the latest SCN # in phisical standby

From: Jiang, Lu <Lu.Jiang_at_umassmed.edu>
Date: Tue, 12 Jan 2010 17:43:20 -0500
Message-ID: <BBB2B987DB6E504D89FC45EA314CE9890FF1AE60_at_edmtpmail01.ad.umassmed.edu>



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;

RECOVERY_MODE


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;

SCN_TO_TIMESTAMP(CURRENT_SCN)



---

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

SQL> select current_scn from v$database;

CURRENT_SCN


  579664324

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

SCN_TO_TIMESTAMP(579664324)



---

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

MAX(FIRST_CHANGE#) MAX(NEXT_CHANGE#)

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

         579266831 579664325  

Could someone share some light on this?  

Thanks,

Lu

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jan 12 2010 - 16:43:20 CST

Original text of this message