You can query the V$LOGSTDBY view to see the activity log of the
logical standby redo application process. The logical standby database is now available for use.
486 Oracle Database 11g DBA Handbook
Using Real-Time Apply
By default, redo data is not applied to a standby database until the standby redo log file is archived.
When you use the real-time apply feature, redo data is applied to the standby database as it is
received, reducing the time lag between the databases and potentially shortening the time required
to fail over to the standby database.
To enable real-time apply in a physical standby database, execute the following command in
the standby database:
alter database recover managed standby database
using current logfile;
For a logical standby database, the command to use is
alter database start logical standby apply immediate;
The Recovery_Mode column of the V$ARCHIVE_DEST_STATUS view will have a value of
???MANAGED REAL-TIME APPLY??™ if real-time apply has been enabled.
As shown earlier in this chapter, you can enable the redo application on a physical standby
database via the command
alter database recover managed standby database disconnect;
The disconnect keyword allows the command to run in the background after you disconnect from
your Oracle session. When you start a foreground session and issue the same command without
the disconnect keyword, control is not returned to the command prompt until the recovery is
cancelled by another session.
Pages:
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738