Oracle 11g R1/R2 Real Application Clusters Essentials

Adding an RAC database instance

Assuming that you have created an RAC database with a single instance named RACDB, later on you may want to add a new instance to the RAC database to avoid a single point of failure, or to scaleup your application workload over multiple instances. One of the primary advantages of an RAC database, in contrast to a standalone database, is that an RAC database can consist of two or more instances accessing a single database. Having two or more instances enables you to achieve scalability by balancing the application workload across available instances to achieve better performance. It also provides a high availability solution by rapidly reestablishing the lost user connections from a failed instance to the other surviving ...