Re: Convert 2-node RAC to single instance

From: Dan Norris <dannorris_at_dannorris.com>
Date: Sat, 31 Jan 2009 14:37:58 -0600
Message-ID: <bc04324b0901311237te731a77i677afe263dd67a1e_at_mail.gmail.com>



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> 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>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:37:58 CST

Original text of this message