GoldenGate replication to standby DB

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

GoldenGate replication to standby DB

Roshan
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

Reply | Threaded
Open this post in threaded view
|

Re: GoldenGate replication to standby DB

ErmanArslansOracleBlog
Administrator
Did you configure DBFS on the mining DB?
Did you put the relevant Goldengate files there?

Reference: Oracle GoldenGate files that need to be accessible from another host should be placed in DBFS. This includes the trail files (dirdat), checkpoint files (dirchk), parameter files (dirprm), bounded recovery files (BR), credential store files (dircrd) and temporary files (dirtmp).
Reply | Threaded
Open this post in threaded view
|

Re: GoldenGate replication to standby DB

Roshan
Hi,

will mount the shared filesystem '/dev/asm/gg-266' on DR site.

It seems to be acfs:
/dev/asm/gg-266                 -               /ogg    acfs    -       no

Entry from vfstab shown above.

Regards,

Roshan