Oracle Database Migration Methods :On-Prem to OCI

Evaluate database version, operating system, size, endianness, and character set to choose an Oracle migration method, then apply transportable, pluggable, or zero-downtime strategies with testing in a non-production environment.

Understand how database character sets determine supported languages, like western european and ISO 8859-1, and why utf-8 based sets and endianness matter for migration compatibility and data loss prevention.

Discover how a data transfer appliance speeds on-prem to Oracle Cloud migrations by shipping data to Oracle, storing it in the object store, and enabling fast restores for multi-petabyte transfers.

Explore how to set up the on-prem environment as a first step in migrating Oracle databases to Oracle Cloud Infrastructure (OCI).

Learn how Vagrant automates the creation of virtual machines with VirtualBox, using a vagrant file and pre-built vagrant boxes to quickly provision Oracle database lab environments.

Learn how to install VirtualBox and ensure compatibility with Vagrant on macOS, then use Vagrant with VirtualBox to automate creating virtual machines for Oracle migration from on-prem to OCI.

Learn how to install Vagrant on Mac (and Windows), verify the installation with vagrant -h and vagrant -V, and prepare to use Vagrant with VirtualBox for an on-prem environment.

Configure and provision a CentOS 7 virtual machine with Vagrant and VirtualBox, setting a private network, hostname, memory, and a named VM, then bring it up and SSH in.

Install Oracle 18c XE on a VM using a four-step process: staging, download, rpm, and yum local install with a 1539 listener. This creates a container database with pluggable database.

Set up an on-prem Oracle database environment with schemas and tablespaces, create a pluggable database, and prepare sample HR data for migration to Oracle Cloud.

Set up an Oracle Cloud Infrastructure database system and learn introductory steps for migrating from on-prem to OCI, covering initial configuration and essential setup considerations.

Create a compartment in Oracle Cloud Infrastructure to organize and isolate resources, using a DB Alchemist compartment as an example; then proceed to vcN creation and database deployment.

generate a public and private key pair on your laptop with ssh-keygen, save as id_rsa and id_rsa.pub in .ssh, and copy the public key to the OCI cloud machine.

Provision an oracle 18c database on oracle cloud by creating a vm-based db system in a chosen compartment and vcN, configuring ssh keys, license mode, and grid infrastructure with ACM.

Identify the OCI DB system post provisioning status, locate the public IP in the nodes view, and verify SSH access to the container database and listener for on-prem migration.

Learn to establish ssh connectivity from the on-prem VM to Oracle Cloud by generating RSA keys, updating authorized_keys, and connecting with the private key.

Explore Oracle database migration methods from on-premises to OCI through an introductory discussion and live demos, highlighting best practices and key considerations.

Explore Oracle database migration strategies from on-prem to OCI, including data pump export/import. Learn transportable tablespace, full transportable, arm and cross-platform PDB, inconsistent backups, object store backups, and unplug/plug workflows.

Present migration use cases from 11g to 12c and from non-CDB to CDB on OCI, detailing data pump, transportable tablespace, full transportable, unplug/plug, cross-platform, and SQL developer methods.

Use data pump conventional export/import to migrate Oracle databases across endian formats and character sets, unloading into dump files for target loading; downtime is required and it suits smaller databases.

Learn the conventional data pump export/import workflow for migrating on-prem Oracle databases to Oracle Cloud, including setting up data pump directories, exporting schemas, and importing with optional tablespace remapping.

Demonstrate migrating a schema from on-prem to Oracle Cloud using data pump export and import with expdp and impdp, dump files, and directories.

Use data pump transportable tablespace to move large data by copying data files, keeping the source read-only during export, and using a data pump directory for on-prem to OCI migration.

Learn data pump full transportable, a fast migration method that combines transportable tablespaces with export import to move user, application, and system metadata via a single import command.

Explore data pump full transportable for migrating an entire Oracle database to OCI, using full=y and transportable=always, with automatic handling of read-only tablespaces, data files, and dump files.

Use RMAN convert transportable tablespace with data pump to move data files from on-prem to OCI, applying endian format conversion when needed and ensuring compatible database character sets.

Unplug and plug a pluggable database from a container database to migrate from on-prem to OCI, noting downtime, data file and xml transfer, and potential PDB violations from patch mismatches.

Explore the unplug and plug workflow for migrating pluggable databases from on-prem to OCI, including generating the XML, transferring files, and resolving violations before opening the destination PDB.

Learn how to move pluggable databases from on-prem to OCI using RMAN cross-platform transportable PDB, including backup for transport and unplug to XML, with little endian compatibility.

Master the RMAN cross-platform transportable PDB workflow to move an on-prem pluggable database to OCI. Use backup sets, restore foreign data files, and resolve plug-in violations before opening the PDB.

Master RMAN cross-platform transportable PDB with inconsistent backups. Create level zero, level one backups, unplug, ship XML, and restore on the container database using level one backups after resolving violations.

Explore RMAN cross-platform transportable PDBs with inconsistent backups to migrate from on-prem to OCI, including level zero backups, incremental level one backups, and unplug/plug workflows.

Explore RMAN backup and restore using the Oracle Cloud backup module to back up directly to Oracle Cloud object storage from on-prem, with encryption and signed API authentication.

Learn the oracle cloud backup module workflow to back up on-prem databases to the oracle cloud object store and restore from the cloud, including OTN downloads and OCI signing keys.

Demonstrates end-to-end setup and encrypted backups with the Oracle database cloud backup module, from RSA key generation to streaming backups directly to Oracle object storage via sbt tape.

Demonstrates performing an RMAN restore from on-prem backups to an OCI compute instance using the oracle cloud backup module, including OPC setup, wallet, and decryption steps.

Use SQL Developer to migrate schemas and objects from on-prem Oracle to OCI by selecting items, exporting a cart, and running the create table and insert statements on target database.

Demonstrates migrating a database and schema objects from on prem to Oracle Cloud using SQL Developer, exporting selected tables and views with insert statements.

Provision an Oracle database in AWS RDS, selecting edition and license options, configuring a dev/test instance with burstable class, VPC, subnet group, security groups, and public access for migration testing.

Understand the AWS data migration service workflow from RDS to OCI. Set up replication instances and endpoints, test connections, and configure migration tasks.

Demonstrates creating a source endpoint in AWS DMS for an Oracle RDS instance, testing connectivity, selecting the VPC and replication instance, and creating the endpoint for migration.

Demonstrates configuring an Oracle target endpoint in AWS DMS, testing connectivity with SQL Developer, and preparing an empty schema and security rules to enable 1521 connectivity before migration tasks.

Demonstrates creating and running an AWS DMS migration task from RDS Oracle to OCI, using a selection rule for the DB Alchemist schema and EMP table, and validating the load.