Re: Convert 2-node RAC to single instance

From: Tony Sequeira <tony_at_sequeira.org.uk>
Date: Sat, 31 Jan 2009 20:45:51 +0000
Message-ID: <4984B87F.3060005_at_sequeira.org.uk>

It's on OCFS. I obviously didn't consider this, sounds like a great idea. The fallback, if necessary would be the reverse, I guess.

Thanks.

Dan Norris wrote:
> Even then, if it is currently on OCFS, I would probably just move/copy
> the data files and then "alter database rename file ..." to update the
> controlfiles for the new locations. If it is on RAW now, I'd consider
> using an RMAN backup/restore while renaming the datafiles during the
> restore step.
>
> Dan
>
> On Sat, Jan 31, 2009 at 2:18 PM, Tony Sequeira <tony_at_sequeira.org.uk
> <mailto:tony_at_sequeira.org.uk>> wrote:
>
> The objective is to move the DB from the SAN onto "local" drives,
> sorry, should have made myself clear.
>
>
> Dan Norris wrote:
>> Why clone the DB? Since you're not using ASM, I presume you're
>> using OCFS (hopefully not RAW).
>>
>> So, converting is just shutting down the 2nd instance, setting
>> cluster_database=FALSE, and dropping the unnecessary redo log
>> (thread #2) and undo tablespace. That wouldn't require any
>> changes to the dataguard configuration since the database name
>> remains the same and the downtime should be minimal. Some updates
>> to tnsnames.ora for the clients and you should be all set. Maybe
>> I missed something in your request, but I don't see why this
>> would require a clone.
>>
>> Dan
>>
>> On Sat, Jan 31, 2009 at 1:09 PM, Tony Sequeira
>> <tony_at_sequeira.org.uk <mailto:tony_at_sequeira.org.uk>> wrote:
>>
>> Oracle 9.2.0.6.0 EE - I know
>> Win 2003 Server SE SP1
>>
>> I've been asked to look at converting the the 2 node RAC, to
>> a single
>> instance database, running on node 1 of the old RAC system. SAN
>> hardware getting old, replacement and spares difficult to
>> find. There
>> must be a fall back to the original RAC DB if performance
>> suffers.
>>
>> My initial thoughts are to clone the database onto a new
>> instance, and
>> change the global tnsnames.ora, so the client application
>> will not
>> notice the difference.
>>
>> However, there is a dataguard standby, which will also be
>> impacted,
>> which will need to some kind of action, whatever is done (I
>> believe).
>>
>>
>
>

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

Received on Sat Jan 31 2009 - 14:45:51 CST