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…
Tag: RMAN
Restore DBCS VM Databases from Automatic Backup across Availability Domains
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.…
Use an Existing RMAN Backup with Zero Downtime Migration
Introduction From the very first version, Oracle Zero Downtime Migration (ZDM) supports physical online, and offline migrations using RMAN and Data Guard. However, every migration job was creating a new RMAN backup from the source database to be used to create the target database. Starting with ZDM version 21.2, you can skip the full backup…
Oracle Cloud Services for On-premises Oracle Databases
Introduction We discussed why Oracle Cloud is the best place to run your Oracle databases in a previous blog post. However, it is also understandable that not all databases can be moved to the cloud (yet) and it might be not affordable for everyone to run all of these databases on Cloud@Customer. Keeping your Oracle…
Restore a TDE encrypted Cloud Database Backup to another Availability Domain, OCI Region, or On-Premises
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…
Part 5/5: Zero Downtime Migration (ZDM) – Physical Offline Migration using RMAN
Introduction ZDM uses RMAN to perform an offline physical migration. It backs up the source database and instantiates a new database from this backup to the target environment. This is similar to cloning a database. The target database has no relationship to the source, so there is no data synchronization or fallback capability. No SQL*Net…
Part 1/5: Zero Downtime Migration (ZDM) – Introduction & Installation
Introduction Oracle Zero Downtime Migration (ZDM) is a free-to-use software solution that allows you to automate your Oracle database migrations to Oracle Cloud. Initially, ZDM supported Data Guard-based migrations following the principles of Oracle Maximum Availability Architecture (MAA). To support Standard Edition migrations, ZDM uses RMAN backup and restore instead. The new ZDM version 21c…
Part 6/10: Migration Methods using RMAN
In this part we will introduce the following migration methods using RMAN: RMAN Transportable Tablespace with Data Pump RMAN Convert Transportable Tablespace with Data Pump RMAN Cross-Platform Transportable Tablespace Backup Sets RMAN Cross-Platform Transportable PDB RMAN Cross-Platform Transportable PDB Inconsistent Backups RMAN Duplicate from an Active Database RMAN Backup & Restore RMAN Oracle Recovery Manager…