Tag Archives: Disable the Dataguard

Enable and Disable the Oracle dataguard

Enable and Disable the dataguard steps

Disable Data Guard

On Standby Database:
1. Cancel the Recovery job with following command

alter database recover managed standby database cancel;

2. Stop the destination

alter system set log_archive_dest_state_2=DEFER;

On Primary Database:
1. Stop the standby destination for transport archives.

alter system set log_archive_dest_state_2=DEFER;
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;

Enable the dataguard:
On Primary DB:
1. Enable the archive log transport:

ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;

On Standby DB:
1. Start the recovery process with following command:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;

2. Enable the log archive for switchover condition needed.

ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;

 
Shutdown and Start the Primary / Standby database dataguard.

For Shutdown the dataguard environment

On Standby Database:
1. Cancel the Recovery process with following command

alter database recover managed standby database cancel;

2. Shutdown the databse

Shutdown immediate;

On Primary Database:
1. Stop the standby destination for transport archives.

Shutdown immediate;

2. Shutdown the primary Database;

Shutdown immediate;

Start the database of dataguard environment:

On Standby Database:
1. startup the Standby database upto mount state.

Startup mount

2. Start the recovery process with following command:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE disconnect from session;

Primary Database:
1. Start the database.

Startup