Re: Convert 2-node RAC to single instance

From: Tony Sequeira <tony_at_sequeira.org.uk>
Date: Sat, 31 Jan 2009 20:18:26 +0000
Message-ID: <4984B212.1010908_at_sequeira.org.uk>

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:18:26 CST