The Oracle Maximum Availability Architecture (MAA) product management team invites you to attend its next MAA Summit for informative and interactive sessions on Oracle Database high availability and disaster recovery, Oracle Vector Search, and Exadata MAA. Learn about what’s new and provide your feedback directly to Oracle product management. When and Where Tuesday, May 14,…
Tag: Data Guard
Refreshable PDB Clones in Data Guard Environments On-premises and on Oracle Cloud
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…
How to create a TEMP File after PDB Creation in Data Guard Environments
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…
A Java Example for Oracle Application Continuity with Oracle Active Data Guard
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…
Automate Cross-region Data Guard Creation in Oracle Cloud with OCI CLI
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…
How to create Oracle Database Services for High Availability
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…
Features you probably think require Active Data Guard, but they do not
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…
A Step-by-Step Guide to Create and Enable Oracle Data Guard Far Sync
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…
Ensure Zero Data Loss at any Distance by using Oracle Data Guard Far Sync
Introduction Oracle Data Guard enables you to transport the redo to the standby database synchronously to ensure zero data loss. However, when the standby database is geographically too far, the latency becomes higher, impacting the commit response time and the transaction throughput at the primary database. Oracle Active Data Guard Far Sync can ensure zero…
FastSync or Far Sync? FastSync AND Far Sync!
Introduction FastSync and Far Sync seem to be very similar terms, especially in the spoken language. In my conversations, I have seen these terms being mixed up and even questions about using one OR the other. Indeed, FastSync and Far Sync are two different things that can be used independently or make perfect sense to…
Database Heartbeat 