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.
This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply