Single Instance vs RAC
Single Instance database contains one database and one Instance on a single server machine.There is one to one mapping between database and the Instance. In the case of RAC, there can be multiple server machines.
The server machines are referred to as node. Each node will be running an instance and a listener. Every node is connected to the database that is placed on a shared storage. In RAC, there is one database to many instance mapping. Every instance is working in a well co-ordinatedmanner and accessing the same database files. Every node is connected over a network.
Single Instance Database = One Database and One Instance
RAC = One Database with multiple Instances.
Oracle RAC supports up to 100 nodes in a cluster. Though it is technically possible to have 100 nodes, in real world scenario it has been noted with about 32 node RAC configuration by the Oracle Customers.
Single Instance database contains one database and one Instance on a single server machine.There is one to one mapping between database and the Instance. In the case of RAC, there can be multiple server machines.
The server machines are referred to as node. Each node will be running an instance and a listener. Every node is connected to the database that is placed on a shared storage. In RAC, there is one database to many instance mapping. Every instance is working in a well co-ordinatedmanner and accessing the same database files. Every node is connected over a network.
Single Instance Database = One Database and One Instance
RAC = One Database with multiple Instances.
Oracle RAC supports up to 100 nodes in a cluster. Though it is technically possible to have 100 nodes, in real world scenario it has been noted with about 32 node RAC configuration by the Oracle Customers.
No comments:
Post a Comment