Database Solutions

Upgrade Instructions for Oracle GoldenGate for Oracle Database  These instructions contain steps for upgrading to Oracle GoldenGate 12.1.2 for Oracle Database.  1. Upgrade Instruction  To upgrade:  1. (Source system) The new Extract might need to start processing from the normal recovery checkpoint, rather than the bounded recovery checkpoint, if the first record of the oldest open transaction at the time that you stop Extract is in a log that is not on the system. Use the following command in GGSCI to determine the oldest archive log that you might need to restore when Extract starts. The Recovery Checkpoint field shows the oldest log needed for recovery.   GGSCI> INFO EXTRACT group, SHOWCH You have two options:    You can restore the archives back to, and including, the one shown in the recovery checkpoint shown with INFO EXTRACT.   You can clear out the long-running transactions that apply to the Extract that you are upgrading....

 This Blog contains a summary of the environment, and a detailed list of steps used to create the Oracle GoldenGate CRS resources for HA in an Oracle RAC environment.  This procedure creates multiple CRS resources for Oracle GoldenGate. The following are the resources: 1.      Resource for a dedicated VIP (one per cluster) for remotely communicating with the active node in the cluster running Oracle GoldenGate a.      Called “ggvip” 2.      Resource for controlling the Oracle GoldenGate Manager process (mgr) a.      CRS will only check and start/stop the Oracle GoldenGate Manager process                                                i.    ...