Optimization of Oracle Real Application Clusters for High-Availability and Fault-Tolerant Healthcare Database Infrastructure

References

[1] Oracle. Application Development Best Practices for Oracle Real Application Clusters (RAC): A Developer’s Checklist. Oracle technical white paper; 2024.

[2] Oracle. Oracle Database 19c Real Application Clusters Administration and Deployment Guide. Oracle Database Documentation; 2023.

[3] Oracle. Oracle Database 19c Real Application Clusters Installation Guide for Linux and UNIX. Oracle Database Documentation; 2023.

[4] Oracle. Oracle Database 19c Clusterware Administration and Deployment Guide. Oracle Database Documentation; 2023.

[5] Oracle. Oracle Database 19c High Availability Overview. Oracle Database Documentation; 2023.

[6] Oracle. Oracle Database 19c Administrator’s Guide. Oracle Database Documentation; 2023.

[7] Oracle. Oracle Database 19c Performance Tuning Guide. Oracle Database Documentation; 2023.

[8] Oracle. Oracle Database 19c Reference. Oracle Database Documentation; 2023.

[9] Oracle. Oracle Database 19c Automatic Storage Management Administrator’s Guide. Oracle Database Documentation; 2023.

[10] Oracle. Oracle Database 19c Backup and Recovery User’s Guide. Oracle Database Documentation; 2023.

[11] Oracle. Oracle Database 19c Data Guard Concepts and Administration. Oracle Database Documentation; 2023.

[12] Oracle. Oracle Database 19c Security Guide. Oracle Database Documentation; 2023.

[13] Oracle. Oracle Database 19c Net Services Administrator’s Guide. Oracle Database Documentation; 2023.

[14] Oracle. Oracle Database 19c Global Data Services Concepts and Administration Guide. Oracle Database Documentation; 2023.

[15] Oracle. Oracle Database 19c PL/SQL Packages and Types Reference. Oracle Database Documentation; 2023.

[16] Oracle. Oracle Maximum Availability Architecture: Oracle RAC and Clusterware Best Practices. Oracle MAA guidance; 2024.

[17] Oracle. Oracle Maximum Availability Architecture: Oracle Database High Availability Best Practices. Oracle MAA guidance; 2024.

[18] Oracle. Oracle Maximum Availability Architecture: Oracle Data Guard Best Practices. Oracle MAA guidance; 2024.

[19] National Institute of Standards and Technology. The NIST Cybersecurity Framework (CSF) 2.0. NIST CSWP 29; 2024.

[20] National Institute of Standards and Technology. Security and Privacy Controls for Information Systems and Organizations. NIST SP 800-53 Revision 5; 2020.

[21] National Institute of Standards and Technology. Contingency Planning Guide for Federal Information Systems. NIST SP 800-34 Revision 1; 2010.

[22] International Organization for Standardization. ISO/IEC 27001:2022: Information security management systems — Requirements. Geneva: ISO; 2022.

[23] International Organization for Standardization. ISO 22301:2019: Security and resilience — Business continuity management systems — Requirements. Geneva: ISO; 2019.

[24] Saudi Data and Artificial Intelligence Authority. Personal Data Protection Law Implementing Regulations. Kingdom of Saudi Arabia; 2023.

[25] World Health Organization. Global Strategy on Digital Health 2020–2025. World Health Organization; 2021.

@article{1724849,
      author = {Mujeeb Pullumalayil},
      title = {Optimization of Oracle Real Application Clusters for High-Availability and Fault-Tolerant Healthcare Database Infrastructure},
      journal = {Iconic Research And Engineering Journals},
      year = {2026},
      volume = {10},
      number = {5},
      pages = {1319-1330},
      issn = {2456-8880},
      url = {https://www.irejournals.com/formatedpaper/1724849.pdf},
      abstract = {Healthcare database infrastructure must remain responsive during emergencies, routine clinical work, planned maintenance and equipment failures. Oracle Real Application Clusters (RAC) offers a shared-database architecture in which multiple instances can support services, but high availability cannot be established by clustering alone. This integrative review examines how RAC configuration, database service design, connection recovery, transaction integrity, workload management, storage resilience, monitoring and disaster recovery can be combined for fault-tolerant healthcare information systems. It proposes a layered optimisation framework connecting clinical service criticality to recovery objectives, technical controls, failure testing and operational governance. Particular attention is given to electronic health record transactions, medication administration, laboratory reporting, admission workflows and interfaces whose behaviour during partial failures may differ. The synthesis identifies the most consequential trade-offs: local continuity versus site-wide recovery, throughput versus tail latency, automated replay versus clinical transaction safety, and infrastructure redundancy versus common-cause failure. A phased assurance model is offered for healthcare organisations in Saudi Arabia and comparable settings. The study is conceptual, reports no experimental performance gains and recommends prospective workload-specific validation before operational deployment.},
      keywords = {Oracle Real Application Clusters; healthcare databases; high availability; fault tolerance; Application Continuity; transaction integrity; workload management; disaster recovery; database resilience},
      month = {November},
      doi = {https://doi.org/10.64388/ire1724849}
  }