Home » Server Options » RAC & Failsafe » 9i RAC Sun Cluster 24/7/365 DG -> 10g OCS upgrade
9i RAC Sun Cluster 24/7/365 DG -> 10g OCS upgrade [message #152131] Wed, 21 December 2005 05:25 Go to next message
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
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 Go to previous message
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.
Previous Topic: db creation in cluster db
Next Topic: Raw-Devide in RAC
Goto Forum:
  


Current Time: Sat May 08 09:02:08 CDT 2021