dba_logstdby_progress tips Oracle Tips by Burleson

Another view, dba_logstdby_progress, shows the overall progress of the log apply service on the standby site. See the script log_progress.sql from code depot that uses dba_logstdby_progress. This script is a query on dba_logstdby_progress view and shows the received, read, and applied SCN by the standby database.

Set linesize 100

Column Applied_Scn Format 999999
Column Read_Scn    Format 999999
Column Newest_Scn   \Format 999999

Select
   Applied_Scn,
   Read_Scn,
   Newest_Scn
From  
      see code depot for full scripts
   DBA_LOGSTDBY_PROGRESS;

The following is a sample output from dba_logstdby_progress SQL script:

APPLIED_SCN   READ_SCN NEWEST_SCN
----------- ---------- ----------
     168011     167225     168133

newest_scn  shows the most recent SCN available on the standby site. When all the changes from the primary site have been applied on the standby site, the value of applied_scn and newest_scn will be equal.