Introduction Oracle Database@Azure became available in the US East region in December 2023. It allows you to create an Exadata infrastructure dedicated to you and run your Oracle RAC databases on it. Oracle Database@Azure gives you more choices to run your mission-critical Oracle Databases in a Multicloud Environment. Oracle Exadata Database Service on Dedicated Infrastructure…
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 Refreshable PDB Clones enable you to copy a PDB and keep the copy (the clone) up-to-date with the source PDB (refresh the clone). The clone can be on the same CDB (local) or on another CDB (remote). If the target database is a primary database in a Data Guard configuration, then the refreshable PDB…
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…
The DOAG 2023 Conference + Exhibition is taking place from November 21 to 24 in Nuremberg, Germany with a theme day, two conference days, and a training day. I’m very excited to meet many customers, partners, colleagues, and friends there again in person. DOAG time has always been a good time. This time, it will…
Introduction Customers moving their workloads from on-premises to the Cloud want to take advantage of the best features and lowest prices each public cloud provider offers alongside other benefits. Microsoft’s customers usually prefer to run their applications in Azure while continuing to rely on Oracle Database for data management using Oracle Autonomous Database and Exadata…
Introduction After creating a PDB on the primary in a Data Guard environment, the PDB gets also created on standby. However, the standby will still be missing a TEMP file. To create a TEMP file, I got a comment from a customer that they were switching over to standby to create the TEMP file, which…
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…
Database Heartbeat 