Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







dba_logstdby_log tips

Oracle Database Tips by Donald Burleson

Although, verifying the application data between the Data Guard logical and the primary database is the best method to check the consistency of data on standby database, this may not always be the most appropriate method. There are few views such as dba_logstdby_log in the Oracle data dictionary that can be queried to find the status of the various processes involved in the log transfer and log apply services. In this section, two views that will show the log transfer process and the overall progress of the log apply service will be presented.

Once logs are transferred from the primary site to the standby site, they need to be automatically registered with the logical Oracle instance before the log apply process (lsp0) can read and apply the SQL statements.

The dba_logstdby_log view provides information on the archived logs registered at the standby site. The script, reg_log.sql, from the code depot shows the logs registered with the logical standby database.

set linesize 100
Column Sequence# Format 99999
Column File_Name Format a60
Column Timestamp Format a20

   to_char(Timestamp,'YYYY/MM/DD HH24:MI:SS') Timestamp

   see code depot for full scripts


order by

A sample output from the dba_logstdby_log script shows the archived redo logs and the time it was registered with the standby database:

SEQUENCE# FILE_NAME                              TIMESTAMP
--------- -------------------------------------- -------------
      527 /oracle/appsdb/arch/appsdb_1_568.dbf   2003/10/05 19:14:17
      528 /oracle/appsdb/arch/appsdb_1_569.dbf   2003/10/05 19:18:41
      529 /oracle/appsdb/arch/appsdb_1_570.dbf   2003/10/05 19:18:41
      530 /oracle/appsdb/arch/appsdb_1_571.dbf   2003/10/05 19:18:42
      531 /oracle/appsdb/arch/appsdb_1_572.dbf   2003/10/05 19:17:22

A few log switches can be performed on the primary site and then checked to see if this query is showing the new archived logs as registered.

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. This script is a query on dba_logstdby_progress view and shows the received, read, and applied SCN by the standby database.



The above text is an excerpt from: the book "Oracle Data Guard", ISBN 0-9745993-8-7, by Bipul Kumar.  Order it directly from the publisher link and save 30%.

Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.