Home » Server Options » RAC & Failsafe » Frequent Deletion Addition of a node to a RAC
Frequent Deletion Addition of a node to a RAC [message #465509] Wed, 14 July 2010 08:04 Go to next message
Ankurg1981
Messages: 3
Registered: February 2009
Location: Mumbai
Junior Member

Hi,

I am trying to resolve load isses on 2 RAC systems

Can someone please elaborate on the feasibility of following process:-
Server1 = 5 RAC installation
Server = 2 RAC installation

a) At 2200 hrs: Change Server1 RAC conf to release 1 node
b) At 2230 hrs: Plug this additional 1 nodes to Server2
c) At 2300 hrs: Initiate processing on Server2
d) At 0500 hrs: Release rented node from Server2
e) At 0530 hrs: Add rented node back to Server1
f) At 0600 hrs: Server1 again ready with 5 RAC

I want to explore options using which I can ensure smooth addition and deletion of node from a RAC. I intend to utilize at least 1 server of a 5 RAC system solely to add more cpu power and memory

Thanks and regards,
Ankur
Re: Frequent Deletion Addition of a node to a RAC [message #465518 is a reply to message #465509] Wed, 14 July 2010 08:57 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Ankur, Your question is not clear to you. Could you please elaborate your question.

Babu
Re: Frequent Deletion Addition of a node to a RAC [message #465520 is a reply to message #465518] Wed, 14 July 2010 09:04 Go to previous messageGo to next message
Ankurg1981
Messages: 3
Registered: February 2009
Location: Mumbai
Junior Member

Consider the following situation:-
1. My 5 RAC system works in daytime only and my 2 RAC system works only in night
2. Now the 2 RAC system has performance issue
3. I cannot upgrade hardware, instead I am trying to explore if I can extract some nodes from my 5 RAC setup every night and plug them into my 2 RAC system and once my overnight processing is done I replace the rented node back to the 5 RAC system

Re: Frequent Deletion Addition of a node to a RAC [message #465522 is a reply to message #465520] Wed, 14 July 2010 09:15 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Coming to point 2. Have you identified the performacne issue ? Is it OS Performacne Issue Or Is there issue in your network / high data lods Or something else ? Have you generated AWR reports on 2 RAC System?

3. Why you need to upgrade hardware? What's the problem?

Babu
Re: Frequent Deletion Addition of a node to a RAC [message #465543 is a reply to message #465522] Wed, 14 July 2010 11:26 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Hi - the terminology you are using (such as "5 RAC system") is not what I am used to, but I think you have two RAC databases: one is running on a two node cluster, the other on a five node cluster. You want to take a node from one cluster and add it to the other for a few hours, then move it back.
The answer must be to consolidate the clusters into a single 7 node cluster, and define instances for both databases on all nodes. Then you can start or stop them whenever you want. Does that make sense?
Previous Topic: Oracle Active Passive Database Configuration
Next Topic: Oracle RAC 10g and NAS Failover
Goto Forum:
  


Current Time: Thu Mar 28 04:07:52 CDT 2024