Re: archive_lag_target with real time apply for data guard
Date: Mon, 21 Dec 2015 01:56:32 -0500
Message-ID: <5677A2A0.3060901_at_gmail.com>
On 12/20/2015 07:01 PM, kathryn axelrod wrote:
> You are correct; real time apply is a free feature of ee data guard.
> It simply changes the process from waiting for actual archive logs to
> sending 'in real time' using redo logs.
Yes, you are correct:
7.2.1 Using Real-Time Apply to Apply Redo Data Immediately
If the real-time apply feature is enabled, apply services can apply redo data as it is received, without waiting for the current standby redo log file to be archived. This results in faster switchover and failover times because the standby redo log files have been applied already to the standby database by the time the failover or switchover begins.
Use the |ALTER DATABASE| statement to enable the real-time apply feature, as follows:
*
For physical standby databases, issue the |ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE| statement.
*
For logical standby databases, issue the |ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE| statement.
(https://docs.oracle.com/cd/E11882_01/server.112/e41134/log_apply.htm#SBYDB0050)
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 21 2015 - 07:56:32 CET