ORA-16737: the redo transport service for standby database 'aaa' has an error

ORA-16737: the redo transport service for standby database 'aaa' has an error

ORA-16737: the redo transport service for standby database "aaa" has an error

#1

CHECK: when you have the above problem, you will get the protection mode in the    Primary & standby v$database.protection_level shows  as "RESYNCHRONIZATION"

select protection_mode, protection_level from v$database; 

#2

CHECK: whether you are getting any in the archive location 

select dest_id,status,error from v$archive_dest;

#3

CHECK: Check whether online redo log are configured in the primary & standby database properly, it includes size & accessibility 

Note: primary &standby online redo log should be same

select group#,thread#,sequence#,bytes,archived,status from v$log;  

#4

CHECK: Check whether standby redo log are configured in the primary &standby database properly, it includes size & accessibility 

Note: primary &standby standby redo log should be same 

select member from v$logfile where type='STANDBY'; 

#5

CHECK: Check parameters are configured properly; some times instance parameters have a different value. Ex: some common parameter will have different value for each instance in the cluster database. You need to check on the primary &standby cluster database environment.

#6

Check whether maximum Availability is enabled, when you have LogXptMode is synchronization

SYMP:

ORA-16629: database reports a different protection level from the protection mode

In DG Broker

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;

Succeeded.

#7 check your password with the setting
A)
1) check for the "sec_case_sensitive_logon" parameter.
2) if the problem exist, create the password file with ignorecase option in the orapwd password creation.
3) after recreating the password, restart both the primary & standby database.