这篇文章主要介绍“如何使用RMAN对CDB中的部分表空间进行复制”，在日常操作中，相信很多人在如何使用RMAN对CDB中的部分表空间进行复制问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”如何使用RMAN对CDB中的部分表空间进行复制”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

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.查询整个CDB中的表空间名称,在复制整个CDB数据库时跳过JYPDB:TEST表空间

[oracle@jytest1~]$rmantargetsys/xxzx7817600@jycatalogrco/xxzx7817600@jypdb_173RecoveryManager:Release12.2.0.1.0-ProductiononSatJan2000:47:192018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723)connectedtorecoverycatalogdatabaseRMAN>reportschema;Reportofdatabaseschemafordatabasewithdb_unique_nameJYListofPermanentDatafiles===========================FileSize(MB)TablespaceRBsegsDatafileName---------------------------------------------------------------1840SYSTEMYES+DATA/JY/DATAFILE/system.317.96220960332210SYSAUXNO+DATA/JY/DATAFILE/sysaux.298.9622096054570UNDOTBS1YES+DATA/JY/DATAFILE/undotbs1.277.9622096055250PDB$SEED:SYSTEMNO+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.9622096756340PDB$SEED:SYSAUXNO+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.96220967575USERSNO+DATA/JY/DATAFILE/users.301.9622096058100PDB$SEED:UNDOTBS1NO+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.9622096759150UNDOTBS2YES+DATA/JY/DATAFILE/undotbs2.312.96220960510270JYPDB:SYSTEMYES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.96220964911590JYPDB:SYSAUXNO+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.96220964912100JYPDB:UNDOTBS1YES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.96220964913100JYPDB:UNDO_2YES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649141267JYPDB:USERSNO+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.96220964915100JYPDB:TESTNO+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.96221060916260TESTPDB:SYSTEMYES+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.96246940917550TESTPDB:SYSAUXNO+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.96246940918100TESTPDB:UNDOTBS1YES+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.96246940919100TESTPDB:UNDO_2YES+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409205TESTPDB:USERSNO+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.96246940921100TESTPDB:TESTNO+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409ListofTemporaryFiles=======================FileSize(MB)TablespaceMaxsize(MB)TempfileName---------------------------------------------------------------1144TEMP32767+DATA/JY/TEMPFILE/temp.299.961976339264PDB$SEED:TEMP32767+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/TEMPFILE/temp.297.9622098653137JYPDB:TEMP32767+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/TEMPFILE/temp.276.9622105194135TESTPDB:TEMP32767+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/TEMPFILE/temp.258.962469435

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

4.将源数据库的密码文件复制到目标主机的相应目录中并修改为目标数据库(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

5.使用源数据库的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=2147483648*.log_archive_dest_1='location=/u01/app/oracle/oradata/arch_dupjy'db_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.

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

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

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

[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

8.在目标主机上配置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)))

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

[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.

10.在源主机上配置目标数据库的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)))

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

