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:45:51 +0000

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

Other related posts: