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…
Introduction Enabling Oracle Data Guard in Oracle Cloud is a matter of a few clicks in the Cloud Console. However, many customers prefer to manage their resource provisioning in an automated way using Terraform, OCI CLI, SDKs, or REST API for more consistency and efficiency. Providing the correct values in the OCI CLI command to…
Introduction OracleDB for Azure (or, Oracle Database Service for Azure) simplifies multicloud deployments by providing an Oracle-managed interconnect between your Azure and OCI accounts. Customers running their workloads on Azure can now keep the application on Azure and move the Database to Oracle Cloud to benefit from Cloud Automation, Exadata Service, Oracle RAC, and more.…
Database Heartbeat 