[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.

12.执行数据库复制(跳过源CDB中的JYPDB:TEST表空间)

[oracle@jytest1~]$rmantargetsys/abcd@jycatalogrco/abcd@jypdb_173auxiliarysys/abcd@dupjyRecoveryManager:Release12.2.0.1.0-ProductiononSatJan2001:14:062018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723)connectedtorecoverycatalogdatabaseconnectedtoauxiliarydatabase:DUPJY(notmounted)RMAN>duplicatetargetdatabasetodupjySKIPTABLESPACEJYPDB:'TEST'fromactivedatabasenofilenamecheckusingcompressedbackupset;StartingDuplicateDbat20-JAN-18allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=10devicetype=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=spfileOracleinstanceshutdownOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize788532512bytesDatabaseBuffers1342177280bytesRedoBuffers7979008bytesStartingrestoreat20-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.ctlFinishedrestoreat20-JAN-18databasemountedCheckingthatduplicatedtablespacesareself-containedDatafile15skippedbyrequestRMAN-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";setnewnamefordatafile7to"/u01/app/oracle/oradata/dupjy/users.301.962209605";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";setnewnamefordatafile16to"/u01/app/oracle/oradata/dupjy/system.260.962469409";setnewnamefordatafile17to"/u01/app/oracle/oradata/dupjy/sysaux.259.962469409";setnewnamefordatafile18to"/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409";setnewnamefordatafile19to"/u01/app/oracle/oradata/dupjy/undo_2.266.962469409";setnewnamefordatafile20to"/u01/app/oracle/oradata/dupjy/users.267.962469409";setnewnamefordatafile21to"/u01/app/oracle/oradata/dupjy/test.269.962469409";restorefromnonsparsefromservice'jy'usingcompressedbackupsetclonedatabaseskipforevertablespace"JYPDB":"TEST";sql'altersystemarchivelogcurrent';}executingMemoryScriptsqlstatement:alterdatabaseflashbackoffexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEStartingrestoreat20-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:07channelORA_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:16channelORA_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:restoringdatafile00007to/u01/app/oracle/oradata/dupjy/users.301.962209605channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_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:04channelORA_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:03channelORA_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:16channelORA_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:45channelORA_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:04channelORA_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:03channelORA_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:00:26channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00016to/u01/app/oracle/oradata/dupjy/system.260.962469409channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:16channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00017to/u01/app/oracle/oradata/dupjy/sysaux.259.962469409channelORA_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:restoringdatafile00018to/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:04channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00019to/u01/app/oracle/oradata/dupjy/undo_2.266.962469409channelORA_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:restoringdatafile00020to/u01/app/oracle/oradata/dupjy/users.267.962469409channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00021to/u01/app/oracle/oradata/dupjy/test.269.962469409channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:03Finishedrestoreat20-JAN-18sqlstatement:altersystemarchivelogcurrentcurrentlogarchivedcontentsofMemoryScript:{restorecloneforcefromservice'jy'usingcompressedbackupsetarchivelogfromscn13195279;switchclonedatafileall;}executingMemoryScriptStartingrestoreat20-JAN-18usingchannelORA_AUX_DISK_1channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=146channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=147channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=121channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=122channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=123channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01Finishedrestoreat20-JAN-18datafile1switchedtodatafilecopyinputdatafilecopyRECID=23STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/system.317.962209603datafile3switchedtodatafilecopyinputdatafilecopyRECID=24STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605datafile4switchedtodatafilecopyinputdatafilecopyRECID=25STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605datafile5switchedtodatafilecopyinputdatafilecopyRECID=26STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/system.256.962209675datafile6switchedtodatafilecopyinputdatafilecopyRECID=27STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675datafile7switchedtodatafilecopyinputdatafilecopyRECID=28STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/users.301.962209605datafile8switchedtodatafilecopyinputdatafilecopyRECID=29STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675datafile9switchedtodatafilecopyinputdatafilecopyRECID=30STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605datafile10switchedtodatafilecopyinputdatafilecopyRECID=31STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/system.271.962209649datafile11switchedtodatafilecopyinputdatafilecopyRECID=32STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649datafile12switchedtodatafilecopyinputdatafilecopyRECID=33STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649datafile13switchedtodatafilecopyinputdatafilecopyRECID=34STAMP=965848768filename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649datafile14switchedtodatafilecopyinputdatafilecopyRECID=35STAMP=965848769filename=/u01/app/oracle/oradata/dupjy/users.278.962209649datafile16switchedtodatafilecopyinputdatafilecopyRECID=36STAMP=965848769filename=/u01/app/oracle/oradata/dupjy/system.260.962469409datafile17switchedtodatafilecopyinputdatafilecopyRECID=37STAMP=965848769filename=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409datafile18switchedtodatafilecopyinputdatafilecopyRECID=38STAMP=965848769filename=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409datafile19switchedtodatafilecopyinputdatafilecopyRECID=39STAMP=965848769filename=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409datafile20switchedtodatafilecopyinputdatafilecopyRECID=40STAMP=965848769filename=/u01/app/oracle/oradata/dupjy/users.267.962469409datafile21switchedtodatafilecopyinputdatafilecopyRECID=41STAMP=965848769filename=/u01/app/oracle/oradata/dupjy/test.269.962469409contentsofMemoryScript:{setuntilscn13197051;recoverclonedatabaseskipforevertablespace"JYPDB":"TEST"deletearchivelog;}executingMemoryScriptexecutingcommand:SETuntilclauseStartingrecoverat20-JAN-18usingchannelORA_AUX_DISK_1Executing:alterdatabasedatafile15offlinedropstartingmediarecoveryarchivedlogforthread1withsequence146isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/1_146_961976319.dbfarchivedlogforthread1withsequence147isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/1_147_961976319.dbfarchivedlogforthread2withsequence122isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/2_122_961976319.dbfarchivedlogforthread2withsequence123isalreadyondiskasfile/u01/app/oracle/oradata/arch_dupjy/2_123_961976319.dbfarchivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/1_146_961976319.dbfthread=1sequence=146archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/2_122_961976319.dbfthread=2sequence=122archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/2_123_961976319.dbfthread=2sequence=123archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/1_147_961976319.dbfthread=1sequence=147mediarecoverycomplete,elapsedtime:00:00:04Finishedrecoverat20-JAN-18OracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize788532512bytesDatabaseBuffers1342177280bytesRedoBuffers7979008bytescontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''DUPJY''comment=''ResettooriginalvaluebyRMAN''scope=spfile";sqlclone"altersystemresetdb_unique_namescope=spfile";}executingMemoryScriptsqlstatement:altersystemsetdb_name=''DUPJY''comment=''ResettooriginalvaluebyRMAN''scope=spfilesqlstatement:altersystemresetdb_unique_namescope=spfileOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize788532512bytesDatabaseBuffers1342177280bytesRedoBuffers7979008bytessqlstatement: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','/u01/app/oracle/oradata/dupjy/system.260.962469409'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";setnewnamefortempfile4to"+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/users.301.962209605","/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/sysaux.259.962469409","/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409","/u01/app/oracle/oradata/dupjy/undo_2.266.962469409","/u01/app/oracle/oradata/dupjy/users.267.962469409","/u01/app/oracle/oradata/dupjy/test.269.962469409";switchclonedatafileall;}executingMemoryScriptexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMErenamedtempfile1to+DATAincontrolfilerenamedtempfile2to+DATAincontrolfilerenamedtempfile3to+DATAincontrolfilerenamedtempfile4to+DATAincontrolfilecatalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605RECID=1STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605RECID=2STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675RECID=3STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/users.301.962209605RECID=4STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675RECID=5STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605RECID=6STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649RECID=7STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649RECID=8STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649RECID=9STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/users.278.962209649RECID=10STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409RECID=11STAMP=965848805catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409RECID=12STAMP=965848806catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409RECID=13STAMP=965848806catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/users.267.962469409RECID=14STAMP=965848806catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/test.269.962469409RECID=15STAMP=965848806datafile3switchedtodatafilecopyinputdatafilecopyRECID=1STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605datafile4switchedtodatafilecopyinputdatafilecopyRECID=2STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605datafile6switchedtodatafilecopyinputdatafilecopyRECID=3STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675datafile7switchedtodatafilecopyinputdatafilecopyRECID=4STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/users.301.962209605datafile8switchedtodatafilecopyinputdatafilecopyRECID=5STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675datafile9switchedtodatafilecopyinputdatafilecopyRECID=6STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605datafile11switchedtodatafilecopyinputdatafilecopyRECID=7STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649datafile12switchedtodatafilecopyinputdatafilecopyRECID=8STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649datafile13switchedtodatafilecopyinputdatafilecopyRECID=9STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649datafile14switchedtodatafilecopyinputdatafilecopyRECID=10STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/users.278.962209649datafile17switchedtodatafilecopyinputdatafilecopyRECID=11STAMP=965848805filename=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409datafile18switchedtodatafilecopyinputdatafilecopyRECID=12STAMP=965848806filename=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409datafile19switchedtodatafilecopyinputdatafilecopyRECID=13STAMP=965848806filename=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409datafile20switchedtodatafilecopyinputdatafilecopyRECID=14STAMP=965848806filename=/u01/app/oracle/oradata/dupjy/users.267.962469409datafile21switchedtodatafilecopyinputdatafilecopyRECID=15STAMP=965848806filename=/u01/app/oracle/oradata/dupjy/test.269.962469409contentsofMemoryScript:{Alterclonedatabaseopenresetlogs;}executingMemoryScriptdatabaseopenedcontentsofMemoryScript:{sqlclone"alterpluggabledatabaseallopen";}executingMemoryScriptsqlstatement:alterpluggabledatabaseallopenDroppingofflineandskippedtablespacesExecuting:droptablespace"TEST"includingcontentscascadeconstraintsFinishedDuplicateDbat20-JAN-18

