how to make standby db (DR) delay by 2 hours in data guard config.
Oracle EE - 19.20.0.0 , non RAC, db with 2 standbys (one HA and one DR). I setup all them in max availability with Sync - AFFIRM. But now need to make DR standby db delay by 2 hours than Primary. Kindly suggest which parameter I need to change in DG to setup this delay.
Additional info: DG configured + fsfo enabled with observer. Dbs are hosted in RHEL 8 linux server. HA db delay=0 .
Below are the log_archive_dest values which came automatically while creating DG.
log_archive_dest_3>>> service="DR_primary", SYNC AFFIRM delay=0 optional compression=disable max_failure=0 reopen=300 db_unique_name="DR " net_timeout=30, valid_for=(online_logfile,all_roles)