Oracle Cloud: Migrate On-premises Tablespaces to DBaaS Database Using Cross-Platform Tablespace tran

Published : 2019-08-19 10:31:26    Publisher :

By Joel Pérez ( Oracle ACED )

Purpose

  This article covers the RMAN method to convert and migrate on-premises Oracle Database 12c databases to an Oracle Database 12c DBaaS that run on different platforms.

Introduction

  In this article, you learn how to convert the data files of an on-premises Oracle Database 12c PDB or PDB tablespaces to restore them into the Oracle Database 12c DBaaS database using various modes.

Migrate On-premises Tablespaces to DBaaS Database Using Cross-Platform Tablespace transport

  This section explains how to transport tablespaces of an on-premises database that runs on one platform into the DBaaS database that runs on a different platform. The section therefore explains how to backup tablespaces of the on-premises database, convert the data files and restore them into the existing PDB1 PDB of the DBaaS ORCL CDB.

Backup the On-premises PDB Tablespaces

  1.- To backup the on-premises tablespaces of the PREM_PDB PDB in cross-platform tablespace transport mode, you must set the tablespaces to READ ONLY mode.

\

\

  2.- Retrieve the platform name of the DBaaS database. Connect to the DBaaS database.

\

  3.- Backup the TBS_1 and TBS_2 tablespaces of the on-premises PREM_PDB PDB.

\

\

\

\

Note:

The TO PLATFORM clause converts the data files on the on-premises platform. When you will have transferred the files, they will be ready to be plugged into the DBaaS PDB.

Transfer the Files of the On-premises Platform to the DBaaS VM

  Use SCP to transfer the backup set and dump file securely from the on-premises platform (/on-premises directory) to the DBaaS VM (/DBaaS directory).

\

 

Restore the Files into the DBaaS PDB

  1.- Restore the TBS_1 and TBS_2 tablespaces of the on-premises PREM_PDB PDB into the DBaaS PDB1 PDB.

\

 

\

  2.- Display the names of the data files of the transported tablespaces into the DBaaS PDB.

\

  3.- Set the transported tablespaces read write in the DBaaS PDB.

\

  4.- If you intend to work with the on-premises tablespaces, set them back to read write.

\

  5.- Display the names of the data files of the transported tablespaces from the on-premises PDB.

\

Summary

  You can convert and migrate on-premises non-CDBs and PDBs before migrating them into the DBaaS database that run on different platforms.

  In this article, you learned to:

  Transport tablespaces of an on-premises PDB that runs on one platform into the DBaaS CDB that runs on a different platform

We hope this article can be helpful for you and see us on next one

About the Author

  Joel Pérez is an Expert DBA ( Oracle ACE Director, Maximum Availability OCM, OCM Cloud Admin. & OCM12c/11g ) with over 17 years of Real World Experience in Oracle Technology, specialized in design and implement solutions of: High Availability, Disaster Recovery, Upgrades, Replication, Cloud and all area related to Oracle Databases. International consultant with duties, conferences & activities in more than 50 countries in 5 continents and countless clients around the world. Habitual and one of leading writers of Technical Oracle articles for: OTN Spanish & OTN Portuguese. Regular Speaker in worldwide Oracle events like: OTN LAD (Latin America), OTN MENA(Middle East & Africa), OTN APAC ( Asian Pacific), DTCC China and more. Joel has always been known for being a pioneer in Oracle technology since the early days of his career being the first Latin American awarded as “OTN Expert” at year 2003 by Oracle Corp., one of the first “Oracle ACE” globally in the Oracle ACE Program at year 2004 and as one of the biggest professional achievement in his career he was honoured as one of the first “OCM Database Cloud Administrator” & Maximum Availability OCM in the world. Currently Joel works as Chief Technologist in “Yunhe Enmo (Beijing) Technology Co.,Ltd”., company located in Beijing, China www.Enmotech.com

Contact Us