Home » RDBMS Server » Server Administration » upgrade from 9.2.0.8 2 node RAC to 11.2.0.3 2 node RAC.. please review plan (Oracle 9.2.0.8 AIX 5.3 to Oracle 11.2.0.3 AIX 7.1)
upgrade from 9.2.0.8 2 node RAC to 11.2.0.3 2 node RAC.. please review plan [message #578942] Wed, 06 March 2013 08:59
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

I have to upgrade 9i database running on AIX 5.3 on power 5 to 11gR2 running on AIX 7.1 on power 7 box.

I have outlined some major steps for this activity. Please review and suggest.

Current Setup

PROD:
Oracle DB: 9.2.0.8 2 node RAC
OS: AIX 5.3
Platform: IBM Power 5
DB size: ~3 TB

DR:
Oracle DB: 9.2.0.8 SIngle instance
OS: AIX 5.3
Platform: IBM Power 5

Intended setup:

PROD:
Oracle DB: 11.2.0.3 2 node RAC
OS: AIX 7.1
Platform: IBM Power 7

DR:
Oracle DB: 11.2.0.3
OS: AIX 7.1
Platform: IBM Power 7


Plan for migration:

Option 1:
Using Goldengate (Near 0 downtime and both setups running in parallel for some time using bi-directional sync)

CUrrent PROD setup alias--- MAC_PROD_ORG

New PROD setup alias --- MAC_PROD_NEW

CUrrent DR setup alias--- MAC_DR_ORG

New DR setup alias --- MAC_DR_NEW

Interim machine alias: MAC_PROD_INT (running AIX 5.3 and 9i database single instance, 11g will be new installation on this machine)

Steps:

In PROD:
1. Configure Goldne gate on MAC_PROD_ORG
2. STart capture process on MAC_PROD_ORG
3. Clone MAC_PROD_ORG to MAC_PROD_INT
4. Install 11gR2 software on MAC_PROD_INT
5. Upgrade MAC_PROD_INT from 9i to 11gR2
6. Take RMAN full backup of MAC_PROD_INT
7. Configure MAC_PROD_NEW by installing 11gR2 2 node setup with ASM
8. Restore RMAN backup taken in step 6.
9. Start the goldengate capture & delivery process on MAC_PROD_NEW
10. wait for both MAC_PROD_ORG and MAC_PROD_NEW to get in sync and then run in parallel for say 2 weeks for load and functional testing on new setup
11. Switch application IPs pointing to new setup (MAC_PROD_NEW)

In DR:
1. After step 11 in PROD env, clone MAC_PROD_NEW to MAC_DR_NEW and create standby there.


Option2:
Without Goldengate (Downtime needed):

In Prod:
1. Configure MAC_PROD_NEW by installing 11gR2 2 node setup with ASM
2. Clone MAC_PROD_ORG to MAC_PROD_INT
3. Install 11gR2 software on MAC_PROD_INT
4. Upgrade MAC_PROD_INT from 9i to 11gR2
5. Take RMAN full backup of MAC_PROD_INT
6. Restore RMAN backup to MAC_PROD_NEW taken in step 5.
7. Allow load and functional testing in MAC_PROD_NEW -- Till this time, no downtime
8. When testing gets over, perform step 2, 4, 5, 6 to have MAC_PROD_NEW have latest data. -- This step will be performed during downtime.
(Expected downtime 12-15 hrs)

In DR:
1. AFter step 8 in PROD env, clone MAC_PROD_NEW to MAC_DR_NEW and create standby database

Option 3:
Using transportable tablespaces

In Prod:
1. Configure MAC_PROD_NEW by installing 11gR2 2 node setup with ASM
2. Clone MAC_PROD_ORG to MAC_PROD_INT
3. Take norows export dump from MAC_PROD_INT.
4. Take export using transportable tablespaces of tablespaces in MAC_PROD_INT
5. Import the dump taken in step 4 into MAC_PROD_NEW
6. Import the dump taken in step 3 to MAC_PROD_NEW
7. Allow load and functional testing in MAC_PROD_NEW -- Till this time, no downtime
8. When testing gets over, perform step 3, 4, 5, 6 to have MAC_PROD_NEW have latest data. -- This step will be performed during downtime. And data will be exported from MAC_PROD_ORG instead of MAC_PROD_INT
(Expected downtime 10-12 hrs)
Previous Topic: how to create best profile?
Next Topic: LOG History in Standby DB
Goto Forum:
  


Current Time: Thu Aug 28 20:32:21 CDT 2014

Total time taken to generate the page: 0.91651 seconds