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…
Category: Disaster Recovery
How to Configure Object Storage Cross-Region Replication for Disaster Recovery
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…
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…
How Oracle Active Data Guard provides better Disaster Recovery than AWS RDS Read Replicas
Introduction Recently I have been asked whether AWS RDS for Oracle provides a solid disaster recovery solution using Read Replicas based on Oracle Active Data Guard. Oracle (Active) Data Guard is undoubtedly Oracle’s most comprehensive data protection and disaster recovery solution for Oracle Database. However, whenever I read or hear “RDS”, the next word that…
Ensure Disaster Recovery by replicating Automatic Backups across Regions in Oracle Cloud
Introduction Before we start, I want to mention that Oracle (Active) Data Guard provides the best disaster recovery solution for Oracle Databases with zero data loss and minimal recovery time. Restoring from backup usually comes with a much higher RPO and RTO than what Data Guard provides. However, if restoring from backup satisfies your application’s…
Three Ways to Use Backups for Disaster Recovery across Regions in Oracle Cloud
Introduction Oracle Data Guard provides zero or near zero data loss and a recovery time of just a few minutes. For unrecoverable failure, a restore from backup usually takes hours and restores your data to the last backup. If you have applications that tolerate the RTO and RPO provided by a restore from backup, having…
Fast-Start Failover in Data Guard Environments on Oracle Cloud
Introduction Oracle Data Guard and Active Data Guard ensure high availability and disaster recovery during maintenance operations and in case of outages. Recovery Point Objective (RPO) of zero (zero data loss) can be achieved by setting up SYNC or FASTSYNC replication, even at any distance, using Far Sync without compromising performance. Recovery Time Objective (RTO)…