Re: Convert 2-node RAC to single instance

From: Tony Sequeira <>
Date: Sat, 31 Jan 2009 20:18:26 +0000
Message-ID: <>

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 <
> <>> wrote:
> Oracle 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).

Received on Sat Jan 31 2009 - 14:18:26 CST

Original text of this message