This is an old revision of the document!

Zero Downtime Database Migration (10gR2 to 10gR2)

Installation

Number	Date	Description	Commands
1	12/09/2016	Install GoldenGate on both hosts using shared storage visible by both RAC nodes.	mkdir -p /u01/app/oracle/product/11.2.0/gg_1
		Version 11.2.0.1.20 (Patch 18377868)	tar -xvof fbo_ggs_Solaris_sparc_ora10g_64bit.tar
		Location: and-hsk-rac10inta1 $GGHOME/fbo_ggs_Solaris_sparc_ora10g_64bit.tar	./ggsci
			CREATE SUBDIRS

Number	Date	Description	Commands
2		Configure Production instance for GoldenGate
	12/09/2016	Create GoldenGate Database User	$GGHOME/dirsql/gg_user.sql
	12/09/2016	Turn Recycle Bin off	alter system set recyclebin=off sid = '*';
	12/09/2016	Install DDL Scripts	$GGHOME/dirsql/ddl_create.sql
	12/09/2016	Add transactional log groups for all tables in MAILONLINE, REGISTRATION, RDRCOMMENTS	$GGHOME/diroby/trandata.oby
	12/09/2016	Create exceptions table in GGATE schema	$GGHOME/dirsql/exceptions.sql
		Create Database Links, Sequence Logging Tables and Scheduled Job	$GGHOME/dirsql/mol_sequences_other.txt
		Install Sequence Packages	$GGHOME/dirsql/mol_sequences_10g.pkg

Number	Date	Description	Commands
3	12/09/2016	Configure ./GLOBALS parameter on both databases	GLOBALS file in $GGHOME
	12/09/2016	Configure and Start Manager process on both databases	mgr.prm file in $GGHOME/dirprm
			./ggsci and START MGR

Number	Date	Description	Commands
4	12/09/2016	Increase TCP/IP Packet Size on all hosts to 256K	ndd -set /dev/tcp tcp_recv_hiwat 262144
			ndd -set /dev/tcp tcp_xmit_hiwat 262144
			Also add details to /etc/rc2.d/S99ndd

Number	Date	Description	Commands
5	13/09/2016	Configure GoldenGate as a Clusterware Resource on production/replication servers	See Document Oracle GoldenGate and RAC High Availability