Gracefully restart Data Guard Standby

1. Stop redo log shipping from the primary to the standby

On primary:

Alter system set log_archive_dest_state_2='DEFER';

2. Make sure all archivelogs received at the standby are applied.

3. Stop managed recovery on the physical standby database

alter database recover managed standby database cancel;

4. Shutdown the standby database

SHUTDOWN IMMEDIATE;

-- Then restart the standby database:

5. Startup No Mount

STARTUP NOMOUNT

ALTER DATABASE MOUNT STANDBY DATABASE;

6. Enable redo log shipping to the standby:
On primary:

Alter system set log_archive_dest_state_2='ENABLE';

7. Start Apply process on the standby:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

******************************************
keywords: data guard standby shutdown
******************************************
rdbms version: 10G
******************************************