====== Zero Downtime Database Migration ======
The following details the steps needed to setup bi-directional replication.\\
There is no database upgrade in this case.
===== 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|

===== Configuration =====
^ 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|

===== GLOBALS and MGR =====
^ 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|

===== TCP/IP Packet Size =====
^ 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|

===== Create Clusterware Resource =====
^ 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|

===== Configure Extract / Data Pump =====
^ Number	^Date	^Description	^Commands^
|**6**|13/09/2016|Configure Extract / Data Pump processes on and-hsk-raca1/2|Parameter files in $GGHOME/diroby|
| |13/09/2016|REGISTRATION Schema|Obey files in $GGHOME/diroby|
| |14/09/2016|MAILONLINE Schema| |	
| |15/09/2016|RDRCOMMENTS Schema| |	
| |19/09/2016|All Other Schemas| |

===== Create Data Guard =====
^ Number	^Date	^Description	^Commands^
|**7**| |Setup Data Guard on moldbb1/2| |

===== Failover Data Guard =====
^ Number	^Date	^Description	^Commands^
|**8**|19/09/2016|Convert Data Guard to Read/Write using Failover Method|alter database recover managed standby database cancel;|
| | | |srvctl stop instance -d moldbb -i moldbb2|
| | | |alter database recover managed standby database finish force;|
| | | |alter database activate physical standby database;|
| | | |alter database open;|

===== Scheduled Jobs =====
^ Number	^Date	^Description	^Commands^
|**9**|19/09/2016|Turn off scheduled jobs on moldbb1/2|	exec dbms_scheduler.disable('MO_NIGHTLY_CHAIN_1_JOB');|
| | | |exec dbms_scheduler.disable('VIDEO_MAINTENANCE');|

===== Configure/Start Replication =====
^ Number	^Date	^Description	^Commands^
|**10**|19/09/2016|Configure Replicat process on moldbb1/2|Parameter files in $GGHOME/dirprm|
| | | |Obey files in $GGHOME/diroby|
| |19/09/2016|Start replicat process at SCN from select statement|select standby_became_primary_scn from v$database;|
| | | |start replicat repmol01 atcsn <SCN>|

===== Configure for Bi-Directional =====
^ Number	^Date	^Description	^Commands^
|**11**|20/09/2016|Configure Extract / Data Pump processes on moldbd1|Parameter files in $GGHOME/dirprm|
| |21/09/2016|Configure Replicat process on and-hsk-raca1/2 (DO NOT START)|Obey files in $GGHOME/diroby|
| |21/09/2016|REGISTRATION Schema| |
| |22/09/2016|MAILONLINE Schema| |
| |26/09/2016|RDRCOMMENTS Schema| |
| |27/09/2016|All Other Schemas| |