摘要:本文介绍使用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.
云端起舞系列文章回顾:
1、Configure and Practice Backup and Recovery in Cloud 在Oracle公有云上备份与恢复的配置和实践
2、Create a Primary and Standby Database in the Cloud 在Oracle公有云上创建standby数据库
3、 Create a database clone in the cloud 在Oracle公有云上创建克隆数据库
4、Oracle Cloud Database Patching Then patch like a king with single click Database As A Service (DbaaS) Oracle云上一键安装数据库补丁集
5、Find the IP address of an Oracle Public Cloud Service VM 快速查找Oracle公有云服务上VM服务器的IP地址
6、Replace the public/private keypair associated to an Oracle Public Cloud Service with a new pair.Oracle公有云服务的公私密钥对详解
作者简介:
Joel Perez
Oracle ACE总监, Maximum Availability OCM,OTN 专家,全球第一批ACE称号获得者,致力于数据库高可用、灾难恢复、升级迁移和数据复制等方向设计和实现解决方案。
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 DBaaSPDB
将文件还原到DBaaS PDB中
1、Restore the TBS_1 and TBS_2 tablespaces ofthe on-premises PREM_PDB PDB into the DBaaS PDB1 PDB.
1.将内部部署PREM_PDB PDB的TBS_1和TBS_2表空间恢复到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。
希望文章对你有帮助,请期待我们后期的持续分享。
有任何疑问可以加入云和恩墨大讲堂跟讲师面对面交流。
加入"云和恩墨大讲堂"微信群,参与讨论学习
搜索 盖国强(Eygle)微信号:eyygle,或者扫描下面二维码,备注:云和恩墨大讲堂,即可入群。每周与千人共享免费技术分享,与讲师在线讨论。