Differences

This shows you the differences between two versions of the page.

--- prod_install [2016/09/01 10:08] – z0hpvk
+++ prod_install [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Zero Downtime Database Migration (10gR2 to 10gR2) ======
+====== 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^
@@ Line 23: / Line 25: @@
 | |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| |