9i RAC Sun Cluster 24/7/365 DG -> 10g OCS upgrade [message #152131] |
Wed, 21 December 2005 05:25 |
fullerdj
Messages: 2 Registered: December 2005 Location: Leeds , England
|
Junior Member |
|
|
I wish to know if anyone has been trough this pain yet and also if it is possible to do with zero downtime (haha).
Upgrade from 9i Sun Cluster(3.1) Veritas in 4 node RAC config with 4 node dataguard at secondary site.
Upgrade to 10gR2 Oracle Cluster Services (OCS) with Veritas initally but moving to ASM.
Has anyone 'been there, seen it, done it and got the teashirt?'
Can this be done with zero downtime.
Our Sun support group want idealy 5 days to strip out the Sun Cluster software!
I want the Full OCS stack and NOT siting on top of Sun Cluster Services. How far do I have to back out the Sun Cluser software before Oracle does a full OCS install?
|
|
|
Re: 9i RAC Sun Cluster 24/7/365 DG -> 10g OCS upgrade [message #152154 is a reply to message #152131] |
Wed, 21 December 2005 07:16 |
|
Mahesh Rajendran
Messages: 10708 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
>>Can this be done with zero downtime.
For giggles,
Let us ASSUME it is possible.
Do you still prefer rollout without even testing?
The realistic possible solution is, you can minimize the downtime.
(Depends on volume of data. for 60 Gb database , i once had 20 minute downtime. Move data,collect statistics,switch users).
What you can do is
Create your new environment in parallel.
Use materialzed views to collect data into new environment.
Do your testing.
If everything is all good, stop users, do one final refresh,switch the users new environment.
[Updated on: Wed, 21 December 2005 07:16] Report message to a moderator
|
|
|
Re: 9i RAC Sun Cluster 24/7/365 DG -> 10g OCS upgrade [message #152161 is a reply to message #152154] |
Wed, 21 December 2005 07:44 |
fullerdj
Messages: 2 Registered: December 2005 Location: Leeds , England
|
Junior Member |
|
|
Neet idea. Very manageable. Yes I have a complete test environment to try this first as the Live env data is very high quality and indespencable. The mv route won't work because the current data size is 11TB with growth of approx 750GB per month and a 5% churn.
|
|
|