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

MOSC Banner

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

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