Using Real-Time Apply

To enable real-time apply on physical standby database, execute the following command:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;

For a logical standby database, the command to use is

SQL> ALTER DATABASE START LOGICAL STANDBY IMMEDIATE;

The disconnect keyword allows the command to run in the background control return to command prompt. If not using “disconnect” keyword, control is not returned to the command prompt until the recovery is cancelled by another session.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

Stop the Log Apply Services

For a Physical standby database, the command to stop the Log Apply Services is

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

For a logical standby database, the command to stop the Log Apply Services is

SQL > ALTER DATABASE STOP LOGICAL STANDBY APPLY;