Category: Disaster Recovery

How to measure Network Latency for Oracle Data Guard Replication

Introduction Oracle Data Guard replicates data from the primary to one or multiple standby databases for high availability and disaster recovery. The decision to transfer the redo synchronously or asynchronously depends on your RTO and RPO. Synchronous redo transport provides zero data loss and lower recovery time, but your application needs to wait until the…

How to create a Single Service Name in Data Guard Environments on Oracle Cloud

Introduction Oracle Data Guard provides high availability and disaster recovery by replicating data from the primary to standby databases. In case of an outage on the primary site or for maintenance operation, a standby database becomes a primary and continues serving application requests. This role switch should be transparent for applications, not requiring any changes…

How PDB Recovery Isolation in 21c makes your Life easier

Introduction We already talked about remote PDB cloning in Data Guard environments in previous blog posts. As the datafiles of the cloned PDB are not present on the standby database, there are several manual steps to be followed to create the PDB on the standby site in 19c: Using Transient no-standby PDB. Using STANDBYS=NONE followed…

Do I need the Advanced Security Option on-premises for Hybrid Cloud Disaster Recovery?

In the case of hybrid disaster recovery and having an unencrypted database on-premises, you can create the corresponding unencrypted standby database in the cloud using RMAN DUPLICATE or RESTORE from Object Storage. When you create a new unencrypted tablespace on the on-premises primary database, the standby database in the cloud creates the corresponding unencrypted tablespace via redo. So everything is fine and you…

Can I use fewer CPUs on Data Guard Standby to save costs?

One of the most beneficial cloud features is scalability on-demand, paying only for what you use, and releasing the resources when not needed anymore. So the question is, could I configure the standby database to use fewer CPUs than the primary to save costs? Yes, BUT… you have to consider a few things! Oracle Cloud provides…