RE: RAC de-clustering

You can also use srvctl to remove the node, service, database or instance.

REMOVE CRS RESOURCES

srvctl remove database -d <database-name>  
srvctl remove instance  -d <database-name> [-i <instance-name>] 
srvctl remove service -d <database-name> -s <service-name> [-i <instance-name>] 

srvctl remove nodeapps -n <node-name> 

EXAMPLES:

Remove the applications for a database.  
        srvctl remove database  -d ORACLE 
Remove the applications for named instances of an existing database.  
        srvctl remove instance -d ORACLE -i  RAC03 
        srvctl remove instance -d ORACLE -i  RAC04 
Remove the service.
        srvctl remove  service -d ORACLE -s STD_BATCH
Remove the service from the instances.
        srvctl remove  service  -d ORACLE -s STD_BATCH -i RAC03,RAC04
Remove all node applications from a node.
        srvctl remove  nodeapps -n myclust-4

-Bryan
Quoting Kevin Closson <kevinc@xxxxxxxxxxxxx>:

> 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.
> 
> 
> ________________________________
> 
>       From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zabair Ahmed
>       Sent: Wednesday, November 16, 2005 1:31 AM
>       To: oracle-l@xxxxxxxxxxxxx
>       Subject: RAC de-clustering
>       
>       
>       10.1.0.3.0 on TRU64 V5.1
>        
>       Scenario.
>        
>       currently i have a number of RACed databases (3 in total) which
> are running 10g RAC on a 4-node (say node 1, node2, node3 and node4)
> TRU64 Cluster. 
>        
>       what i want to be able to do is take 2 of these databases out of
> RAC mode (on node 1 and 3 and leave the third database RACed (on nodes 2
> and 4)
>        
>       Is this possible, if so can someone give me some pointers on
> how. 
>        
>       My specific question are, do i have to de-install the RAC
> software and CRS software on the nodes which are not going to have the
> RAC databases, but my ORACLE_HOME and CRS_HOME are on a shared
> filesystem, so i guess this can't be done! 
>        
>       Am not using ASM.
>        
>       TIA
>        
>        
>        
> 
>       
> ________________________________
> 
>       Yahoo! Model Search
> <http://us.rd.yahoo.com/mail/uk/taglines/default/modelsearch/*http://uk.
> news.yahoo.com/hot/model-search/>  - Could you be the next catwalk
> superstar? Check out the competition
> <http://us.rd.yahoo.com/mail/uk/taglines/default/modelsearch/*http://uk.
> news.yahoo.com/hot/model-search/>  now 
> 
> 


Bryan Thomas
Senior Performance Consultant
Performance Tuning Corporation
www.perftuning.com
(512)751-5516
bthomas@xxxxxxxxxxxxxx


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

Other related posts: