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' 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.
https://dbaclass.com/article/remove-dataguard-configuration-from-primary-database/
No comments:
Post a Comment