User Tools

Site Tools


prod_install

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
prod_install [2016/09/01 11:18] z0hpvkprod_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 ===== ===== Installation =====
 ^ Number ^Date ^Description ^Commands^ ^ Number ^Date ^Description ^Commands^
Line 49: Line 51:
 ^ Number ^Date ^Description ^Commands^ ^ Number ^Date ^Description ^Commands^
 |**8**|19/09/2016|Convert Data Guard to Read/Write using Failover Method|alter database recover managed standby database cancel;| |**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 -moldbb2|+| | | |srvctl stop instance -d moldbb -moldbb2|
 | | | |alter database recover managed standby database finish force;| | | | |alter database recover managed standby database finish force;|
 | | | |alter database activate physical standby database;| | | | |alter database activate physical standby database;|
Line 58: Line 60:
 |**9**|19/09/2016|Turn off scheduled jobs on moldbb1/2| exec dbms_scheduler.disable('MO_NIGHTLY_CHAIN_1_JOB');| |**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');| | | | |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| |
  
  
  
prod_install.1472728710.txt.gz · Last modified: 2025/03/08 22:23 (external edit)