本篇内容主要讲解“如何使用RMAN对CDB中的PDB进行复制”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用RMAN对CDB中的PDB进行复制”吧!

1.检查源RAC CDB(jy)的参数文件，数据文件，联机日志文件，控制文件，归档日志文件的存储目录

SQL>showparameterspfileNAMETYPEVALUE-------------------------------------------------------------------------------------------spfilestring+DATA/JY/PARAMETERFILE/spfile.303.961976713SQL>selectnamefromv$datafile;NAME--------------------------------------------------------------------------------+DATA/JY/DATAFILE/system.317.962209603+DATA/JY/DATAFILE/sysaux.298.962209605+DATA/JY/DATAFILE/undotbs1.277.962209605+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675+DATA/JY/DATAFILE/users.301.962209605+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675+DATA/JY/DATAFILE/undotbs2.312.962209605+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409SQL>showparametercontrol_filesNAMETYPEVALUE------------------------------------------------------------------------------------------control_filesstring+DATA/JY/CONTROLFILE/current.272.961976315SQL>selectmemberfromv$logfile;MEMBER--------------------------------------------------------------------------------+DATA/JY/ONLINELOG/group_2.302.961976321+DATA/JY/ONLINELOG/group_1.261.961976319+DATA/JY/ONLINELOG/group_3.263.961976697+DATA/JY/ONLINELOG/group_4.262.961976705SQL>archiveloglistDatabaselogmodeArchiveModeAutomaticarchivalEnabledArchivedestination+TEST/archOldestonlinelogsequence127Nextlogsequencetoarchive128Currentlogsequence128

2.在目标主机上创建存储目标数据库(dupjy)相关数据库文件的目录，目标主机上的/u01/app/oracle/oradata/dupjy目录用来存储数据库的数据文件，控制文件，联机重做日志文件),/u01/app/oracle/arch/dupjy目录用来存储数据库的归档重做日志文件。

3.将源数据库的密码文件复制到目标主机的相应目录中并修改为目标数据库(dupjy)对应的文件名

[grid@jytest1~]$srvctlconfigdatabase-dbjyDatabaseuniquename:jyDatabasename:jyOraclehome:/u01/app/oracle/product/12.2.0/dbOracleuser:oracleSpfile:+DATA/JY/PARAMETERFILE/spfile.303.961976713Passwordfile:+DATA/JY/PASSWORD/pwdjy.274.961976109Domain:Startoptions:openStopoptions:immediateDatabaserole:PRIMARYManagementpolicy:AUTOMATICServerpools:DiskGroups:DATAMountpointpaths:Services:Type:RACStartconcurrency:Stopconcurrency:OSDBAgroup:dbaOSOPERgroup:operDatabaseinstances:jy1,jy2Configurednodes:jytest1,jytest2CSScritical:noCPUcount:0Memorytarget:0Maximummemory:0Defaultnetworknumberfordatabaseservices:Databaseisadministratormanaged[grid@jytest1~]$asmcmdcp+DATA/JY/PASSWORD/pwdjy.274.961976109/home/grid/pwddupjycopying+DATA/JY/PASSWORD/pwdjy.274.961976109->/home/grid/pwddupjy[oracle@shard1dbs]#scpgrid@10.138.130.171:/home/grid/pwddupjy/u01/app/oracle/product/12.2.0/db/dbs/Theauthenticityofhost'10.138.130.171(10.138.130.171)'can'tbeestablished.ECDSAkeyfingerprintis7a:62:58:8b:77:98:52:94:d6:d5:0c:c4:6c:87:a6:7f.Areyousureyouwanttocontinueconnecting(yes/no)?yesWarning:Permanentlyadded'10.138.130.171'(ECDSA)tothelistofknownhosts.grid@10.138.130.171'spassword:pwddupjy[oracle@shard1dbs]$mvpwddupjyorapwdupjy

4.使用源数据库的spfile文件来创建目标数据库要使用的spfile文件
在源数据库中执行下面的命令来创建pfile参数文件

SQL>createpfilefromspfile;Filecreated.[root@shard1~]#scporacle@10.138.130.171:/u01/app/oracle/product/12.2.0/db/dbs/initjy1.ora/u01/app/oracle/product/12.2.0/db/dbs/grid@10.138.130.171'spassword:initjy1.ora100%17311.7KB/s00:00[root@shard1~]#[oracle@shard1dbs]$catinitdupjy.ora*.audit_file_dest='/u01/app/oracle/admin/dupjy/adump'*.cluster_database=false*.compatible='12.2.0'*.control_files='/u01/app/oracle/oradata/dupjy/control01.ctl'*.db_block_size=8192*.db_name='dupjy'*.diagnostic_dest='/u01/app/oracle'*.enable_pluggable_database=true*.open_cursors=300*.pga_aggregate_target=1g*.processes=2000*.remote_login_passwordfile='exclusive'*.sga_max_size=2147483648*.sga_target=2147483648db_file_name_convert=('+DATA/JY/DATAFILE/','/u01/app/oracle/oradata/dupjy/','+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/','/u01/app/oracle/oradata/dupjy/','+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/','/u01/app/oracle/oradata/dupjy/','+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/','/u01/app/oracle/oradata/dupjy/')log_file_name_convert=('+DATA/JY/ONLINELOG/','/u01/app/oracle/oradata/dupjy/')[oracle@shard1dbs]$exportORACLE_SID=dupjy[oracle@shard1dbs]$sqlplus/assysdbaSQL*Plus:Release12.2.0.1.0ProductiononThuJan1819:06:002018Copyright(c)1982,2016,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupnomountpfile='/u01/app/oracle/product/12.2.0/db/dbs/initdupjy.ora'ORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize570428704bytesDatabaseBuffers1560281088bytesRedoBuffers7979008bytesSQL>createspfilefrompfile='/u01/app/oracle/product/12.2.0/db/dbs/initdupjy.ora';Filecreated.

5.使用spfile参数文件来启动目标数据库实例(辅助实例dupjy)

SQL>shutdownimmediateORA-01507:databasenotmountedORACLEinstanceshutdown.SQL>startupnomountORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize570428704bytesDatabaseBuffers1560281088bytesRedoBuffers7979008bytesSQL>showparameterspfileNAMETYPEVALUE---------------------------------------------------------------------------------------------------------------spfilestring/u01/app/oracle/product/12.2.0/db/dbs/spfiledupjy.ora

6.给目标数据库配置静态监听

[oracle@shard1admin]$vilistener.ora#listener.oraNetworkConfigurationFile:/u01/app/oracle/product/12.2.0/db/network/admin/listener.ora#GeneratedbyOracleconfigurationtools.LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shard1)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=dupjy)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db)(GLOBAL_DBNAME=dupjy)))[oracle@shard1admin]$lsnrctlstartLSNRCTLforLinux:Version12.2.0.1.0-Productionon18-JAN-201820:30:34Copyright(c)1991,2016,Oracle.Allrightsreserved.Starting/u01/app/oracle/product/12.2.0/db/bin/tnslsnr:pleasewait...TNSLSNRforLinux:Version12.2.0.1.0-ProductionSystemparameterfileis/u01/app/oracle/product/12.2.0/db/network/admin/listener.oraLogmessageswrittento/u01/app/oracle/diag/tnslsnr/shard1/listener/alert/log.xmlListeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shard1)(PORT=1521)))Listeningon:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=shard1)(PORT=1521)))STATUSoftheLISTENER------------------------AliasLISTENERVersionTNSLSNRforLinux:Version12.2.0.1.0-ProductionStartDate18-JAN-201820:30:34Uptime0days0hr.0min.0secTraceLeveloffSecurityON:LocalOSAuthenticationSNMPOFFListenerParameterFile/u01/app/oracle/product/12.2.0/db/network/admin/listener.oraListenerLogFile/u01/app/oracle/diag/tnslsnr/shard1/listener/alert/log.xmlListeningEndpointsSummary...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=shard1)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))ServicesSummary...Service"dupjy"has1instance(s).Instance"dupjy",statusUNKNOWN,has1handler(s)forthisservice...Thecommandcompletedsuccessfully

7.在目标主机上配置tns，用来通过网络服务名来连接源数据库与目标数据库

[oracle@shard1admin]$vitnsnames.ora#tnsnames.oraNetworkConfigurationFile:/u01/app/oracle/product/12.2.0/db/network/admin/tnsnames.ora#GeneratedbyOracleconfigurationtools.JY=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.130.171)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=jy)))DUPJY=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.130.180)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dupjy)))

8.在目标主机上测试是否可以通过使用网络服务名来连接源数据库与目标数据库

[oracle@shard1admin]$sqlplus/nologSQL*Plus:Release12.2.0.1.0ProductiononThuJan1821:02:532018Copyright(c)1982,2016,Oracle.Allrightsreserved.SQL>conn/assysdbaConnected.SQL>startupnomountORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize570428704bytesDatabaseBuffers1560281088bytesRedoBuffers7979008bytesSQL>exitDisconnectedfromOracleDatabase12cEnterpriseEditionRelease12.2.0.1.0-64bitProduction[oracle@shard1admin]$sqlplus/nologSQL*Plus:Release12.2.0.1.0ProductiononThuJan1821:04:512018Copyright(c)1982,2016,Oracle.Allrightsreserved.SQL>connsys/abcd@dupjyassysdbaConnected.SQL>connsys/abcd@jyassysdbaConnected.

9.在源主机上配置目标数据库的tns名

[oracle@jytest1admin]$vitnsnames.ora#tnsnames.oraNetworkConfigurationFile:/u01/app/oracle/product/12.2.0/db/network/admin/tnsnames.ora#GeneratedbyOracleconfigurationtools.JY=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=jytest-scan)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=jy)))DUPJY=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.130.180)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dupjy)(UR=A)))

10.在源主机上测试能否可以使用网络服务名来连接源数据库与目标数据库

[oracle@jytest1admin]$sqlplus/nologSQL*Plus:Release12.2.0.1.0ProductiononFriJan1903:16:592018Copyright(c)1982,2016,Oracle.Allrightsreserved.SQL>connsys/abcd@jyassysdbaConnected.SQL>connsys/abcd@dupjyassysdbaConnected.

11.执行PDB数据库复制

[oracle@jytest1~]$rmantargetsys/abcd@jycatalogrco/abcd@jypdb_173auxiliarysys/abcd@dupjyRecoveryManager:Release12.2.0.1.0-ProductiononTueJan2317:47:092018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723)connectedtorecoverycatalogdatabaseconnectedtoauxiliarydatabase:DUPJY(notmounted)RMAN>duplicatedatabasetodupjypluggabledatabasejypdbfromactivedatabasenofilenamecheckusingcompressedbackupset;StartingDuplicateDbat23-JAN-18allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=2269devicetype=DISKcurrentlogarchivedcontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''JY''comment=''ModifiedbyRMANduplicate''scope=spfile";sqlclone"altersystemsetdb_unique_name=''DUPJY''comment=''ModifiedbyRMANduplicate''scope=spfile";shutdowncloneimmediate;startupcloneforcenomountrestoreclonefromservice'jy'usingcompressedbackupsetprimarycontrolfile;alterclonedatabasemount;}executingMemoryScriptsqlstatement:altersystemsetdb_name=''JY''comment=''ModifiedbyRMANduplicate''scope=spfilesqlstatement:altersystemsetdb_unique_name=''DUPJY''comment=''ModifiedbyRMANduplicate''scope=spfileOracleinstanceshutdownOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1056967968bytesDatabaseBuffers1073741824bytesRedoBuffers7979008bytesStartingrestoreat23-JAN-18allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=2269devicetype=DISKchannelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringcontrolfilechannelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:06outputfilename=/u01/app/oracle/oradata/dupjy/control01.ctlFinishedrestoreat23-JAN-18databasemountedSkippingpluggabledatabaseTESTPDBAutomaticallyaddingtablespaceSYSTEMAutomaticallyaddingtablespaceSYSAUXAutomaticallyaddingtablespacePDB$SEED:SYSTEMAutomaticallyaddingtablespacePDB$SEED:SYSAUXAutomaticallyaddingtablespaceTESTPDB:SYSTEMAutomaticallyaddingtablespaceTESTPDB:UNDOTBS1AutomaticallyaddingtablespaceUNDOTBS1AutomaticallyaddingtablespaceTESTPDB:UNDO_2AutomaticallyaddingtablespaceUNDOTBS2SkippingtablespaceUSERSRMAN-05529:warning:DB_FILE_NAME_CONVERTresultedininvalidASMnames;nameschangedtodiskgrouponly.contentsofMemoryScript:{sqlclone'alterdatabaseflashbackoff';setnewnamefordatafile1to"/u01/app/oracle/oradata/dupjy/system.317.962209603";setnewnamefordatafile3to"/u01/app/oracle/oradata/dupjy/sysaux.298.962209605";setnewnamefordatafile4to"/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605";setnewnamefordatafile5to"/u01/app/oracle/oradata/dupjy/system.256.962209675";setnewnamefordatafile6to"/u01/app/oracle/oradata/dupjy/sysaux.270.962209675";setnewnamefordatafile8to"/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675";setnewnamefordatafile9to"/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605";setnewnamefordatafile10to"/u01/app/oracle/oradata/dupjy/system.271.962209649";setnewnamefordatafile11to"/u01/app/oracle/oradata/dupjy/sysaux.316.962209649";setnewnamefordatafile12to"/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649";setnewnamefordatafile13to"/u01/app/oracle/oradata/dupjy/undo_2.268.962209649";setnewnamefordatafile14to"/u01/app/oracle/oradata/dupjy/users.278.962209649";setnewnamefordatafile15to"/u01/app/oracle/oradata/dupjy/test.275.962210609";restorefromnonsparsefromservice'jy'usingcompressedbackupsetclonedatabaseskipforevertablespace"USERS","TESTPDB":"USERS","TESTPDB":"UNDO_2","TESTPDB":"UNDOTBS1","TESTPDB":"TEST","TESTPDB":"SYSTEM","TESTPDB":"SYSAUX";sql'altersystemarchivelogcurrent';}executingMemoryScriptsqlstatement:alterdatabaseflashbackoffexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEStartingrestoreat23-JAN-18usingchannelORA_AUX_DISK_1channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00001to/u01/app/oracle/oradata/dupjy/system.317.962209603channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:45channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00003to/u01/app/oracle/oradata/dupjy/sysaux.298.962209605channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:01:36channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00004to/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:15channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00005to/u01/app/oracle/oradata/dupjy/system.256.962209675channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:15channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00006to/u01/app/oracle/oradata/dupjy/sysaux.270.962209675channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:36channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00008to/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:03channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00009to/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:26channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00010to/u01/app/oracle/oradata/dupjy/system.271.962209649channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:15channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00011to/u01/app/oracle/oradata/dupjy/sysaux.316.962209649channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:46channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00012to/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:08channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00013to/u01/app/oracle/oradata/dupjy/undo_2.268.962209649channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:08channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00014to/u01/app/oracle/oradata/dupjy/users.278.962209649channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:01:05channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00015to/u01/app/oracle/oradata/dupjy/test.275.962210609channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:04Finishedrestoreat23-JAN-18sqlstatement:altersystemarchivelogcurrentcurrentlogarchivedcontentsofMemoryScript:{restorecloneforcefromservice'jy'usingcompressedbackupsetarchivelogfromscn15660582;switchclonedatafileall;}executingMemoryScriptStartingrestoreat23-JAN-18usingchannelORA_AUX_DISK_1channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=163channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=164channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=165channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=144channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=145channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02Finishedrestoreat23-JAN-18datafile1switchedtodatafilecopyinputdatafilecopyRECID=17STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/system.317.962209603datafile3switchedtodatafilecopyinputdatafilecopyRECID=18STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605datafile4switchedtodatafilecopyinputdatafilecopyRECID=19STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605datafile5switchedtodatafilecopyinputdatafilecopyRECID=20STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/system.256.962209675datafile6switchedtodatafilecopyinputdatafilecopyRECID=21STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675datafile8switchedtodatafilecopyinputdatafilecopyRECID=22STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675datafile9switchedtodatafilecopyinputdatafilecopyRECID=23STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605datafile10switchedtodatafilecopyinputdatafilecopyRECID=24STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/system.271.962209649datafile11switchedtodatafilecopyinputdatafilecopyRECID=25STAMP=966167434filename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649datafile12switchedtodatafilecopyinputdatafilecopyRECID=26STAMP=966167435filename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649datafile13switchedtodatafilecopyinputdatafilecopyRECID=27STAMP=966167435filename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649datafile14switchedtodatafilecopyinputdatafilecopyRECID=28STAMP=966167435filename=/u01/app/oracle/oradata/dupjy/users.278.962209649datafile15switchedtodatafilecopyinputdatafilecopyRECID=29STAMP=966167435filename=/u01/app/oracle/oradata/dupjy/test.275.962210609contentsofMemoryScript:{setuntilscn15661286;recoverclonedatabaseskipforevertablespace"USERS","TESTPDB":"USERS","TESTPDB":"UNDO_2","TESTPDB":"UNDOTBS1","TESTPDB":"TEST","TESTPDB":"SYSTEM","TESTPDB":"SYSAUX"deletearchivelog;}executingMemoryScriptexecutingcommand:SETuntilclauseStartingrecoverat23-JAN-18usingchannelORA_AUX_DISK_1Executing:alterdatabasedatafile7offlinedropExecuting:alterdatabasedatafile20offlinedropExecuting:alterdatabasedatafile19offlinedropExecuting:alterdatabasedatafile18offlinedropExecuting:alterdatabasedatafile21offlinedropExecuting:alterdatabasedatafile16offlinedropExecuting:alterdatabasedatafile17offlinedropstartingmediarecoveryarchivedlogforthread1withsequence164isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/1_164_961976319.dbfarchivedlogforthread1withsequence165isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/1_165_961976319.dbfarchivedlogforthread2withsequence144isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/2_144_961976319.dbfarchivedlogforthread2withsequence145isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/2_145_961976319.dbfarchivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/1_164_961976319.dbfthread=1sequence=164archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/2_144_961976319.dbfthread=2sequence=144archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/1_165_961976319.dbfthread=1sequence=165archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/2_145_961976319.dbfthread=2sequence=145mediarecoverycomplete,elapsedtime:00:00:02Finishedrecoverat23-JAN-18OracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1056967968bytesDatabaseBuffers1073741824bytesRedoBuffers7979008bytescontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''DUPJY''comment=''ResettooriginalvaluebyRMAN''scope=spfile";sqlclone"altersystemresetdb_unique_namescope=spfile";}executingMemoryScriptsqlstatement:altersystemsetdb_name=''DUPJY''comment=''ResettooriginalvaluebyRMAN''scope=spfilesqlstatement:altersystemresetdb_unique_namescope=spfileOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1056967968bytesDatabaseBuffers1073741824bytesRedoBuffers7979008bytessqlstatement:CREATECONTROLFILEREUSESETDATABASE"DUPJY"RESETLOGSARCHIVELOGMAXLOGFILES192MAXLOGMEMBERS3MAXDATAFILES1024MAXINSTANCES32MAXLOGHISTORY292LOGFILEGROUP1('/u01/app/oracle/oradata/dupjy/group_1.261.961976319')SIZE200MREUSE,GROUP2('/u01/app/oracle/oradata/dupjy/group_2.302.961976321')SIZE200MREUSEDATAFILE'/u01/app/oracle/oradata/dupjy/system.317.962209603','/u01/app/oracle/oradata/dupjy/system.256.962209675','/u01/app/oracle/oradata/dupjy/system.271.962209649'CHARACTERSETZHS16GBKsqlstatement:ALTERDATABASEADDLOGFILEINSTANCE'i2'GROUP3('/u01/app/oracle/oradata/dupjy/group_3.263.961976697')SIZE200MREUSE,GROUP4('/u01/app/oracle/oradata/dupjy/group_4.262.961976705')SIZE200MREUSEcontentsofMemoryScript:{setnewnamefortempfile1to"+DATA";setnewnamefortempfile2to"+DATA";setnewnamefortempfile3to"+DATA";switchclonetempfileall;catalogclonedatafilecopy"/u01/app/oracle/oradata/dupjy/sysaux.298.962209605","/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605","/u01/app/oracle/oradata/dupjy/sysaux.270.962209675","/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675","/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605","/u01/app/oracle/oradata/dupjy/sysaux.316.962209649","/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649","/u01/app/oracle/oradata/dupjy/undo_2.268.962209649","/u01/app/oracle/oradata/dupjy/users.278.962209649","/u01/app/oracle/oradata/dupjy/test.275.962210609";switchclonedatafileall;}executingMemoryScriptexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMErenamedtempfile1to+DATAincontrolfilerenamedtempfile2to+DATAincontrolfilerenamedtempfile3to+DATAincontrolfilecatalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605RECID=1STAMP=966167470catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605RECID=2STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675RECID=3STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675RECID=4STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605RECID=5STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649RECID=6STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649RECID=7STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649RECID=8STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/users.278.962209649RECID=9STAMP=966167471catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/test.275.962210609RECID=10STAMP=966167471datafile3switchedtodatafilecopyinputdatafilecopyRECID=1STAMP=966167470filename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605datafile4switchedtodatafilecopyinputdatafilecopyRECID=2STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605datafile6switchedtodatafilecopyinputdatafilecopyRECID=3STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675datafile8switchedtodatafilecopyinputdatafilecopyRECID=4STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675datafile9switchedtodatafilecopyinputdatafilecopyRECID=5STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605datafile11switchedtodatafilecopyinputdatafilecopyRECID=6STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649datafile12switchedtodatafilecopyinputdatafilecopyRECID=7STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649datafile13switchedtodatafilecopyinputdatafilecopyRECID=8STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649datafile14switchedtodatafilecopyinputdatafilecopyRECID=9STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/users.278.962209649datafile15switchedtodatafilecopyinputdatafilecopyRECID=10STAMP=966167471filename=/u01/app/oracle/oradata/dupjy/test.275.962210609contentsofMemoryScript:{Alterclonedatabaseopenresetlogs;}executingMemoryScriptdatabaseopenedExecuting:droppluggabledatabase"TESTPDB"includingdatafilescontentsofMemoryScript:{sqlclone"alterpluggabledatabaseallopen";}executingMemoryScriptsqlstatement:alterpluggabledatabaseallopenDroppingofflineandskippedtablespacesExecuting:alterdatabasedefaulttablespacesystemExecuting:droptablespace"USERS"includingcontentscascadeconstraintsFinishedDuplicateDbat23-JAN-18

12.检查源数据库中的PDB(jypdb)是否被成功复制到目标数据库dupjy中

SQL>selectname,open_modefromv$pdbs;NAMEOPEN_MODE------------------------------------------------------------------------------------------------------------------------------------------PDB$SEEDREADONLYJYPDBREADWRITE

到此，相信大家对“如何使用RMAN对CDB中的PDB进行复制”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！