High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

data-guard stop sync

Hi  We have data guard 11.2  and need to stop data guard

primary :

log_archive_config='dg_config=(DBPRI,DBSEC)'

*.log_archive_dest_1='location=use_db_recovery_file_dest'

*.log_archive_dest_2='service=DBSEC lgwr async noaffirm valid_for=(online_logfiles,primary_role) db_unique_name=DBSEC'

*.log_archive_dest_3='location=use_db_recovery_file_dest valid_for=(standby_logfile,standby_role)'

*.log_archive_dest_state_2='enable'

*.log_archive_dest_state_3='ENABLE'

*.log_archive_dest_state_4='ENABLE'

secondary:

log_archive_config='dg_config=(DBPRI,DBSEC)'

*.log_archive_dest_1='location=use_db_recovery_file_dest valid_for=(all_logfiles,all_roles) db_unique_name=DBSEC'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center