这篇文章主要介绍“怎么将源RAC CDB数据库复制成为单实例CDB数据库”，在日常操作中，相信很多人在怎么将源RAC CDB数据库复制成为单实例CDB数据库问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”怎么将源RAC CDB数据库复制成为单实例CDB数据库”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

不连接目标数据库和恢复目录使用备份来将RAC CDB复制成单实例CDB数据库操作如下
1.检查源RAC CDB(jy)的参数文件，数据文件，联机日志文件，控制文件，归档日志文件的存储目录

SQL>showparameterspfileNAMETYPEVALUE-------------------------------------------------------------------------------------------spfilestring+DATA/JY/PARAMETERFILE/spfile.303.961976713RMAN>reportschema;Reportofdatabaseschemafordatabasewithdb_unique_nameJYListofPermanentDatafiles===========================FileSize(MB)TablespaceRBsegsDatafileName---------------------------------------------------------------1840SYSTEMYES+DATA/JY/DATAFILE/system.317.96220960332340SYSAUXNO+DATA/JY/DATAFILE/sysaux.298.96220960541015UNDOTBS1YES+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.96220967591350UNDOTBS2YES+DATA/JY/DATAFILE/undotbs2.312.96220960510270JYPDB:SYSTEMYES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.96220964911590JYPDB:SYSAUXNO+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.96220964912205JYPDB:UNDOTBS1YES+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.96220964913310JYPDB: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.96246940918245TESTPDB: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.962469435SQL>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.对源RAC CDB数据库创建RMAN备份，这里将远程主机的目录/ora_backup通过nfs挂载到源主机的/ora_backup目录这样可以避免对备份文件进行复制操作

