Occasionally you may the opportunity to setup GoldenGate in a remote environment for both capture and delivery.

RDU SDU Oraganism

BDP Stuff

They call the BDP a "product" because the value for BDP is indeed a multiplication of the average round-trip time and the total bandwidth of the network cable.

For example, if a network has a bandwidth of 100 megabytes per second and a round trip time of 5 milliseconds, the recv_buf_size and send_buf_size sqlnet.ora parameters values should be set to a value of at least 63k:

(100X106) * (5X10-3) bits ~= 63k:.

100,000,000 bits 1 byte 5 seconds
---------------- x ------ x --------- = 62,500 bytes
1 second 8 bits 1000

To prevent network contention, the values for recv_buf_size and send_buf_size should be set to the maximum amount of data that might be sent, at least 3x the value of your bandwidth delay product (BDP).

Send and Receive Buffers

Standby Network Tuning

 

If you are tuning your network to maximize throughput (as opposed to tuning for fast response time), Oracle suggests setting recv_buf_size and send_buf_size sqlnet.ora parameters equal to 3 times the Bandwidth Delay Product (BDP).

 

MAA Database Migration with a GoldenGate Hub

When a transaction is committed on the source database, only new data is written to the Redo log. However for Oracle to apply these transactions on the destination database, the "before image" key values are required to identify the effected rows. This data is also placed in the trail file and used to identify the rows on the destination, using the key value the transactions are executed against them. This is a key consideration for data sizing for the trail files.

Important considerations for bi-directional replication

The customer should consider the following points in an active-active replication environment.

• Primary Key: Helps to identify conflicts and Resolve them.
• Sequences: Are not supported. The work around is use to use odd/even, range or concatenate sequences.
• Triggers: These should be disabled or suppressed to avoid using uniqueness issue
• Data Looping: This can be easily avoided using OGG itself
• LAG: This should be minimized. If a customer says that there will not be any LAG due to network or huge load, then we don’t need to deploy CRDs. But this is not the case always as there would be some LAG and these can cause conflicts.
• CDR (Conflict Detection & Resolution): OGG has built in CDRs for all kind of DMLs that can be used to detect and resolve them.
• Packaged Application: These are not supported as it may contain data types which are not support by OGG or it might not allow the application modification to work with OGG.

OGG can be installed on ACFS

No, OGG binaries are not supported on DBFS. You can however store parameter files, data files (trail files), and checkpoint files on DBFS.

Operating System
a. Memory – Ensure that there is enough memory. This will determined by the number of GoldenGate processes which will be configured on the server.

b. Memory Per Process – Dependent on the size of the transactions and the amount of concurrent transactions in the database. By default one Goldengate extract or replicat process can take up to 8G of memory.

c. Swap space – Configure reasonable swap space in case Goldengate processes swap due to low memory condition.

d. Disk space – Enough disk space to hold the trail files for the required retention period. As a starting point it could be made approximately the same as the amount of archive logs generated in a specific time period. Also consider the amount of space that might be needed for an initial load.

All the current papers on GoldenGate are available on the Oracle MAA site (http://www.oracle.com/technetwork/database/features/availability/oracle-database-maa-best-practices-155386.html).

1. Oracle GoldenGate Performance Best Practices: http://www.oracle.com/technetwork/database/availability/maa-gg-performance-1969630.pdf

2. Oracle GoldenGate with RAC (this is currently being updated and the new version should be available in about 2 weeks): http://www.oracle.com/technetwork/database/features/availability/maa-goldengate-rac-2007111.pdf

3. Transparent Role Transitions with Oracle Data Guard and Oracle GoldenGate: http://www.oracle.com/technetwork/database/availability/ogg-adg-2422372.pdf

Current Whitepapers Page

Full Stack Role Transition ACFS April 2016

Full Stack Role Transition DBFS August 2016

Transparent Role Transitions With Oracle Data Guard and Oracle GoldenGate Feb 2015

GoldenGate Performance Best Practices Nov 2014

gg_zipfile_chk()
#######################################################
# If the directory exists see if the files is there
#######################################################
{
clear
echo
echo
echo "Checking for the V46695-01.zip file"
echo
echo
echo "Checking /ora01/Oracle_SW/gg121 for zip file ......."
echo

if [ -f /ora01/Oracle_SW/gg121/V46695-01.zip ]; then
   echo "..../ora01/Oracle_SW/gg121/V46695-01.zip file found....."
else
   echo "..../ora01/Oracle_SW/gg121/V46695-01.zip file not found."
fi

echo
echo "Checking /ora01/Oracle_SW/1212111/gg121 for zip file ......."
echo

if [ -f /ora01/Oracle_SW/gg121/1212111/V46695-01.zip ]; then
   echo "..../ora01/Oracle_SW/gg121/1212111/V46695-01.zip file found....."
else
   echo "..../ora01/Oracle_SW/gg121/1212111/V46695-01.zip file not found."
fi

echo
echo "Checking for the xagpack_7b.zip file"
echo

echo
echo "Checking /ora01/Oracle_SW/xag71 for zip file ......."
echo

if [ -f /ora01/Oracle_SW/xag71/xagpack_7b.zip ]; then
echo "..../ora01/Oracle_SW/xag71/xagpack_7b.zip file found....."
else
echo "..../ora01/Oracle_SW/xag71/xagpack_7b.zip file not found."
fi

echo
}

 

gg_unzip()
{

echo
echo "Unzip the Oracle GG binaries......."
echo

cd /ora01/Oracle_SW/gg121/1212111
unzip V46695-01.zip

}

xag_unzip()
{

####################################################
# Once the software is copied to the location
# Unzip the software
# This function assumes the XAG software has been
# copied to the correct directory on the /ora01
####################################################

cd /ora01/Oracle_SW/xag71
unzip xagpack_7b.zip

}

Important Fixes required to implement Oracle Automatic Storage Management File System (ACFS) on Oracle Exadata Database Machine (Doc ID 2022172.1)

 

Per the below noted doc ID ACFS on Exadata is now supported for GoldenGate files

Oracle ACFS Support on Oracle Exadata Database Machine (Linux only) (Doc ID 1929629.1)

Oracle ACFS use cases on Exadata Database Machine

• The initial design objective of ACFS on Exadata was to provide a general purpose, industry standard, POSIX compliant cluster file system on Exadata platforms to manage all general purpose files with good performance. Oracle ACFS also supports the industry standard network protocols NFS/CIFS and offers a highly available NFS solution with the HANFS feature.
• Oracle ACFS now supports Oracle Database 10g 10.2.0.4 and 10.2.0.5 releases. Customers can now migrate their 10g Oracle Databases to Exadata and upgrade later. This makes Exadata a more flexible platform enabling consolidation and easy migration for customers.  See Document 1965897.1 for additional details.
• Oracle ACFS may be configured as a shared Oracle database home, middleware and application homes/binaries and shared files like Oracle Golden Gate trail files etc…
• Oracle ACFS can be configured for use with the database particularly to leverage Oracle ACFS snapshots for database testing and development.

 

If you are setting up GoldenGate for CDBs you must use the integrated extract mode.

GG Presentation