Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is RAC in oracle?

Answer Posted / waseem

RAC is Cluster software available from Oracle. This is
available 10g onwards.

In this Cluster environment we can have multiple instances
running with a single database. Users are connected to
different instances. Availability and load balancing is the
main purpose behind Oracle RAC.

VD (Voting Disk) and OCR (Oracle Cluster Registry) are the
components of RAC. VD is similar to control file and OCR has
all the registered services to start the cluster.

The connection of user could be established on any node but
later depending on the number of users connections
established and the number of instances(nodes) available the
load of all the established connections is balanced across
the Cluster.

The first node created in the Cluster is the Master Node and
all other nodes in the Cluster nbehaves like Slaves.

If any slave node fails to communicate with Master node,
internally the failed node is rebooted by the Master node by
writing a kill block into VD. If the Master node fails, then
any of the existing node responding first will become the
Master node and reboots the failed node.

Daemons checks for the availability of VD,nodes and OCR and
cluster is started.

We can add nodes to the existing cluster from any exiting
node which is already a part of the cluster. We can also
delete a node from the cluster by stopping all the services
of that node from the CRS inventory and home.

We can have multiplexed copies of VD and OCR. VD (Min 1 and
Max 310....OCR(Min 1, Max 2).

We can take backup of VD and OCR with the help of dd (disk
dump). For OCR we can also perform logical backup using
export utility.

Note: Use ASM (logical location for physical diskgroups) for
the best performance).
Create ASM instance for each node.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the different between now() and current_date()? : Sql dba

934


explain advantages of innodb over myisam. : Sql dba

1083


Is mariadb nosql?

989


Is it possible to create startup or shutdown trigger for on-schema?

979


how is myisam table stored? : Sql dba

997


what are the different type of sql's statements ? : Sql dba

872


Why do we need view in sql?

932


What is field delimiter?

989


how many values can the set function of mysql take? : Sql dba

933


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

984


how to get a list of indexes of an existing table? : Sql dba

914


Can you join views in sql?

896


What is mutating table error?

1116


how to extract a unit value from a date and time? : Sql dba

946


How many types of primary keys are there?

977