Stop and Start the shipping of archiving in Dataguard environment

Stop and Start the shipping of archive redo files in Dataguard Environment

Stop the Shipping of archive file to standby Server

-- On Primary Database disable the log archive parameter.
conn /@prim as sysdba
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH SID='*';

--If you have multiple standby then you need to difer value for other log archive dest state parameter as they configured in your environment.

Start the Shipping of archive file to standby Server

-- On Primary Database Enable the log archive parameter.
conn /@prim as sysdba
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH SID='*';

--If you have multiple standby then you need to Enable value for other log archive dest state parameter as they configured in your environment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.