12.检查目标数据库中是否不存在表空间jypdb:test

[oracle@shard1arch_dupjy]$exportORACLE_SID=dupjy[oracle@shard1arch_dupjy]$rmantarget/RecoveryManager:Release12.2.0.1.0-ProductiononFriJan1919:21:012018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:DUPJY(DBID=1349214878)RMAN>reportschema;usingtargetdatabasecontrolfileinsteadofrecoverycatalogReportofdatabaseschemafordatabasewithdb_unique_nameDUPJYListofPermanentDatafiles===========================FileSize(MB)TablespaceRBsegsDatafileName---------------------------------------------------------------1840SYSTEMYES/u01/app/oracle/oradata/dupjy/system.317.96220960332210SYSAUXNO/u01/app/oracle/oradata/dupjy/sysaux.298.9622096054570UNDOTBS1YES/u01/app/oracle/oradata/dupjy/undotbs1.277.9622096055250PDB$SEED:SYSTEMNO/u01/app/oracle/oradata/dupjy/system.256.9622096756340PDB$SEED:SYSAUXNO/u01/app/oracle/oradata/dupjy/sysaux.270.96220967575USERSNO/u01/app/oracle/oradata/dupjy/users.301.9622096058100PDB$SEED:UNDOTBS1NO/u01/app/oracle/oradata/dupjy/undotbs1.296.9622096759150UNDOTBS2YES/u01/app/oracle/oradata/dupjy/undotbs2.312.96220960510270JYPDB:SYSTEMYES/u01/app/oracle/oradata/dupjy/system.271.96220964911590JYPDB:SYSAUXNO/u01/app/oracle/oradata/dupjy/sysaux.316.96220964912100JYPDB:UNDOTBS1YES/u01/app/oracle/oradata/dupjy/undotbs1.264.96220964913100JYPDB:UNDO_2YES/u01/app/oracle/oradata/dupjy/undo_2.268.962209649141267JYPDB:USERSNO/u01/app/oracle/oradata/dupjy/users.278.96220964916260TESTPDB:SYSTEMYES/u01/app/oracle/oradata/dupjy/system.260.96246940917550TESTPDB:SYSAUXNO/u01/app/oracle/oradata/dupjy/sysaux.259.96246940918100TESTPDB:UNDOTBS1YES/u01/app/oracle/oradata/dupjy/undotbs1.265.96246940919100TESTPDB:UNDO_2YES/u01/app/oracle/oradata/dupjy/undo_2.266.962469409205TESTPDB:USERSNO/u01/app/oracle/oradata/dupjy/users.267.96246940921100TESTPDB:TESTNO/u01/app/oracle/oradata/dupjy/test.269.962469409ListofTemporaryFiles=======================FileSize(MB)TablespaceMaxsize(MB)TempfileName---------------------------------------------------------------1144TEMP32767+DATA264PDB$SEED:TEMP32767+DATA3137JYPDB:TEMP32767+DATA4135TESTPDB:TEMP32767+DATA

到此，关于“如何使用RMAN对CDB中的部分表空间进行复制”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！