What are the required Database Patches for Oracle GoldenGate Integrated Capture and Delivery?6/23/2017 Please refer to the Oracle Support Note: Doc ID 1557031.1 Oracle GoldenGate -- Oracle RDBMS Server Recommended Patches.
0 Comments
In Oracle MAA (Maximum Availability Architecture), Oracle Database is protected by Oracle Active Data Guard (ADG) to move users from the primary database to the standby database as planned (switchover) or unplanned (failover) [1]. The process is also called the Data Guard Role Transition. During the role transition, Oracle GoldenGate needs to seamlessly follow the transition to maintain non-stop services. In this blog, l will briefly summarize some key concepts of Oracle GoldenGate failover configuration.
First, the automatic failover configuration requires the following:
Second, the most critical parts of this configuration include:
Third, during the role transition, the Oracle GoldenGate extract will abend after the old primary is no longer available. However, after the new primary becomes available, the extract restarted by Oracle GoldenGate Manager will resume the replication automatically. Don't worry about the Oracle GoldenGate extract doesn't replicate at the beginning. The Oracle GoldenGate extract will wait until the new standby database instance is up before it starts to replicate the transactions.
Can I use ACFS instead of DBFS to store Oracle GoldenGate for failover support?
Yes, you can, but it's not recommended. This is because ACSF is not integrated with role transitions or CRS and there are a lot of manual processes and limitations with ACFS.[2]
Resources
If you only have terminal access (such as an Amazon AWS EC2 environment) you need to install Oracle GoldenGate for Oracle in OUI silent mode. The following are the steps.
Step 1: Creating the response file You can update the response file available at the $DOWNLOAD_HOME/Disk1/response folder. The following is an example. #################################################################### ## Copyright(c) Oracle Corporation 2014. All rights reserved. ## ## ## ## Specify values for the variables listed below to customize ## ## your installation. ## ## ## ## Each variable is associated with a comment. The comment ## ## can help to populate the variables with the appropriate ## ## values. ## ## ## ## IMPORTANT NOTE: This file should be secured to have read ## ## permission only by the oracle user or an administrator who ## ## own this installation to protect any sensitive input values. ## ## ## #################################################################### #------------------------------------------------------------------------------- # Do not change the following system generated value. #------------------------------------------------------------------------------- oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_sc hema_v12_1_2 ################################################################################ ## ## ## Oracle GoldenGate installation option and details ## ## ## ################################################################################ #------------------------------------------------------------------------------- # Specify the installation option. # Specify ORA12c for installing Oracle GoldenGate for Oracle Database 12c and # ORA11g for installing Oracle GoldenGate for Oracle Database 11g #------------------------------------------------------------------------------- INSTALL_OPTION=ORA11g #------------------------------------------------------------------------------- # Specify a location to install Oracle GoldenGate #------------------------------------------------------------------------------- SOFTWARE_LOCATION=/home/ec2-user/gg #------------------------------------------------------------------------------- # Specify true to start the manager after installation. #------------------------------------------------------------------------------- START_MANAGER= #------------------------------------------------------------------------------- # Specify a free port within the valid range for the manager process. # Required only if START_MANAGER is true. #------------------------------------------------------------------------------- MANAGER_PORT= #------------------------------------------------------------------------------- # Specify the location of the Oracle Database. # Required only if START_MANAGER is true. #------------------------------------------------------------------------------- DATABASE_LOCATION= ################################################################################ ## ## ## Specify details to Create inventory for Oracle installs ## ## Required only for the first Oracle product install on a system. ## ## ## ################################################################################ #------------------------------------------------------------------------------- # Specify the location which holds the install inventory files. # This is an optional parameter if installing on # Windows based Operating System. #------------------------------------------------------------------------------- INVENTORY_LOCATION=/home/ec2-user/gg/inventory #------------------------------------------------------------------------------- # Unix group to be set for the inventory directory. # This parameter is not applicable if installing on # Windows based Operating System. #------------------------------------------------------------------------------- UNIX_GROUP_NAME=ec2-user
Step 2: Run OUI with Silent Mode
Make sure you add swap space for the installation(How to Add SWAP Space for GoldenGate Installation?) and run the following command:
./runInstaller -silent -nowait -responseFile /home/ec2-user/gg/fbo_ggs_Linux_x64_shiphome/Disk1/response/ggorcl.rsp
After the installation, run the following command as the root user:
[ec2-user@ip-10-184-238-104 Disk1]$ sudo /home/ec2-user/gg/inventory/orainstRoot.sh Changing permissions of /home/ec2-user/gg/inventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /home/ec2-user/gg/inventory to ec2-user. The execution of the script is complete.
Created 1/11/2016, Last Updated 6/8/2017
|
GoldenGate for Oracle DBInformation, Tip and Trick to use Oracle GoldenGate for Oracle Database. Links
- Installing and Configuring Oracle GoldenGate for Oracle Database (12.2) - Oracle Support Policy Archives
March 2018
Categories
All
|
Jinyu's Blog |
|