Dataguard commands and SQL scripts

Physical Standby Commands To start redo apply in foreground: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE; To stop redo apply process on the Standby database (to stop MRP): SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL; To start real-time redo apply: SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION; To…