Options for High Availability

Oracle and SQL Server have different components and features for ensuring a database system is highly available. Table 10-1 lists the main high-availability solutions on both platforms.

Oracle has a Maximum Availability Architecture (MAA), which includes a combination of the options with Data Guard and RAC environments.

Each of these solutions for high availability provides some failover capabilities. Combinations of these options provide even more protection. Depending on the environment and business needs, certain solutions will work better than others. Just as when you’re planning the architecture for a SQL Server system, you need to decide which options are best suited for an Oracle environment that requires ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.