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…
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…
Introduction As IT environments are growing and becoming more complex, the need for standardization, cost reduction, and greater agility is raising more than ever. Cloud solutions provide customers with features and capabilities to exactly achieve these goals and satisfy their business demands. When it comes to moving Oracle databases to the cloud, you might ask…
Introduction Cloning PDBs in Multitenant environments is an easy way to migrate a PDB from one CDB to another or to create multiple copies of that PDB for test and development purposes. The data files are being read from the source and transferred to the target CDB. Hence, cloning a PDB also means generating workload…
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…
Introduction ZDM uses Oracle Data Guard to perform an online physical migration. This means: it backs up the source database, instantiates a standby database from this backup to the target environment, configures Data Guard to synchronize the source and target databases, and finally switches over to the target database. ZDM allows you to pause the…
Introduction Oracle Blockchain Table was initially introduced in release version 20c (preview only) and later in 21c, but the feature has been backported and is now available in version 19c as well. Blockchain tables are insert-only tables that provide a highly tamper-resistant persistence option. The rows are chained by storing the previous row’s hash in…
Introduction ZDM version 21c supports logical migrations using Oracle GoldenGate as described in Part 2 or using the classical Data Pump export and import. This blog post provides a step by step instruction how to accordingly configure ZDM for Data Pump export and import with the minimal parameters required. Using Data Pump export and import…
Introduction ZDM version 21c supports logical migrations using Oracle GoldenGate. This makes it possible to migrate to Oracle Autonomous Database with zero downtime. This blog post provides a step by step instruction how to accordingly configure ZDM with the minimal parameters required. Data Pump will be used to create the initial load and GoldenGate extract…
Introduction Oracle Zero Downtime Migration (ZDM) is a free to use software solution that allows you to automate your Oracle database migrations from on-premises 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.…
Database Heartbeat 