Recommended configuration

Although Replication Agent can be configured to replicate data from either the Data Guard primary database or a Data Guard standby database, Sybase recommends that you configure Replication Agent to read from a Data Guard standby database transaction log. This way, if the primary Data Guard database fails over to the standby Data Guard database, Replication Agent is already connected to a working Oracle database, and replication is not disrupted.

If you configure Replication Agent to read from a Data Guard standby database transaction log, pds_username must have alter database permission.