What are some of the RAC specific parameters?
Some of the RAC parameters are:
- CLUSTER_DATABASE
- CLUSTER_DATABASE_INSTANCE
- INSTANCE_TYPE (RDBMS or ASM)
- ACTIVE_INSTANCE_COUNT
- UNDO_MANAGEMENT
What are some of the RAC specific parameters?
Some of the RAC parameters are:
- CLUSTER_DATABASE
- CLUSTER_DATABASE_INSTANCE
- INSTANCE_TYPE (RDBMS or ASM)
- ACTIVE_INSTANCE_COUNT
- UNDO_MANAGEMENT
What is a VIP in RAC use for?
The VIP is an alternate Virtual IP address assigned to each node in a cluster. During a node failure the VIP of the failed node moves to the surviving node and relays to the application that the node has gone down. Without VIP, the application will wait for TCP timeout and then find out that the session is no longer live due to the failure.
What is split brain?
When database nodes in a cluster are unable to communicate with each other, they may continue to process and modify the data blocks independently. If the
same block is modified by more than one instance, synchronization/locking of the data blocks does not take place and blocks may be overwritten by others in the cluster. This state is called split brain.
What is cache fusion?
In a RAC environment, it is the combining of data blocks, which are shipped across the interconnect from remote database caches (SGA) to the local node, in order to fulfill the requirements for a transaction (DML, Query of Data Dictionary).
Ace your next Oracle RAC interview with this blog. Click here for more interview question and answers on Oracle RAC:
<Moderator Edit - deleted spam link>