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…
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…
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)…
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…
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…
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: Oracle Database version 21c introduces a new…
Introduction Oracle Cloud provides you the option to enable automatic backups with the click of a button. In case you have different backup requirements, you still have the flexibility to create your manual backup configurations and create your backups via command-line tools or directly using RMAN. This applies to VM DB Systems, Exadata Cloud Service,…
Update August 7th, 2023: now it’s possible to create a database from backup across Availability Domains in the same region using Cloud Tooling for BaseDB and ExaDB-D. Introduction Oracle Cloud VM DB Systems provide fully automated backups that can be enabled by the click of a button. The backups are stored in an Oracle-managed bucket.…
Introduction Oracle Cloud databases provide fully automated backups that can be enabled by the click of a button. However, the backups are stored in an Oracle-managed bucket. Hence, the automatic backups can only be used to restore on the same database host or create a new database in the same availability domain. If you want…
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…
Database Heartbeat 