Re: Convert Stand-alone database to RAC

A database need not be a cluster database to run in a RAC cluster. In fact, the binaries running a RAC database are no different from those running a non-RAC database. Feel free to migrate your database to a RAC cluster without converting it to a cluster database.

It's also relatively easy to use RMAN Duplicate to go from single instance to cluster.

On Wed, May 7, 2014 at 1:30 PM, Chris King <ckaj111_at_yahoo.ca> wrote:

> Okay. Thanks Maaz.. I was confused because I'd thought that a stand-alone
> oracle database could only run on a cluster if it was in a separate
> ORACLE_HOME. But it looks like that's not the case if I'm just bringing the
> database over to convert it to RAC.... although I like the idea of
> importing into a new RAC database! Since this database is only 20GB in
> size, that would be faster/easier.
>
> Many thanks..
>
>
> On Wednesday, May 7, 2014 1:35:08 PM, Maaz Anjum <maazanjum_at_gmail.com>
> wrote:
> Hi Chris,
>
> Is the intent to extend the RAC cluster by one more host? Or simply
> migrate the existing database to RAC?
>
> If its the former, then the steps are the as adding a new node to an
> existing cluster, i.e. add storage, additional IP addresses and NIC(s) etc.
> After that you would convert the database from single instance to a RAC
> database by either DBCA or RConfig. I might be missing a few steps here :)
>
> If its the latter, you could simply create a new blank RAC database and
> import the data. The benefits here are that a) you can test performance in
> parallel on both environments, and b) you have a fallback in case the
> application does not do well on RAC.
>
> Cheers,
> Maaz
>
>
> On Wed, May 7, 2014 at 1:03 PM, Chris King <ckaj111_at_yahoo.ca> wrote:
>
> It seems there are a number of methods to convert a stand-alone database
> to a RAC database.. but it's not clear to me if I have to first move the
> stand-alone database onto the cluster first.. the stand-alone presently
> sits on a separate server on the same network. Can someone clarify that for
> me?
>
> Details: stand-alone is not using ASM, and sits on a stand-alone server
> the RAC cluster is on the same network, and presently runs only one test
> database.
> Both are the same version of Oracle (11.2) and same o/s (RHEL6).
>
> Thank you!
> -ck
>
>
>
>
> --
> A life yet to be lived...
>
>
>

--
http://www.freelists.org/webpage/oracle-l