RE: RAC de-clustering

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Wed, 16 Nov 2005 12:49:41 -0500
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD6094@ecogenemld50.Org.Collegeboard.local>

I see what Kevin is saying but what about; cluster_database=FALSE To keep things simple?

I'm currently running my "RAC" database on our *single* node fail over box (another post in a minute). I never installed the RAC software/option on that failover box, but I could do the same on one of my RAC nodes wiht the RAC option. I do have two "THREADS" of redo, but easily changed.

I'm 9i and must admit that even with cluster_database=FALSE on the RAC nodes I must have the oracm (Oracle Cluster Manager) running before starting (as) a single instance/database.

The point being I don't have to change the oracle software to run as a single instance forever forward, no?

hth

Chris Marquez
Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Kevin Closson Sent: Wed 11/16/2005 12:19 PM
To: oracle-l_at_freelists.org
Subject: RE: RAC de-clustering

no, this is incorrect. and so was the last post about srvctl.

if RAC is not linked in (e.g., skgxn.so skgxp.so are the stub libraries),
your database is essentially non-rac. There is no difference between a rac and a non-RAC database besides MAXINSTANCES and threads of redo... in fact, you can create a "RAC" database even before linking in RAC... that is, you can have MAXINSTANCES>1 and extra theads of redo...then, provided you have clusterware up, relink Oracle rac_on and boot multiple instances.

just unlink it.

	From: David [mailto:thump_at_cosmiccooler.org] 
	Sent: Wednesday, November 16, 2005 8:24 AM
	To: kevinc_at_polyserve.com; oracle-l_at_freelists.org
	Subject: RE: RAC de-clustering
	
	

	I presume he also means what to do about the tablespaces like

system that are shared.

Simplest way is create new db and export/import

Could also recreate ctl and copy datafiles, use rman duplicate, etc

	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Closson
	Sent: Wednesday, November 16, 2005 7:36 AM
	To: oracle-l_at_freelists.org
	Subject: RE: RAC de-clustering

	 

	unless I am missing your question, you can simply relink Oracle

	rac_off. If libskgxn.so is a stub (rac_off), CRS is not an

issue.

You'll still have multiple threads of redo, but no matter... it wont

be RAC.

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

Received on Wed Nov 16 2005 - 14:49:12 CST