How to srart or stop Redo apply on physical Standby database

Start Redo Apply on Physical Standby database:

To start log apply services on a physical standby database, ensure the physical standby database is started and mounted and then start Redo Apply using the SQL

- To start a foreground session that recovers a database using the archived redo
log on the physical standby database, issue the SQL statement:
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE;

Note: If you started a foreground session, by default, control is not returned to the
command prompt until recovery is canceled by another session.

- To start a background process that recovers a database using the archived redo log on the physical standby database, you must use the DISCONNECT keyword on the SQL statement

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;