Introduction Oracle RAC and Oracle Active Data Guard provide high availability and disaster recovery for the Oracle Database. During maintenance operations such as patching and upgrades or in case of failures and outages, applications can reconnect to another active Oracle RAC instance or to the Data Guard standby database. Oracle Application Continuity extends the high…
Introduction Oracle provides the Checklist for Application Continuity alongside many other resources to get you started with Application Continuity. After completing the configuration at the database and application side, the question is how to verify whether your application calls are protected by Application Continuity? This information can be easily found in the AWR report. The…
Introduction In a previous blog post, we discussed how Draining and Application Continuity work for maintenance events like rolling patching with Oracle RAC. For planned maintenance, draining can be used to allow active sessions to finish their work (drain) before the database instance is shut down. However, in unplanned events like an instance failure, all…
Introduction Oracle RAC provides scalability and high availability for the Oracle Database. If one server (RAC node) fails or is taken offline for maintenance, the database is still accessible through the additional nodes. However, what happens to client sessions that are executing some work, whether reading or changing data, when maintenance begins? That work will…
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
Introduction Oracle Application Continuity hides database interruptions from end-users and applications. A simple test using SQL*Plus was discussed in this blog post. However, SQL*Plus is usually not your real application that will be used in production. Also, SQL*Plus is not a pooled application, and it’s recommended to use Connection Pools for Application Continuity. This blog…
Introduction To use High Availability features like Fast Application Notification (FAN), Draining, and Application Continuity, you need to create a custom database service and set the high availability attributes accordingly. This is not possible when using the default database service, which is the service with the same name as the PDB. Additionally, custom database services…
Introduction Oracle Application Continuity is the high availability feature for your application. Database planned maintenance and outage events no longer impact applications availability. Do you want to learn how, try it, and implement it in production? But where to start from documentation, white papers, blog posts, videos, demos, and hands-on labs? This blog post gives…
Introduction Oracle Database is very well known for its high availability and disaster recovery capabilities using Oracle RAC and Oracle (Active) Data Guard. Maintenance operations like patching and upgrade, failures like database server or database instance crashes, and even complete data center outages have no to minimal impact on database availability. However, what happens on…
Database Heartbeat 