Hi everyone,
My system details are as follow:
OS: Linux
Oracle: 11gR2
Primary DB's: 2 node RAC
Standby: Physical
I've done the whole setup and configured data guard broker but keep on getting +"Error: ORA-16737: the redo transport service for standby database "STANDBY" has an error"+ on the primary.
I've found the problem, it is the log_archive_dest_2 parameter that is set as:
log_archive_dest_2='service=STANDBY LGWR ASYNC NOAFFIRM delay=0
optional compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name=STANDBY net_timeout=30 valid_for=(all_logfiles,primary_role)' scope=both;
if I change the service to the correct service name with command
alter system set log_archive_dest_2='service=STANDBY.domain.com LGWR ASYNC NOAFFIRM delay=0
optional compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name=STANDBY net_timeout=30 valid_for=(all_logfiles,primary_role)' scope=both;
The error disappears in dgmgrl but the log_archive_dest_2 automatically change back to +"service=STANDBY"+ after a few seconds.
What can cause this parameter change?
Thanks in advance.