| 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)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
