Three highly available cluster scenarios for Oracle
Take a look at the official Oracle Web page and the unofficial PPT to get a quick look at the high availability offered by Oracle.
There are three main types:
1. RAC
RAC, real application clusters
Multiple Oracle servers form a shared cache, and these Oracle servers share a network-based storage. This system can tolerate the failure of stand-alone/or multiple machines.
However, multiple nodes within the system need high-speed network interconnection, which is basically to put everything in a room, or a data center. If the engine room fails, for example, the network is not working, that would be bad. Therefore, only with RAC can not meet the needs of the general Internet company's important business, the important business needs of many rooms to tolerate the accident of a single room.
2. Data Guard.
Data Guard This scheme is suitable for multiple computer rooms. A production database in a computer room, and other computer room to deploy standby database. The standby database is divided into physical and logical. The physical standby database is mainly used for switching after production failure. And the logical standby database can share the read load of production database at ordinary times.
3. MAA
MAA (Maximum availability architecture) is not the third, but the first two kinds of combination, to provide the highest availability.
A RAC cluster is deployed in each room, with data guard synchronized between the multiple rooms.