Using Real Time Apply
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; download file now