8 Oracle Engineered Systems

Oracle offers engineered systems designed specifically to run Oracle Database in a high availability environment:


8.1 Oracle Exadata Database Machine

The Oracle Exadata Database Machine is an engineered system, complete with preoptimized and preconfigured software, servers, and storage, configured to current best practices, that provides an optimal solution for all database workloads, ranging from scan-intensive data warehouse applications to highly concurrent OLTP applications. It combines Oracle Exadata Storage Server Software, Oracle Database software, and hardware components to deliver extreme performance in a highly available and highly secure environment. Along with Oracle's unique clustering and workload management capabilities, the Database Machine is also well-suited for consolidating multiple databases onto a single grid.

Oracle Exadata Database Machine is designed for high performance, scalability, and availability for OLTP, Data Warehouse applications, database consolidation, memory intensive workloads, and cloud computing. It is the only Engineered System focused on Oracle Database functionality and fully optimized for all database workloads using Exadata Smart Flash Technology, Exadata I/O Resource management, and Exadata smart offloading capabilities and features. For the best combination of database performance, scalability, and availability, use the Exadata MAA architecture.

The Oracle Exadata Database Machine hardware is fully redundant without any single points of failure. The Oracle software used on the Oracle Exadata Database Machine, used in conjunction with MAA best practices, yields a fault-tolerant system with the following benefits:

  • Lowest brownout optimizations such as fast Exadata database or storage node detection and failover in less than 2 seconds versus 30-60 plus seconds with other customized configurations

  • Continuous database availability across node and instance failures through the use of Oracle RAC

  • Smart high availability and performance Quality of Service features such as I/O latency capping for read or write operations, detection, isolation, and removal of an underperforming or sick disk, and storage and network resource management to preserve highest application and database performance and availability

  • Simplifies high availability management with features such as patching automation and optimizations, smart hardware alerts, and Exadata AWR reports

  • Data protection and continuous database accessibility across disk and cell failures through the use of Oracle ASM and the Oracle Exadata Storage Server Software

  • Prevents and automatically repairs data corruption using the Oracle ASM automatic repair mechanism, the built-in corruption checks within the Exadata storage, and the recommended database default settings (db_block_checksum, db_lost_write_protect)

  • Inspects and repairs hard disks with damaged or worn out disk sectors (cluster of storage) or other physical or logical defects periodically when there are idle resources with Exadata Automatic Hard Disk Scrub and Repair

  • Provides redundant and fault tolerant networking, cabling, and server interconnectivity

  • Provides the ability to quickly reestablish database service if the Oracle Exadata Database Machine--or the data center the machine resides in--is damaged, through the use of Oracle Active Data Guard or Oracle GoldenGate

For planned maintenance, Oracle Exadata Database Machine provides the following benefits:

  • Supports Oracle ASM, Oracle Clusterware, and Oracle RAC rolling upgrade and software changes

  • Supports Oracle Exadata Storage Server Software rolling upgrades for patches

  • Allows application and system changes with Data Guard and Oracle GoldenGate

  • Supports all of the online maintenance capabilities that are available in the Oracle Database

  • Provides tools and Oracle Enterprise Manager 13c support to automate patching Grid Infrastructure and Oracle Database software, database server operating system and firmware (dbnodeupdate.sh only), and all Exadata servers and InfiniBand switches (patchmgr only) in a rolling manner

With Oracle Exadata Database Machine, your Oracle Database High Availability architecture choices are simplified and Exadata is applicable for all MAA reference architectures.

Oracle Exadata Database Machine is the recommended platform for the MAA tiers and for database consolidation.

The recommended Exadata MAA Architecture consists of three elements: 1) a production Exadata system (primary), 2) a standby Exadata system, and 3) an Exadata test or development system.

The second element can be an Active Standby Exadata system that is a replica of the primary that contains all the benefits of any Exadata Database Machine and the benefits described in Oracle Data Guard.

The third element can be a development and test Exadata system that is independent of the primary and standby Exadata systems, following the best practices described in Establish Test Practices and Environment.

It is recommended that you run Oracle's Exadata Health Check (exachk) monthly because it provides the most comprehensive configuration checks for Exadata software, network, and hardware components, and it reports any variance from MAA best practices..

The MAA configuration best practices will continue to be integrated and incorporated during the initial installation and deployment of the Exadata Database Machine and Exadata Cell.

See Also:

8.2 Oracle SuperCluster

The Oracle MiniCluster S7-2, Oracle SuperCluster M7 and Oracle Supercluster M6-32 are multi-purpose engineered systems for consolidating a wide range of mission critical applications, databases and cloud services.

Oracle SuperCluster is ideally targeted to existing SPARC and IBM database customers or customers preferring a multi-purpose engineered system that hosts a combination of various database releases (Oracle 10g and later, compared to only Oracle 11g and later for Exadata) and application servers. Oracle SuperCluster has additional shared storage with ZFS storage cluster that can be used for non-database files and has virtualization support through Oracle VM Server for SPARC and Oracle Solaris Zones. Oracle Exadata Database Machine is still the recommended database machine; however Oracle SuperCluster provides other functionality for your application tier if you require a multi-purpose solution.

