Re: Convert 2-node RAC to single instance

  • From: Tony Sequeira <tony@xxxxxxxxxxxxxxx>
  • To: Oracle List <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 31 Jan 2009 20:18:26 +0000

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@xxxxxxxxxxxxxxx
> <mailto:tony@xxxxxxxxxxxxxxx>> 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).

Other related posts: