在知识库中专注阅读，并随时返回相关工具与课程
原文地址：https://oracle-base.com/articles/19c/multitenant-dbca-pdb-relocate-19chttps://oracle-base.com/articles/19c/multitenant-dbca-pdb-relocate-19c 原文作者：Tim Hall Oracle Database 12c 第 2 版 12.2 引入了使用 CRE
原文地址：https://oracle-base.com/articles/19c/multitenant-dbca-pdb-relocate-19c 原文作者：Tim Hall
Oracle Database 12c 第 2 版 (12.2) 引入了使用 CREATE PLUGGABLE DATABASE 命令重新定位可插拔数据库 (PDB) 的功能。在 Oracle 19c 中，现在可以使用数据库配置助手 (DBCA) 执行可插拔数据库 (PDB) 的重定位。
本章目标：掌握本章核心知识点 前置要求：完成前序章节学习 预计时长：60 分钟
连接到远程 CDB 并准备重定位：
1export ORAENV_ASK=NO2export ORACLE_SID=cdb33. oraenv4export ORAENV_ASK=YES56sqlplus / as sysdba在远程数据库中创建一个用户以与数据库链接一起使用。在这种情况下，我们将在远程 PDB 中使用一个普通用户。
1CREATE USER c##remote_clone_user IDENTIFIED BY remote_clone_user CONTAINER=ALL;2GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##remote_clone_user CONTAINER=ALL;3GRANT SYSOPER TO c##remote_clone_user CONTAINER=ALL;与常规重定位不同，我们不需要创建数据库链接。我们只需要提供用于创建链接的凭据。DBCA 完成剩下的工作。
检查远程 CDB 是否处于本地 undo 模式和归档模式。
1CONN / AS SYSDBA23COLUMN property_name FORMAT A304COLUMN property_value FORMAT A3056SELECT property_name, property_value7FROM database_properties8WHERE property_name = 'LOCAL_UNDO_ENABLED';910PROPERTY_NAME PROPERTY_VALUE11------------------------------ ------------------------------12LOCAL_UNDO_ENABLED TRUE1314SQL>151617SELECT log_mode18FROM v$database;1920LOG_MODE21------------22ARCHIVELOG2324SQL>因为远程 CDB 是本地 undo 模式和归档模式，所以我们不需要把远程数据库变成只读模式。
连接到本地 CDB 并为迁移做准备：
1export ORAENV_ASK=NO2export ORACLE_SID=cdb13. oraenv4export ORAENV_ASK=YES56sqlplus / as sysdba检查本地 CDB 是否处于本地 undo 模式和归档模式：
1CONN / AS SYSDBA23COLUMN property_name FORMAT A304COLUMN property_value FORMAT A3056SELECT property_name, property_value7FROM database_properties8WHERE property_name = 'LOCAL_UNDO_ENABLED';910PROPERTY_NAME PROPERTY_VALUE11------------------------------ ------------------------------12LOCAL_UNDO_ENABLED TRUE1314SQL>151617SELECT log_mode18FROM v$database;1920LOG_MODE21------------22ARCHIVELOG2324SQL>在 19c 中 -relocatePDB 引入了 DBCA 命令，允许我们将 PDB 重新定位到不同的容器数据库 (CDB)。
1 -relocatePDB - Command to Relocate a pluggable database.2 -remotePDBName <Name of the pluggable database to clone/relocate>3 -pdbName <Pluggable database name>4 -dbLinkUsername <Common user of a remote CDB, used by database link to connect to remote CDB.>5 -remoteDBConnString <EZCONNECT string to connect to Source database for example "host:port/servicename">6 -sourceDB <Database unique name for RAC database or SID for Single Instance database>7 [-remoteDBSYSDBAUserName <User name with SYSDBA privileges of remote database>]8 [-dbLinkUserPassword <Common user password of a remote CDB, used by database link to connect to remote CDB.>]9 [-useWalletForDBCredentials <true | false> Specify true to load database credentials from wallet]10 -dbCredentialsWalletLocation <Path of the directory containing the wallet files>11 [-dbCredentialsWalletPassword <Password to open wallet with auto login disabled>]12 [-remoteDBSYSDBAUserPassword <Password for remoteDBSYSDBAUserName user of remote database.>]13 [-sysDBAUserName <User name with SYSDBA privileges>]14 [-sysDBAPassword <Password for sysDBAUserName user name>]您可以在 此处 查看该 -relocatePDB 命令的完整语法，尽管在编写文档时与该命令提供的实用程序用法不匹配。
1dbca -relocatePDB -help确保环境设置为指向本地实例 “cdb1”，并从 “cdb3” 实例中名为 “pdb5” 的远程 PDB 中重新定位名为 “pdb5” 的 PDB。
1export ORACLE_SID=cdb12export ORAENV_ASK=NO3. oraenv4export ORAENV_ASK=YES567dbca -silent \8 -relocatePDB \9 -pdbName pdb5 \10 -sourceDB cdb1 \11 -remotePDBName pdb5 \12 -remoteDBConnString localhost:1521/cdb3 \13 -remoteDBSYSDBAUserName sys \14 -remoteDBSYSDBAUserPassword SysPassword1 \15 -dbLinkUsername c##remote_clone_user \16 -dbLinkUserPassword remote_clone_user17Prepare for db operation1850% complete19Create pluggable database using relocate PDB operation20100% complete21Pluggable database "pdb5" plugged successfully.22Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb1/pdb5/cdb10.log" for further details.23$连接到本地根容器并检查新 PDB 的状态：
1COLUMN name FORMAT A3023SELECT con_id, name, open_mode4FROM v$pdbs5ORDER BY 1;67 CON_ID NAME OPEN_MODE8---------- ------------------------------ ----------9 2 PDB$SEED READ ONLY10 3 PDB1 READ WRITE11 4 PDB5 READ WRITE1213SQL>要将其重新定位，我们需要在本地数据库中创建链接用户：
1CREATE USER c##remote_clone_user IDENTIFIED BY remote_clone_user CONTAINER=ALL;2GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE TO c##remote_clone_user CONTAINER=ALL;3GRANT SYSOPER TO c##remote_clone_user CONTAINER=ALL;确保将环境设置为指向远程实例 “cdb3”，并从 “cdb1” 实例中名为 “pdb5” 的本地 PDB 中重新定位名为 “pdb5” 的 PDB。
1export ORACLE_SID=cdb32export ORAENV_ASK=NO3. oraenv4export ORAENV_ASK=YES567dbca -silent \8 -relocatePDB \9 -pdbName pdb5 \10 -sourceDB cdb3 \11 -remotePDBName pdb5 \12 -remoteDBConnString localhost:1521/cdb1 \13 -remoteDBSYSDBAUserName sys \14 -remoteDBSYSDBAUserPassword SysPassword1 \15 -dbLinkUsername c##remote_clone_user \16 -dbLinkUserPassword remote_clone_user17Prepare for db operation1850% complete19Create pluggable database using relocate PDB operation20100% complete21Pluggable database "pdb5" plugged successfully.22Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/cdb1/pdb5/cdb10.log" for further details.23$连接到远程根容器并检查新 PDB 的状态：
1COLUMN name FORMAT A3023SELECT con_id, name, open_mode4FROM v$pdbs5ORDER BY 1;67 CON_ID NAME OPEN_MODE8---------- ------------------------------ ----------9 2 PDB$SEED READ ONLY10 3 PDB5 READ WRITE1112SQL>这些示例中使用的实例和可插入数据库是使用以下命令创建的：
1# Local container (cdb1).2dbca -silent -createDatabase \3 -templateName General_Purpose.dbc \4 -gdbname cdb1 -sid cdb1 -responseFile NO_VALUE \5 -characterSet AL32UTF8 \6 -sysPassword SysPassword1 \7 -systemPassword SysPassword1 \8 -createAsContainerDatabase true \9 -numberOfPDBs 1 \10 -pdbName pdb1 \11 -pdbAdminPassword PdbPassword1 \12 -databaseType MULTIPURPOSE \13 -memoryMgmtType auto_sga \14 -totalMemory 2048 \15 -storageType FS \16 -datafileDestination "/u02/oradata/" \17 -redoLogFileSize 50 \18 -emConfiguration NONE \19 -ignorePreReqs2021# Remote container (cdb3) with PDB (pdb5).22dbca -silent -createDatabase \23 -templateName General_Purpose.dbc \24 -gdbname cdb3 -sid cdb3 -responseFile NO_VALUE \25 -characterSet AL32UTF8 \26 -sysPassword SysPassword1 \27 -systemPassword SysPassword1 \28 -createAsContainerDatabase true \29 -numberOfPDBs 1 \30 -pdbName pdb5 \31 -pdbAdminPassword PdbPassword1 \32 -databaseType MULTIPURPOSE \33 -memoryMgmtType auto_sga \34 -totalMemory 2048 \35 -storageType FS \36 -datafileDestination "/u02/oradata/" \37 -redoLogFileSize 50 \38 -emConfiguration NONE \39 -ignorePreReqs4041 4243# Delete the instances.44#dbca -silent -deleteDatabase -sourceDB cdb1 -sysDBAUserName sys -sysDBAPassword SysPassword145#dbca -silent -deleteDatabase -sourceDB cdb3 -sysDBAUserName sys -sysDBAPassword SysPassword1数据库启用了 Oracle Managed Files (OMF) 并切换到归档日志模式：
1export ORAENV_ASK=NO2export ORACLE_SID=cdb33. oraenv4export ORAENV_ASK=YES56sqlplus / as sysdba <<EOF78ALTER SYSTEM SET db_create_file_dest = '/u02/oradata';910SHUTDOWN IMMEDIATE;11STARTUP MOUNT;12ALTER DATABASE ARCHIVELOG;13ALTER DATABASE OPEN;1415ALTER PLUGGABLE DATABASE pdb5 OPEN;16ALTER PLUGGABLE DATABASE pdb5 SAVE STATE;1718EXIT;19EOF202122export ORAENV_ASK=NO23export ORACLE_SID=cdb124. oraenv25export ORAENV_ASK=YES2627sqlplus / as sysdba <<EOF2829ALTER SYSTEM SET db_create_file_dest = '/u02/oradata';3031SHUTDOWN IMMEDIATE;32STARTUP MOUNT;33ALTER DATABASE ARCHIVELOG;34ALTER DATABASE OPEN;3536ALTER PLUGGABLE DATABASE pdb1 OPEN;37ALTER PLUGGABLE DATABASE pdb1 SAVE STATE;3839EXIT;40EOF