Restart redo LOG shipping - Oracle Dataguard

How to restart the Redo log shipping to standby Database

To stop log apply on standby database:

SQL>  alter database recover managed standby database cancel;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

To resume Log apply:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

Alternate Method:

Cancel MRP:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Run the below in Dataguard instance:

DGMGRL> edit database <STBY_DB> set state='APPLY-OFF';

Succeeded.

Run the Below for primary database

DGMGRL> edit database  <PRIM_DB> set state='LOG-TRANSPORT-OFF';

Succeeded.

Now to initiate the process:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT; -- Start MRP

Run the below in Dataguard instance:

DGMGRL> edit database <STBY_DB> set state='APPLY-ON';

Succeeded.

Run the Below for primary database:

DGMGRL> edit database  <PRIM_DB> set state='LOG-TRANSPORT-ON';

Succeeded.

 

Ref:  Steps to restart log transport process in data guard (Doc ID 2819878.1)