Re: Convert Stand-alone database to RAC
From: Chris King <ckaj111_at_yahoo.ca>
Date: Wed, 7 May 2014 11:30:28 -0700 (PDT)
Message-ID: <1399487428.88884.YahooMailNeo_at_web141402.mail.bf1.yahoo.com>
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...
Date: Wed, 7 May 2014 11:30:28 -0700 (PDT)
Message-ID: <1399487428.88884.YahooMailNeo_at_web141402.mail.bf1.yahoo.com>
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-lReceived on Wed May 07 2014 - 20:30:28 CEST