Oracle SuperCluster is recommended for the MAA service level tier architectures when a multi-purpose database and application processing system is required. Oracle SuperCluster M6-32 provides the largest in-memory footprint of any Oracle engineered system. Additionally, if non-database files need to be protected in the case of full stack failover or switchover, you can use a combination of Data Guard with ZFS storage remote mirroring. It is also recommended to run Oracle's Exadata health check (exachk) monthly because it provides the most comprehensive configuration checks for Exadata software, network, and hardware components, and it reports any variance from MAA best practices.

See Also:

Oracle Engineered Systems Documentation for Oracle SuperCluster documentation

Oracle SuperCluster for data sheets, videos, and other resources

See My Oracle Support Note 1070954.1 for information about exachk.

8.3 Oracle Database Appliance

Oracle Database Appliance is an engineered system consisting of hardware and software that saves customers time and money by simplifying deployment, maintenance, and support of high availability database solutions. Built with Oracle Real Applications Clusters (Oracle RAC) and Oracle Automatic Storage Management best practices, it offers customers a fully integrated system of software, servers, storage and networking in a single box delivering high availability database services for a wide range of home grown and packaged OLTP and Data Warehousing workloads. It comes as a 4RU (rack unit) server appliance that consists of two server nodes and 18TB raw storage and 800GB of SSD capacity running on Oracle Linux with an optional expansion shelf to double the storage to 36TB raw and 1.6TB of SSD.

Building highly available systems can be difficult and complex and may require advanced integration skills that many organizations don't have and be risky and error-prone with no vendor accountability. The Oracle Database Appliance is simple, reliable, and affordable.

  • Simple

    To deploy and use the Oracle Database Appliance, simply unpack it, plug in the power cord, plug in the network cables, and run the Oracle Appliance Manager installation to create a clustered, highly available database. The Oracle Database Appliance and its specially engineered software enables "one button" patching for all the elements of the software stack - firmware, operating system, clusterware, storage manager, and database software.

  • Reliable

    The Oracle Database Appliance is built on the Oracle software stack which is completely integrated along with the storage that include 600 GB SAS Hard Disk Drives between the two server nodes that can be triple-mirrored or double mirrored to provide highly available shared storage. This appliance also contains SAS Solid State Drives for redo logs, triple-mirrored to protect the Oracle database in case of instance failure. The appliance manager in conjunction with Oracle Automatic Storage Management (ASM) automatically configures, manages, and monitors the disk for performance and availability. The Oracle Appliance Manager provides alerts on performance and availability events as well as automatically configures replacement drives in case of a hard disk failure.

  • Affordable

    The Oracle Database Appliance can minimize licensing costs while providing a capacity-on-demand platform for deploying databases by initially licensing as few as 4 cores for the bare metal option – additional cores can be activated at any time. Virtualization provides additional licensing flexibility by providing isolation between databases and other workloads by leveraging Oracle VM hard partitioning.

The Oracle Database Appliance is an ideal database appliance for customers who value simplicity and who seek to avoid the complexity, costs, and risks in deploying a highly available database solution. The Oracle Database Application is also ideal for database customers who do not require Exadata Database Machine's additional performance and scalability with its Exadata software capabilities and additional availability (rolling patch upgrades as opposed to "one button patching for all the elements of the software stack). Customers can now benefit from high availability (HA) database solutions without having special skills or HA expertise.

Oracle Database Appliance is an option for the MAA service level tier architectures when a standard platform with high consolidation density for smaller environments is required. The recommended Oracle Database Appliance MAA Architecture consists of three elements: 1) a production Oracle Database Appliance system (primary), 2) a standby Oracle Database Appliance system, and 3) an Oracle Database Appliance test or development system. It is recommended that you run Oracle health check (orachk) for its comprehensive configuration checks on operating system, Grid Infrastructure and database settings.

See Also:

Oracle Engineered Systems Documentation for Oracle database Appliance documentation

Oracle Database Appliance for white papers, videos, and other resources

My Oracle Support Note 1268927.2 for information about orachk.

8.4 Zero Data Loss Recovery Appliance

The cloud-scale Zero Data Loss Recovery Appliance, commonly known as Recovery Appliance, is an engineered system designed to dramatically reduce data loss and backup overhead for all Oracle databases in the enterprise. Integrated with Recovery Manager (RMAN), the Recovery Appliance enables a centralized, incremental-forever backup strategy for large numbers of databases, using cloud-scale, fault-tolerant hardware and storage. The Recovery Appliance continuously validates backups for recoverability. The Recovery Appliance can augment and improve any MAA reference architecture and is part of Oracle MAA's recommended backup and recovery solution, especially due to its inherent database backup validation and protection.

Most database backup and restore processing is performed by the centralized Recovery Appliance, making storage utilization, performance, and manageability of backups more efficient. The Recovery Appliance stores and manages backups of multiple databases in a unified disk pool, using an RMAN incremental-forever strategy. The Recovery Appliance continually compresses, deduplicates, and validates backups at the database block level, while creating virtual full backups on demand.

A virtual full backup is a complete database image as of one distinct point in time, maintained efficiently through Recovery Appliance indexing of incremental backups from protected databases. A virtual full backup can correspond to any incremental backup that was received.

Administrators use Oracle Enterprise Manager Cloud Control (Cloud Control) to manage and monitor the environment. Cloud Control provides a "single pane of glass" view of the entire backup lifecycle for each database, whether backups reside on disk, tape, or another Recovery Appliance.

Recovery Appliance provides the following benefits:

  • Elimination of Data Loss

  • Minimal Backup Overhead

  • Improved End-to-End Data Protection Visibility

  • Cloud-Scale Protection