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 Cloud Object Storage is a regional service, i.e., objects are stored in a specific Oracle Cloud region. You can enable cross-region replication to automatically sync your data to a remote region for redundancy, providing protection from a regional outage. This blog post describes how to configure cross-region replication, use the replicated Object Storage…
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 In addition to its data protection capabilities, Oracle Data Guard provides additional features for workload scale-out, backup offload, and online maintenance and upgrade operations. Some features require the Active Data Guard (ADG) option license, and some do not. Sometimes the “little things” you need to be aware of make the difference. This blog post…
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…
Introduction Oracle Autonomous Database is based on Oracle RAC and Exadata and hence, highly available by design. But how about your application? What happens to sessions getting interrupted by a maintenance event (e.g., patching), a local failure (e.g., instance crash), or (accidentally) terminated by a KILL SESSION command? Let’s give it a try! You can…
Introduction After creating a VM DB System via Oracle Database Service for Azure (ODSA) in the previous blog post, we are going to see how to connect to the database host via SSH and to the CDB and PDB via SQL*Net from an Azure virtual machine, where usually your application will be running. The Environment…
Introduction Oracle Database Service for Azure (ODSA) automates and simplifies the Interconnect between Azure and Oracle Cloud. Additionally, it provides a Multicloud portal to create Oracle Databases with the same Azure portal experience. As of today, you can use ODSA for the following Oracle Database Cloud Services: This blog post provides a step-by-step guide to…
Introduction After introducing Far Sync instances and discussing their benefits in previous blog posts, this blog post provides a step-by-step guide to building a Far Sync instance and adding it to an existing Data Guard configuration. Parameters and directory paths used here are examples to make the setup easy to understand. Choose appropriate parameters and…
Database Heartbeat 