ORA-16740: redo transport service for standby database "wcss1" incorrectly set to ALTERNATE
I have following configuration in my dataguard environment
(Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production running on Redhat Linux )
Primary database - wcs
Standby database - wcss1
Far sync instance - wcsfs
Following are the parameter settings :
--------On primary
SQL> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=wcs
SQL> show parameter log_archive_dest_2
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string SERVICE=wcsfs SYNC AFFIRM MAX_FAILURE=1 ALTERNATE=LOG_ARCHIVE_DEST_3 VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=wcsfs