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
