Sandra,
Adding to Seth’s suggestion, consider using DBFS, and install GG on it, and you
will never have to worry about it. It is a neat way for filesystem replication,
and *not* buggy(compared to ACFS).
Thanks,
Yogi
Disclaimer: The information transmitted is intended for the person or entity to
which it is addressed and may contain confidential, privileged or copyrighted
material or attorney work product. If you receive this in error, please contact
the sender and delete the material from any system. Any unauthorised copying,
disclosure or distribution of the material in this e-mail is strictly
forbidden. Any comments or statements made are not necessarily those of
Fidelity. All e-mails may be monitored or recorded.
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Seth Miller
Sent: 12 February 2020 23:58
To: dmarc-noreply@xxxxxxxxxxxxx
Cc: sbecker6925@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Installing GoldenGate on standby server
Sandra,
If you want GG to work properly in the event of a switchover/failover, it
should be tied into the clusters using XAG.
https://www.oracle.com/technetwork/database/availability/con6570-availabilityggmicroservices-3960454.pdf<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.oracle.com_technetwork_database_availability_con6570-2Davailabilityggmicroservices-2D3960454.pdf&d=DwMFaQ&c=SsZxQMfaWJ1sSVfloc5FVGba8BA_qR4Jzdt8ol2oSPA&r=z73EKtGMkOyHMZwSjVYW896tQVgTZQlAucPsWFx6Th0&m=izvBpj72dfxwa7Xflq4ATpKjRq5ymppmH-HsqKdIqIs&s=vHYL7_1OSBuj5RXeMuvGg5sSyvWZ8-jGAn6niDxdDm4&e=>
Seth
On Tue, Feb 11, 2020 at 3:44 PM Reen, Elizabeth
<dmarc-noreply@xxxxxxxxxxxxx<mailto:dmarc-noreply@xxxxxxxxxxxxx>> wrote:
The standby GG will not know where the production GG left off.
The easiest way out of the problem is to have a third server run the GG.
Liz
From: [External]
oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> On Behalf
Of [External] Sandra Becker
Sent: Thursday, February 6, 2020 12:19 PM
To: oracle-l
Subject: Installing GoldenGate on standby server
Oracle
EE12.1.0.2<https://urldefense.proofpoint.com/v2/url?u=http-3A__12.1.0.2&d=DwQFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=l_Z3Ar8mzckb948Rt9wMjBslZHQXg-VP_9H9c6huufk&s=nK00B0vn5wpJgY3_s9lSAGEfLe9B7Aq_oL6vTFLt4Us&e=>
GoldenGate
12.2.0.1<https://urldefense.proofpoint.com/v2/url?u=http-3A__12.2.0.1&d=DwQFaQ&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=l_Z3Ar8mzckb948Rt9wMjBslZHQXg-VP_9H9c6huufk&s=9TnR7qHSGcVkfMNqLdv2u4ZqvL9SxA0nZi96U7Zr5c8&e=>
I'm fairly new to supporting GoldenGate and all the DBAs who used to do it are
no longer at the company. We also lack good documentation, which I am working
to rectify. We are preparing to move a production database to a new servers &
storage that will have a primary and a standby vs the single instance we have
now. We currently use GoldenGate to replicate data from several tables to
another database on another server. I don't want to be in the position of
needing to install GG on the standby server in the event we need to
switchover/failover and cause delays in the replication to the other database.
From what I've read, I can install it, but not start it on the standby server
so it will be ready in the event we need it. By design, the primary and
standby servers will not share anything. If you have a moment, please review
the steps I think I need and let me know if this will work or if I've missed
anything.
1. Download the same version of GG to the standby that the primary is running
2. Run the installer
3. Do not check "Start manager" during the install or check "Start Manager"
and stop it after the installation (not sure which is the better way to go)
4. Copy the parameter files from the primary to the standby
5. Update the team documentation to note that any changes to the primary
must also be done on the standby
--
Sandy B.
