Blogs

Part 2/5: Zero Downtime Migration (ZDM) – Logical Online Migration using Oracle GoldenGate

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…

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 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.…

Connect SQL Developer to Oracle Cloud Databases in Private Subnets

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:…

Migrating from non-encrypted, non-CDB on local file system to encrypted PDB on ASM

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…

How to create PDBs with different Character Sets in the same CDB

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,…

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.