The following details the steps needed to setup bi-directional replication.
There is no database upgrade in this case.
| 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 |
| 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 |
| Number | Date | Description | Commands |
|---|---|---|---|
| 7 | Setup Data Guard on moldbb1/2 |
| 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; |
| 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 |