What is Real Time Apply in Dataguard

What is real time apply in dataguard?

If media recovery is started with the following command after installing Data Guard in versions prior to Oracle 12c, Media Recovery starts as Archived Log Apply and not Real Time Apply. This means that the transactions coming from the Primary side will be processed to the Standby side immediately after the Standby Archive Logs are created. This situation has a side effect as follows; In the case of switchover or failover, unprocessed archives need to be processed to open the instance. This means that the failover/switchover will slow down.

Enable Real Time Apply in Dataguard

Check real time apply is enabled on standby database

(Standby 1)

Enable Real Time Apply

(Standby 1)

Check real time apply is enabled on standby database

(Standby 1)

Check if there is Apply Lag

(Standby 1)

Onur ARDAHANLI
Author: Onur ARDAHANLI

Leave a Reply

Your email address will not be published. Required fields are marked *