Login  Register

GoldenGate replication to standby DB

Posted by Roshan on Aug 20, 2020; 8:17am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/GoldenGate-replication-to-standby-DB-tp8658.html

Solaris 11.4
source db (RAC 2 nodes) -- > (downstream replication) --> mining DB(RAC 2 nodes) (extract and replicat run here) ---> (dataguard replication) ---> standby DB(standalone)

Hello Erman,

I would like to setup replication of golden gate files from the mining DB - located on a shared filesystem
/dev/asm/gg-266        500G   141G       359G    29%    /ogg

Dataguard replication of the mining DB has been completed. Should I mount the shared filesystem on the standalone Standby DB?
https://www.oracle.com/technetwork/database/availability/ogg-adg-2422372.pdf

Kindly confirm if parameters below need to be set in extract parameter file:
page 9 to add TRANLOGOPTIONS HANDLEDLFAILOVER on mining DB extract parameter file.

Fast-Start Failover (FSFO)

TRANLOGOPTIONS _FAILOVERTARGETDESTID 5

Regards,

Roshan