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 21.3 supports logical migrations using Oracle GoldenGate. This makes it possible to migrate to Oracle Autonomous Database with zero downtime. This blog post provides step-by-step instructions on how to accordingly configure ZDM with the minimal parameters required. Data Pump will be used to create the initial load and GoldenGate extract and replicate…
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…
Introduction There is no doubt that database servers should always be provisioned in a private subnet. However, in some cases, e.g. test and development, you’d like to connect to your databases over the internet using SQL Developer installed on your local (Windows) computer. The Environment My environment for this blog post consists of the following:…
Introduction Oracle Databases on Oracle Cloud are created using the Multitenant architecture. All databases are encrypted using Transparent Data Encryption (TDE) by default. All databases on Exadata, Bare Metal machines, and RAC on Virtual Machines use ASM storage management. For Single Instance databases on Virtual Machine DB systems you have the choice between Logical Volume…
Introduction Partitioned Tables allow you to subdivide tables into smaller pieces (partitions) that can be managed and accessed at a finer level of granularity. The nice thing is that it is entirely transparent to your SQL SELECT statements and to the application. External (Partitioned) Tables enable you to access data on external storage as if…
Introduction Oracle Multitenant enables you to migrate and consolidate multiple databases as PDBs into one CDB. Starting with Oracle Database release 12.2.0.1, PDBs within the same CDB can be of different character sets, provided the CDB is created with the AL32UTF8 character set. If you are using Application Containers, then all application PDBs under the…
Introduction This is a step by step instruction of the minimum steps needed to import your Data Pump dump files into Oracle Autonomous Database. Without installing anything! Before you export your data, have a look at best practices and what to consider when you migrate to Autonomous Database. Step 0: Upload you Dump Files into…
Database Heartbeat 