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.…
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. However, these databases might be of different character sets. 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. By the way,…
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…
Introduction In the Oracle Cloud every newly created database from 12c onward uses the Oracle Multitenant Architecture. Transparent Data Encryption is also enabled by default. So, as soon as you use Data Guard and create new PDBs, you have to take care of copying the wallets to the standby server. We already discussed two approaches…
