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 |
| 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'); |
| 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> |
| 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 | |
