Infrastructure at your Service

Olivier Toussaint

How to migrate your tablespace from 11g to a PDB in the Cloud

Goal

We will take a tablespace named FOR TRAVEL for migrate it into a PDB situated in your Europe Cloud in extreme performance database.

This migration will be executed with Data Pump and transportable tablespace method. We will migrate the tablespace “FOR_TRAVEL” with a table  from Windows Oracle 11g database to Linux  Oracle 12c PDB Database.

On-Premise Database

You must have :

A directory and permissions :

directories

Operactions

Let’s take our BACKUP_DIR directory for the migration on Premise.

Let’s put the tablespace to migrate  Read Only :

RO

Outside of SQLPLUS let’s launch Data Pump command

export2

Preparing the migration

Copying datafile and dump file from 11g Oracle database to 12c Oracle Database in Cloud instance

Verifying the directory on 12c Oracle Database in Cloud instance

Our import directory will be DATA_PUMP_EXP

IMP

Copying

For the copy we used SCP command without a private key SSH because we have our tunnel SSH already started

IMPEXP

Importing into PBD1

Before to import make sure your user is  created in the PDB. It’s the same user than in your on-premise database.

imp1

 Importing Dump file

imp2

Once the import is complete we pass the FOR_TRAVEL tablespace in read write mode

readwrite

Verifying the migration

verifying

It’s very easy to migrate your tablespace from windows on-premise to your 12c cloud pluggable database.

Leave a Reply

Olivier Toussaint
Olivier Toussaint

Consultant