[oracle@jytest1~]$rmantarget/catalogrco/abcd@jypdb_173RecoveryManager:Release12.2.0.1.0-ProductiononWedJan2419:47:122018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723)connectedtorecoverycatalogdatabaseRMAN>run2>{3>backupascompressedbackupsetdatabaseformat'/ora_backup/jy_%u_%d_%t_%s_%p'plusarchivelogformat'/ora_backup/arch_%d_%T_%U';4>backupcurrentcontrolfileformat'/ora_backup/%d_%s.ctl';5>backupspfileformat'/ora_backup/spf%d_%s.ora';6>}Startingbackupat24-JAN-18currentlogarchivedallocatedchannel:ORA_DISK_1channelORA_DISK_1:SID=385instance=jy1devicetype=DISKchannelORA_DISK_1:startingcompressedarchivedlogbackupsetchannelORA_DISK_1:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=2sequence=141RECID=320STAMP=966188816inputarchivedlogthread=1sequence=161RECID=321STAMP=966188818inputarchivedlogthread=2sequence=142RECID=323STAMP=966188832inputarchivedlogthread=1sequence=162RECID=322STAMP=966188829inputarchivedlogthread=1sequence=163RECID=325STAMP=966188842inputarchivedlogthread=2sequence=143RECID=324STAMP=966188842inputarchivedlogthread=2sequence=144RECID=327STAMP=966189268inputarchivedlogthread=1sequence=164RECID=326STAMP=966189266inputarchivedlogthread=1sequence=165RECID=328STAMP=966189274inputarchivedlogthread=2sequence=145RECID=329STAMP=966189274inputarchivedlogthread=1sequence=166RECID=330STAMP=966192976inputarchivedlogthread=2sequence=146RECID=331STAMP=966192977inputarchivedlogthread=1sequence=167RECID=333STAMP=966193374inputarchivedlogthread=2sequence=147RECID=332STAMP=966193373inputarchivedlogthread=2sequence=148RECID=334STAMP=966193380inputarchivedlogthread=1sequence=168RECID=335STAMP=966193380inputarchivedlogthread=1sequence=169RECID=336STAMP=966207796inputarchivedlogthread=2sequence=149RECID=338STAMP=966208644inputarchivedlogthread=1sequence=170RECID=337STAMP=966208634inputarchivedlogthread=1sequence=171RECID=339STAMP=966208856inputarchivedlogthread=2sequence=150RECID=340STAMP=966208857inputarchivedlogthread=1sequence=172RECID=341STAMP=966209350inputarchivedlogthread=2sequence=151RECID=342STAMP=966209350inputarchivedlogthread=1sequence=173RECID=344STAMP=966209356inputarchivedlogthread=2sequence=152RECID=343STAMP=966209356inputarchivedlogthread=2sequence=153RECID=346STAMP=966246980inputarchivedlogthread=1sequence=174RECID=345STAMP=966246243inputarchivedlogthread=1sequence=175RECID=347STAMP=966271688inputarchivedlogthread=2sequence=154RECID=349STAMP=966282445inputarchivedlogthread=1sequence=176RECID=348STAMP=966282440channelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/arch_JY_20180124_78spgj6g_1_1tag=TAG20180124T194727comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:01:45Finishedbackupat24-JAN-18Startingbackupat24-JAN-18usingchannelORA_DISK_1channelORA_DISK_1:startingcompressedfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00003name=+DATA/JY/DATAFILE/sysaux.298.962209605inputdatafilefilenumber=00009name=+DATA/JY/DATAFILE/undotbs2.312.962209605inputdatafilefilenumber=00004name=+DATA/JY/DATAFILE/undotbs1.277.962209605inputdatafilefilenumber=00001name=+DATA/JY/DATAFILE/system.317.962209603inputdatafilefilenumber=00007name=+DATA/JY/DATAFILE/users.301.962209605channelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/jy_79spgj9s_JY_966282556_233_1tag=TAG20180124T194913comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:02:55channelORA_DISK_1:startingcompressedfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00014name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.278.962209649inputdatafilefilenumber=00011name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.316.962209649inputdatafilefilenumber=00013name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.268.962209649inputdatafilefilenumber=00010name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.271.962209649inputdatafilefilenumber=00012name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.264.962209649inputdatafilefilenumber=00015name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.275.962210609channelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/jy_7aspgjfb_JY_966282731_234_1tag=TAG20180124T194913comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:01:15channelORA_DISK_1:startingcompressedfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00017name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.259.962469409inputdatafilefilenumber=00016name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.260.962469409inputdatafilefilenumber=00018name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.265.962469409inputdatafilefilenumber=00019name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.266.962469409inputdatafilefilenumber=00021name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.269.962469409inputdatafilefilenumber=00020name=+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.267.962469409channelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/jy_7bspgjhn_JY_966282807_235_1tag=TAG20180124T194913comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:01:05channelORA_DISK_1:startingcompressedfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00006name=+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.270.962209675inputdatafilefilenumber=00005name=+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.256.962209675inputdatafilefilenumber=00008name=+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.296.962209675channelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/jy_7cspgjjo_JY_966282872_236_1tag=TAG20180124T194913comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:55channelORA_DISK_1:startingcompressedfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetincludingcurrentcontrolfileinbackupsetincludingcurrentSPFILEinbackupsetchannelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/jy_7dspgjlg_JY_966282928_237_1tag=TAG20180124T194913comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01Finishedbackupat24-JAN-18Startingbackupat24-JAN-18currentlogarchivedusingchannelORA_DISK_1channelORA_DISK_1:startingcompressedarchivedlogbackupsetchannelORA_DISK_1:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=1sequence=177RECID=351STAMP=966282933inputarchivedlogthread=2sequence=155RECID=350STAMP=966282933channelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/arch_JY_20180124_7espgjln_1_1tag=TAG20180124T195535comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01Finishedbackupat24-JAN-18Startingbackupat24-JAN-18usingchannelORA_DISK_1channelORA_DISK_1:startingfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetincludingcurrentcontrolfileinbackupsetchannelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/JY_239.ctltag=TAG20180124T195540comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:03Finishedbackupat24-JAN-18Startingbackupat24-JAN-18usingchannelORA_DISK_1channelORA_DISK_1:startingfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetincludingcurrentSPFILEinbackupsetchannelORA_DISK_1:startingpiece1at24-JAN-18channelORA_DISK_1:finishedpiece1at24-JAN-18piecehandle=/ora_backup/spfJY_240.oratag=TAG20180124T195549comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01Finishedbackupat24-JAN-18在目标主机的/ora_backup目录中查看生成的RMAN备份文件[root@shard1ora_backup]#ls-lrttotal1646052-rw-r-----.1oracle1006473020928Jan2413:45arch_JY_20180124_78spgj6g_1_1-rw-r-----.1oracle1006615038976Jan2413:48jy_79spgj9s_JY_966282556_233_1-rw-r-----.1oracle1006213581824Jan2413:49jy_7aspgjfb_JY_966282731_234_1-rw-r-----.1oracle1006190742528Jan2413:50jy_7bspgjhn_JY_966282807_235_1-rw-r-----.1oracle1006171524096Jan2413:51jy_7cspgjjo_JY_966282872_236_1-rw-r-----.1oracle10061163264Jan2413:51jy_7dspgjlg_JY_966282928_237_1-rw-r-----.1oracle1006392192Jan2413:51arch_JY_20180124_7espgjln_1_1-rw-r-----.1oracle100619972096Jan2413:51JY_239.ctl-rw-r-----.1oracle1006114688Jan2413:51spfJY_240.ora

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

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.使用备份来复制RAC CDB为单实例CDB(dupjy),执行duplicate命令，如果没有配置自动通道，那么至少手动分配一个辅助实例。如果是使用PFILE参数文件启动辅助实例需要指定pfile参数文件，且pfile参数文件必须存储在运行RMAN执行复制的主机上。复制命令没有指定数据库名。使用database关键字而不指定数据库名，duplicate将从备份中获得数据库名和DBID。如果在backup location目录中一个数据库有多个备份将会显示错误。使用backup子句来识别没有目标数据库和恢复目录的复制类型。until time选项用来指定恢复目标时间，它是唯一能与backup location子句一起使用的选项。因为副本数据库和原数据库文件的文件名相同所以要指定nofilenamecheck选项:

