- How will it be known that a user is connected through which instance?
- Is there automatic switchover to another instance?
You can easily determine if you are connected to a RAC instance or a standalone instance by running the following query:
SELECT COUNT(*) FROM GV$INSTANCE;If the value returned is '1', then you are connected to a standalone instance. If the value is greater than one, then you are connected to a RAC instance and the value tells you how many nodes are running in the cluster.
In Oracle 9i and higher, you can failover to another RAC instance when your current instance goes down. You must configure Transparent Application Failover (TAF) in order for this to work. If you have not configured TAF, then you will not failover. Please read the Oracle docs on TAF as there are a few things one should know about its operations before configuring it.
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.