Re: Converting from a 2-node RAC cluster using ASM to a single instance with Oracle Restart.

You will have to unconfigure the cluster and then configure oracle restart.

$ORACLE_HOME/crs/install/rootcrs.sh -deconfig -force

$ORACLE_HOME/crs/install/roothas.sh

Seth Miller

On Tue, Oct 24, 2017 at 8:29 AM, Zabair Ahmed <dmarc-noreply_at_freelists.org> wrote:

> That's fine for the database, but how do we decouple the cluster. The end
> result for us would be a single node, single instance with Oracle Restart.
>
>
> On Friday, 20 October 2017, 12:29, Stefan Knecht <knecht.stefan_at_gmail.com>
> wrote:
>
>
> Then you won't need any Data Guard shenanigans or anything like that.
>
> Set cluster_database and other RAC-specific parameters to false or remove
> them, shut down, startup, drop excess redo threads.
>
> Done.
>
> Of course you have to check on any specific service configurations to make
> sure everyone can still connect. Also be aware of applications not properly
> configured (e.g. using host:port:SID)
>
> Stefan
>
>
> On Fri, Oct 20, 2017 at 5:10 PM, Zabair Ahmed <dmarc-noreply_at_freelists.org
> > wrote:
>
> Hi Seth, Sorry forgot to say this new single instance will be on the same
> server as one of the RAC databases. We are trying to reduce our RAC
> footprint hence the reason going to a single instance.
>
> Thanks
>
>
> On Thursday, 19 October 2017, 17:48, Seth Miller <sethmiller.sm_at_gmail.com>
> wrote:
>
>
> Zabair,
>
> If you are moving from a RAC cluster to another server, the easiest way to
> do this is to create a new instance on your single instance server and
> restore a backup from the RAC database. You can reuse the control file or
> create a new one; the latter probably being the better option so you don't
> have to delete a bunch of extra online redo logs and remap the data file
> locations. You will have at least one extra undo tablespace but those can
> simply be dropped after the restore is complete.
>
>
> Seth Miller
>
> On Thu, Oct 19, 2017 at 11:08 AM, TJ Kiernan <tkiernan_at_pti-nps.com> wrote:
>
> Good point – I happened to be repurposing one of the nodes to run the
> single instance, but it’s not technically necessary.
>
> -T. J.
>
> *From:* Andrew Kerber [mailto:andrew.kerber_at_gmail. com
> <andrew.kerber_at_gmail.com>]
> *Sent:* Thursday, October 19, 2017 10:59 AM
> *To:* TJ Kiernan
> *Cc:* dmarc-noreply_at_freelists.org; exriscer_at_gmail.com; Oracle-L Freelists
>
> *Subject:* Re: Converting from a 2-node RAC cluster using ASM to a single
> instance with Oracle Restart.
>
> You can run dataguard from RAC to single instance. No need to remove one
> first. If you need help with that, let me know.
> Sent from my iPad
>
> On Oct 19, 2017, at 9:44 AM, TJ Kiernan <tkiernan_at_pti-nps.com> wrote:
>
> I just got through something very similar. There isn’t a single document
> for the process, but you should be able to map it out by,
>
> 1. Remove one node from the cluster,
> 2. Provision storage for the new instance
> a. we split our ASM disks in half as we had the capacity to do so –
> if you don’t, you’re looking at finding other storage or reusing your
> diskgroups from the RAC environment. I’ve heard it can be done, but I’ve
> never attempted it.
> 3. Build your new instance as a Data Guard standby
> 4. Switchover
>
> HTH,
>
> T. J.
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_
> freelists.org <oracle-l-bounce_at_freelists.org>] *On Behalf Of *Zabair Ahmed
> *Sent:* Thursday, October 19, 2017 7:37 AM
> *To:* exriscer_at_gmail.com; Oracle-L Freelists
> *Subject:* Re: Converting from a 2-node RAC cluster using ASM to a single
> instance with Oracle Restart.
>
>
> We are using 11.2.0.4 EE. Thanks for the suggestion, will look into it.
> On Thursday, 19 October 2017, 13:28, Ls Cheng <exriscer_at_gmail.com> wrote:
>
> Can you use Data Guard or you are running standard edition? If you can
> just setup a Data Guard in Sngle Instance and switchover so the downtime is
> minium
> BR
>
> On Thu, Oct 19, 2017 at 2:02 PM, Zabair Ahmed <dmarc-noreply_at_freelists.org>
> wrote:
>
> Hello,
>
> We are currently on a 2 node 11.2.0.4 RAC cluster on Redhat 5.9 and
> wanted to convert this database to a single instance with Oracle Restart
> running 11.2.0.4.
>
> I would appreciate if someone could point me to the right place for some
> documentation/notes.
>
> I have tried MOS and Oracle documentation but not have had any luck so
> far.
>
> TIA.
>
> Zabair
>
>
>
>
>
>
>
>
>
>
> --
> //
> zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
> Visit us at zztat.net | Support our Indiegogo campaign at igg.me/at/zztat
> | _at_zztat_oracle
>
>
>

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