[oracle@shard1ora_backup]$rmanauxiliarysys/abcd@dupjyRecoveryManager:Release12.2.0.1.0-ProductiononWedJan2417:13:282018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtoauxiliarydatabase:JY(notmounted)RMAN>run2>{3>setnewnamefordatabaseto'/u01/app/oracle/oradata/dupjy/%b';4>duplicatedatabase'JY'to'dupjy'5>logfilegroup1('/u01/app/oracle/oradata/dupjy/group_1.261.961976319')size200Mreuse,6>group2('/u01/app/oracle/oradata/dupjy/group_2.302.961976321')size200Mreuse,7>group3('/u01/app/oracle/oradata/dupjy/group_3.263.961976697')size200Mreuse,8>group4('/u01/app/oracle/oradata/dupjy/group_4.262.961976705')size200Mreuse9>backuplocation'/ora_backup';10>}executingcommand:SETNEWNAMEStartingDuplicateDbat24-JAN-18contentsofMemoryScript:{sqlclone"altersystemsetdb_name=''JY''comment=''ModifiedbyRMANduplicate''scope=spfile";shutdowncloneimmediate;startupcloneforcenomountrestorecloneprimarycontrolfilefrom'/ora_backup/JY_239.ctl';alterclonedatabasemount;}executingMemoryScriptsqlstatement:altersystemsetdb_name=''JY''comment=''ModifiedbyRMANduplicate''scope=spfileOracleinstanceshutdownOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1056967968bytesDatabaseBuffers1073741824bytesRedoBuffers7979008bytesStartingrestoreat24-JAN-18allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=2269devicetype=DISKchannelORA_AUX_DISK_1:restoringcontrolfilechannelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01outputfilename=/u01/app/oracle/oradata/dupjy/control01.ctlFinishedrestoreat24-JAN-18databasemountedreleasedchannel:ORA_AUX_DISK_1allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=2269devicetype=DISKcontentsofMemoryScript:{setuntilscn15999223;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";setnewnamefordatafile15to"/u01/app/oracle/oradata/dupjy/test.275.962210609";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";restoreclonedatabase;}executingMemoryScriptexecutingcommand:SETuntilclausesqlstatement:alterdatabaseflashbackoffexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEStartingrestoreat24-JAN-18usingchannelORA_AUX_DISK_1channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00001to/u01/app/oracle/oradata/dupjy/system.317.962209603channelORA_AUX_DISK_1:restoringdatafile00003to/u01/app/oracle/oradata/dupjy/sysaux.298.962209605channelORA_AUX_DISK_1:restoringdatafile00004to/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605channelORA_AUX_DISK_1:restoringdatafile00007to/u01/app/oracle/oradata/dupjy/users.301.962209605channelORA_AUX_DISK_1:restoringdatafile00009to/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605channelORA_AUX_DISK_1:readingfrombackuppiece/ora_backup/jy_79spgj9s_JY_966282556_233_1channelORA_AUX_DISK_1:piecehandle=/ora_backup/jy_79spgj9s_JY_966282556_233_1tag=TAG20180124T194913channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:02:25channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00010to/u01/app/oracle/oradata/dupjy/system.271.962209649channelORA_AUX_DISK_1:restoringdatafile00011to/u01/app/oracle/oradata/dupjy/sysaux.316.962209649channelORA_AUX_DISK_1:restoringdatafile00012to/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649channelORA_AUX_DISK_1:restoringdatafile00013to/u01/app/oracle/oradata/dupjy/undo_2.268.962209649channelORA_AUX_DISK_1:restoringdatafile00014to/u01/app/oracle/oradata/dupjy/users.278.962209649channelORA_AUX_DISK_1:restoringdatafile00015to/u01/app/oracle/oradata/dupjy/test.275.962210609channelORA_AUX_DISK_1:readingfrombackuppiece/ora_backup/jy_7aspgjfb_JY_966282731_234_1channelORA_AUX_DISK_1:piecehandle=/ora_backup/jy_7aspgjfb_JY_966282731_234_1tag=TAG20180124T194913channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:55channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00016to/u01/app/oracle/oradata/dupjy/system.260.962469409channelORA_AUX_DISK_1:restoringdatafile00017to/u01/app/oracle/oradata/dupjy/sysaux.259.962469409channelORA_AUX_DISK_1:restoringdatafile00018to/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409channelORA_AUX_DISK_1:restoringdatafile00019to/u01/app/oracle/oradata/dupjy/undo_2.266.962469409channelORA_AUX_DISK_1:restoringdatafile00020to/u01/app/oracle/oradata/dupjy/users.267.962469409channelORA_AUX_DISK_1:restoringdatafile00021to/u01/app/oracle/oradata/dupjy/test.269.962469409channelORA_AUX_DISK_1:readingfrombackuppiece/ora_backup/jy_7bspgjhn_JY_966282807_235_1channelORA_AUX_DISK_1:piecehandle=/ora_backup/jy_7bspgjhn_JY_966282807_235_1tag=TAG20180124T194913channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:45channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00005to/u01/app/oracle/oradata/dupjy/system.256.962209675channelORA_AUX_DISK_1:restoringdatafile00006to/u01/app/oracle/oradata/dupjy/sysaux.270.962209675channelORA_AUX_DISK_1:restoringdatafile00008to/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675channelORA_AUX_DISK_1:readingfrombackuppiece/ora_backup/jy_7cspgjjo_JY_966282872_236_1channelORA_AUX_DISK_1:piecehandle=/ora_backup/jy_7cspgjjo_JY_966282872_236_1tag=TAG20180124T194913channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:36Finishedrestoreat24-JAN-18contentsofMemoryScript:{switchclonedatafileall;}executingMemoryScriptdatafile1switchedtodatafilecopyinputdatafilecopyRECID=21STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/system.317.962209603datafile3switchedtodatafilecopyinputdatafilecopyRECID=22STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605datafile4switchedtodatafilecopyinputdatafilecopyRECID=23STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605datafile5switchedtodatafilecopyinputdatafilecopyRECID=24STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/system.256.962209675datafile6switchedtodatafilecopyinputdatafilecopyRECID=25STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675datafile7switchedtodatafilecopyinputdatafilecopyRECID=26STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/users.301.962209605datafile8switchedtodatafilecopyinputdatafilecopyRECID=27STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675datafile9switchedtodatafilecopyinputdatafilecopyRECID=28STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605datafile10switchedtodatafilecopyinputdatafilecopyRECID=29STAMP=966273552filename=/u01/app/oracle/oradata/dupjy/system.271.962209649datafile11switchedtodatafilecopyinputdatafilecopyRECID=30STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649datafile12switchedtodatafilecopyinputdatafilecopyRECID=31STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649datafile13switchedtodatafilecopyinputdatafilecopyRECID=32STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649datafile14switchedtodatafilecopyinputdatafilecopyRECID=33STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/users.278.962209649datafile15switchedtodatafilecopyinputdatafilecopyRECID=34STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/test.275.962210609datafile16switchedtodatafilecopyinputdatafilecopyRECID=35STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/system.260.962469409datafile17switchedtodatafilecopyinputdatafilecopyRECID=36STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409datafile18switchedtodatafilecopyinputdatafilecopyRECID=37STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409datafile19switchedtodatafilecopyinputdatafilecopyRECID=38STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409datafile20switchedtodatafilecopyinputdatafilecopyRECID=39STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/users.267.962469409datafile21switchedtodatafilecopyinputdatafilecopyRECID=40STAMP=966273553filename=/u01/app/oracle/oradata/dupjy/test.269.962469409contentsofMemoryScript:{setuntilscn15999223;recoverclonedatabasedeletearchivelog;}executingMemoryScriptexecutingcommand:SETuntilclauseStartingrecoverat24-JAN-18usingchannelORA_AUX_DISK_1startingmediarecoverychannelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=177channelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=155channelORA_AUX_DISK_1:readingfrombackuppiece/ora_backup/arch_JY_20180124_7espgjln_1_1channelORA_AUX_DISK_1:piecehandle=/ora_backup/arch_JY_20180124_7espgjln_1_1tag=TAG20180124T195535channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/1_177_961976319.dbfthread=1sequence=177archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/2_155_961976319.dbfthread=2sequence=155channelclone_default:deletingarchivedlog(s)archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/1_177_961976319.dbfRECID=1STAMP=966273556channelclone_default:deletingarchivedlog(s)archivedlogfilename=/u01/app/oracle/oradata/arch_dupjy/2_155_961976319.dbfRECID=2STAMP=966273556mediarecoverycomplete,elapsedtime:00:00:02Finishedrecoverat24-JAN-18OracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1056967968bytesDatabaseBuffers1073741824bytesRedoBuffers7979008bytescontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''DUPJY''comment=''ResettooriginalvaluebyRMAN''scope=spfile";}executingMemoryScriptsqlstatement:altersystemsetdb_name=''DUPJY''comment=''ResettooriginalvaluebyRMAN''scope=spfileOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1056967968bytesDatabaseBuffers1073741824bytesRedoBuffers7979008bytessqlstatement:CREATECONTROLFILEREUSESETDATABASE"DUPJY"RESETLOGSARCHIVELOGMAXLOGFILES192MAXLOGMEMBERS3MAXDATAFILES1024MAXINSTANCES32MAXLOGHISTORY292LOGFILEGROUP1('/u01/app/oracle/oradata/dupjy/group_1.261.961976319')SIZE200MREUSE,GROUP2('/u01/app/oracle/oradata/dupjy/group_2.302.961976321')SIZE200MREUSE,GROUP3('/u01/app/oracle/oradata/dupjy/group_3.263.961976697')SIZE200MREUSE,GROUP4('/u01/app/oracle/oradata/dupjy/group_4.262.961976705')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'CHARACTERSETZHS16GBKcontentsofMemoryScript:{setnewnamefortempfile1to"/u01/app/oracle/oradata/dupjy/temp.299.961976339";setnewnamefortempfile2to"/u01/app/oracle/oradata/dupjy/temp.297.962209865";setnewnamefortempfile3to"/u01/app/oracle/oradata/dupjy/temp.276.962210519";setnewnamefortempfile4to"/u01/app/oracle/oradata/dupjy/temp.258.962469435";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/test.275.962210609","/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/u01/app/oracle/oradata/dupjy/temp.299.961976339incontrolfilerenamedtempfile2to/u01/app/oracle/oradata/dupjy/temp.297.962209865incontrolfilerenamedtempfile3to/u01/app/oracle/oradata/dupjy/temp.276.962210519incontrolfilerenamedtempfile4to/u01/app/oracle/oradata/dupjy/temp.258.962469435incontrolfilecatalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605RECID=1STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605RECID=2STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675RECID=3STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/users.301.962209605RECID=4STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675RECID=5STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605RECID=6STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649RECID=7STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649RECID=8STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649RECID=9STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/users.278.962209649RECID=10STAMP=966273582catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/test.275.962210609RECID=11STAMP=966273583catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409RECID=12STAMP=966273583catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409RECID=13STAMP=966273583catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409RECID=14STAMP=966273583catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/users.267.962469409RECID=15STAMP=966273583catalogeddatafilecopydatafilecopyfilename=/u01/app/oracle/oradata/dupjy/test.269.962469409RECID=16STAMP=966273583datafile3switchedtodatafilecopyinputdatafilecopyRECID=1STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/sysaux.298.962209605datafile4switchedtodatafilecopyinputdatafilecopyRECID=2STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/undotbs1.277.962209605datafile6switchedtodatafilecopyinputdatafilecopyRECID=3STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/sysaux.270.962209675datafile7switchedtodatafilecopyinputdatafilecopyRECID=4STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/users.301.962209605datafile8switchedtodatafilecopyinputdatafilecopyRECID=5STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/undotbs1.296.962209675datafile9switchedtodatafilecopyinputdatafilecopyRECID=6STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/undotbs2.312.962209605datafile11switchedtodatafilecopyinputdatafilecopyRECID=7STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/sysaux.316.962209649datafile12switchedtodatafilecopyinputdatafilecopyRECID=8STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/undotbs1.264.962209649datafile13switchedtodatafilecopyinputdatafilecopyRECID=9STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/undo_2.268.962209649datafile14switchedtodatafilecopyinputdatafilecopyRECID=10STAMP=966273582filename=/u01/app/oracle/oradata/dupjy/users.278.962209649datafile15switchedtodatafilecopyinputdatafilecopyRECID=11STAMP=966273583filename=/u01/app/oracle/oradata/dupjy/test.275.962210609datafile17switchedtodatafilecopyinputdatafilecopyRECID=12STAMP=966273583filename=/u01/app/oracle/oradata/dupjy/sysaux.259.962469409datafile18switchedtodatafilecopyinputdatafilecopyRECID=13STAMP=966273583filename=/u01/app/oracle/oradata/dupjy/undotbs1.265.962469409datafile19switchedtodatafilecopyinputdatafilecopyRECID=14STAMP=966273583filename=/u01/app/oracle/oradata/dupjy/undo_2.266.962469409datafile20switchedtodatafilecopyinputdatafilecopyRECID=15STAMP=966273583filename=/u01/app/oracle/oradata/dupjy/users.267.962469409datafile21switchedtodatafilecopyinputdatafilecopyRECID=16STAMP=966273583filename=/u01/app/oracle/oradata/dupjy/test.269.962469409contentsofMemoryScript:{Alterclonedatabaseopenresetlogs;}executingMemoryScriptdatabaseopenedcontentsofMemoryScript:{sqlclone"alterpluggabledatabaseallopen";}executingMemoryScriptsqlstatement:alterpluggabledatabaseallopenFinishedDuplicateDbat24-JAN-18

13.检查源RAC CDB(jy)是否被成功复制成单实例CDB(dupjy)

SQL>altersessionsetcontainer=testpdb;Sessionaltered.SQL>selectcount(*)fromjy.t1;COUNT(*)----------39SQL>selecttable_name,tablespace_namefromdba_tableswhereowner='JY';TABLE_NAMETABLESPACE_NAME--------------------------------------------------------------------------------------------------------------------------------------------------------------T1

到此，关于“怎么将源RAC CDB数据库复制成为单实例CDB数据库”的学习就结束了，希望能够解决大家的疑惑。理论与实践的搭配能更好的帮助大家学习，快去试试吧！若想继续学习更多相关知识，请继续关注亿速云网站，小编会继续努力为大家带来更多实用的文章！