×
Oracle Real Application Clusters (RAC) Multi-node Cluster is a database architecture that runs a single Oracle database across multiple servers (nodes), enhancing availability, scalability, and performance by distributing the workload and ensuring continuous operation even if one node fails.
Key Features
- High Availability (HA): Continuous operation by eliminating single points of failure; nodes continue to operate if one fails.
- Scalability: Add more nodes to handle increased users and transactions.
- Load Balancing: Even distribution of workloads across nodes, optimizing performance.
- Fault Tolerance: Redundancy ensures database availability despite node failures.
- Improved Performance: Multiple nodes handle more transactions and queries.
Components of Oracle RAC Multi-Node Cluster
- Cluster Nodes: Servers running an instance of the Oracle Database.
- Oracle Clusterware: Software for clustering services, including crsctl and srvctl.
- Shared Storage: Nodes share access to storage via SAN, NAS, or Oracle ASM.
- Interconnect: Private network for internode communication.
- Oracle ASM: Simplifies storage management, providing striping and mirroring.
- Global Resource Directory (GRD): Tracks data blocks and resources across instances.
Oracle Data Guard in RAC
Oracle Data Guard enhances RAC’s high availability, data protection, and disaster recovery by maintaining synchronized standby databases.
Key Features
- Disaster Recovery: Standby databases in different locations for site-level recovery.
- Data Protection: Continuous application of redo logs ensures data consistency.
- High Availability: Handles node-level and site-level failures for robust availability.
Key Benefits
- Unified Device Discovery: Provides a comprehensive view of all elements in an Oracle RAC Database with Data Guard Multi-Node Cluster, including their relationships.
- Proactive Device Monitoring: Collects metric values over time and sends alerts to the appropriate team when thresholds are breached or unexpected behavior occurs, ensuring minimal or zero downtime.
- Job Scheduling Metrics: Offers detailed metrics on job scheduling times and statuses.
- Concern Alerts: Generates alerts for each metric to notify administrators of any resource issues promptly.
Supported Target Versions
The application is validated on Oracle Database 19c Enterprise Edition Release 19.0.0.0.0.
Hierarchy of Oracle RAC resource
For Oracle RAC, Hierarchy is as follows
- Oracle RAC
- Oracle Node
- Oracle DB Instance
- Oracle Disk Group
- Oracle Disk
- Oracle Node
For Oracle Standalone, Hierarchy is as follows
- Oracle Node
- Oracle DB Instance
Version History
| Application Version | Bug fixes / Enhancements |
|---|---|
| 3.1.0 | Added support for multiple database instances. |
| 3.0.1 | Resolved the issue by correcting the oracle_cluster_blocking_SessionCount query to capture lock data from the last 5 minutes that causes session blockages. |
| 3.0.0 | Added support for additional metrics. Based on received suggestions, these metrics have not been included in the default monitors and in templates section. |
| 2.1.0 | Added support for SSH key pair based authentication. |
| 2.0.0 |
|
| 1.0.2 | Enhancements related to the latest snapshot, Activity Log and DebugHandler changes. |
| 1.0.1 | Changes related to resource discovery. |
| 1.0.0 | Initial support for Oracle Cluster application. |