Oracle Cloud:使用跨平台表空间传输将内部表空间迁移到DBaaS数据库
摘要:本文介绍使用RMAN的方法将本地Oracle Database 12c数据库转换和迁移到在不同平台上运行的Oracle Database 12c DBaaS。
This article covers the RMAN method to convertand migrate on-premises Oracle Database 12c databases to an Oracle Database 12cDBaaS that run on different platforms.
In this article, you learn how to convert thedata files of an on-premises Oracle Database 12c PDB or PDB tablespaces torestore them into the Oracle Database 12c DBaaS database using various modes.
本文讲述如何转换内部部署的Oracle Database 12c PDB或PDB表空间的数据文件,以使用各种模式将它们还原到Oracle Database 12c DBaaS数据库中。
Migrate On-premises Tablespaces to DBaaSDatabase Using Cross-Platform Tablespace transport
将内部表空间迁移到DBaaSDatabase使用跨平台表空间传输
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.
首先我们来看如何备份内部部署数据库的表空间,转换数据文件并将其恢复到DBaaS ORCL CDB的现有PDB1 PDB中。
Backup the On-premises PDB Tablespaces
1.To backup the on-premises tablespaces ofthe PREM_PDB PDB in cross-platform tablespace transport mode, you must set thetablespaces to READ ONLY mode.
要以跨平台表空间传输方式备份PREM PDB PDB的内部表空间,必须将表空间设置为READ ONLY模式。
2.- Retrieve the platform name of the DBaaSdatabase. Connect to the DBaaS database.
2.检索DBaaS数据库的平台名称, 连接到DBaaS数据库。
3.- Backup the TBS_1 and TBS_2 tablespaces ofthe on-premises PREM_PDB PDB.
3、备份本地PREM PDB PDB的TBS_1和TBS_2表空间。
Note: The TO PLATFORM clause converts the datafiles on the on-premises platform. When you will have transferred the files,they will be ready to be plugged into the DBaaS PDB.
注意:TO PLATFORM子句转换内部部署平台上的数据文件,传输文件时,它们将准备插入DBaaS PDB。
Transfer the Files of theOn-premises Platform to the DBaaS VM
将本地平台的文件传输到DBaaS VM
Use SCP to transfer the backup set and dumpfile securely from the on-
premises platform (/on-premises directory) to the DBaaS VM (/DBaaSdirectory).
使用SCP将备份集和转储文件从内部部署平台(/本地目录)安全地传输到DBaaS VM(/ DBaaSdirectory)。
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.
2.-将传输的表空间的数据文件的名称显示到DBaaS PDB中。
3.- Set the transported tablespaces read writein the DBaaS PDB.
3.-在DBaaS PDB中设置传输的表空间读写。
4.- If you intend to work with the on-premisestablespaces, set them back to read write.
4.-如果您打算使用本地表空间,请将它们重新设置为读写。
5.- Display the names of the data files of thetransported tablespaces from the on-premises PDB.
5.-从内部部署的PDB显示传输的表空间的数据文件的名称。
Summary
You can convert and migrate on-premisesnon-CDBs and PDBs before migrating them into the DBaaS database that run ondifferent platforms.
在将其迁移到在不同平台上运行的DBaaS数据库之前,可以转换和迁移本地非CDB和PDB。
In this article, you learned to:
Transport tablespaces of an on-premises PDBthat runs on one platform into the DBaaS CDB that runs on a different platform
Wehope this article can be helpful for you and see us on next one。
希望文章对你有帮助,请期待我们后期的持续分享。