Re: Upgrading Oracle cluster 11gR2 on Solaris

From: Andrea Monti <ilsuonogiallo_at_gmail.com>
Date: Fri, 22 Jan 2016 09:16:38 +0100
Message-ID: <CAAQVbZbbCW4CGQFM=BokhyivhOmcuhqxdA2pHa-r2xYcG+ZFEQ_at_mail.gmail.com>

Hello Ali
if you want to minimize the downtime you would proabilly start with minimizing the downtime due to the migration from non-ASM to ASM. This can be achieved using rman, image copies and incremental backups A possible strategy could be (assuming all database are in archivelog mode): - setup ASM 11.2 on the existing cluster and add new LUNs and create one (or more) diskgroup
- use rman to create image copies of each datafile inside ASM, and use rman to recover that copies
- switch a test database to ASM (switch datafile to copy to start using the datafile copies inside ASM, create new redolog members inside ASM, create new tempfiles inside ASM)
- plan a (relatively) short downtime to switch databases to ASM - use a short outage window to switch OCR and votedisk to ASM

now you should only be using ASM... so you should be able to upgrade to 12c

regards

2016-01-21 17:00 GMT+01:00 Ali Alizadeh <rali.alizadeh_at_gmail.com>:

> Thank you Mark.
>
> DBs are not large. I have 4 DBs run on this 2 node oracle cluster using
> raw device (largest DB is about 200Gb). I am upgrading in place and I have
> 72 hours to complete the migration process. Upgrade oracle RAC
> 11.2.0.3 (OCR+Votedisk on raw device, none-ASM) to GI 12c moving to ASM and
> RDBMS from 11.2.0.3 to 11.2.0.4.
> Will it be easy to configure ASM on existing oracle cluster and move
> everything to ASM prior to upgrade?
> Will upgrading oracle cluster from 11.2.0.3 to GI 12c give me an option to
> move OCR/votedisk to ASM?
>
> Regards
> Ali
>
>
> On Thu, Jan 21, 2016 at 12:09 AM, Mark J. Bobak <mark_at_bobak.net> wrote:
>
>> Hmmm...it's a complicated question.
>>
>> How large is the database? How much effort are you willing to expend to
>> minimize downtime? You can do a standby database and achieve near zero
>> downtime, but it's a non-trivial effort.
>>
>> Depending on any SLA that you're subject to, size of the db, are you
>> upgrading in place? Are you building a new cluster?
>>
>> Those are just a few questions to get you started.
>>
>> Hope that helps,
>>
>> -Mark
>>
>> On Wed, Jan 20, 2016, 17:13 Ali Alizadeh <rali.alizadeh_at_gmail.com> wrote:
>>
>>> Hello
>>>
>>> We are planning to upgrade our oracle cluster 11.2.0.3 using raw device
>>> (no ASM) to oracle GI 12c/ASM.
>>> What will be the best approached to minimize the downtime?
>>>
>>> Regards,
>>> Ali
>>>
>>>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 22 2016 - 09:16:38 CET