Sunday, June 30, 2013

Oracle Golden Gate

http://www.oraclegis.com
http://ggsig.blogspot.in/2012/12/golden-gate-replication-oracle-db.html --> Steps to configure Replication between Oracle->Oracle
http://oraclespot.wordpress.com/2011/06/15/oracle_goldengate/

Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory


Move to the GG install directory and invoke ggsci.. 
ggsci> dblogin userid <>,password <>

-------------------------------------------------------------------------------------------------------

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=ggdb1
export GG_HOME=/u01/app/oracle/ggs/11.2.0
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$GG_HOME:$LD_LIBRARY_PATH
export PATH=GG_HOME:$ORACLE_HOME/bin:$PATH


--------------------------------------------------------------------------------

Before configuring Golden Gate at DB level:

1). Put database in archivelog mode --> Requires bounce till 11gR2, but not from 12c(Need to check).
2). Enable Supplemental Logging
SELECT SUPPLEMENTAL_DATA_LOG_MIN FROM V$DATABASE;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

1 comment:

XDuce Marketing said...

Oracle Goldengate is probably the best replication software and it is very easy to configure and deploy it in large scale environment. We as XDuce are Oracle GoldenGate services provider. Join us here for more information: GoldenGate Services