 |
|
Oracle Dataguard - Implementing Standby
Databases
Oracle Tips by Burleson |
Oracle Data guard
Chapter 3 - Implementing Standby
Databases
Verify the Logical Standby Database
Although, verifying the application data
between the 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 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 RAC Grid 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.
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%.
|
