本篇内容介绍了“怎么复制一个RAC 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.在目标主机上创建存储目标数据库(dup)相关数据库文件的目录，目标主机上的+fra/dup目录用来存储数据库的数据文件，控制文件，联机重做日志文件),+fra/dup目录用来存储数据库的归档重做日志文件

ASMCMD[+fra]>mkdirdup

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

[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@jytest1admin]$asmcmdcp+DATA/JY/PASSWORD/pwdjy.274.961976109/home/grid/orapwdup1copying+DATA/JY/PASSWORD/pwdjy.274.961976109->/home/grid/orapwdup1[root@jytest1~]#cp/home/grid/orapwdup/u01/app/oracle/product/12.2.0/db/dbs/orapwdup1[root@jytest1~]#chown-Roracle:oinstall/u01/app/oracle/product/12.2.0/db/dbs/orapwdup1[root@jytest1~]#chmod-R777/u01/app/oracle/product/12.2.0/db/dbs/orapwdup1

将密码文件orapwdup复制到2号实例主机上

[oracle@jytest2dbs]$scporacle@10.138.130.171:/u01/app/oracle/product/12.2.0/db/dbs/orapwdup1/u01/app/oracle/product/12.2.0/db/dbs/orapwdup1100%35843.5KB/s00:00[oracle@jytest2dbs]$mvorapwdup1orapwdup2

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

SQL>createpfilefromspfile;Filecreated.[oracle@jytest1dbs]$viinitdup1.ora*.audit_file_dest='/u01/app/oracle/admin/dup/adump'*.cluster_database=false*.compatible='12.2.0'*.control_files='+fra/dup/CONTROLFILE/control01.ctl'*.db_block_size=8192*.db_name='dup'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP)(SERVICE=jyXDB)'*.enable_pluggable_database=truedup2.instance_number=2dup1.instance_number=1*.local_listener='-oraagent-dummy-'*.log_archive_dest_1='location=+test/arch/dup'*.nls_language='AMERICAN'*.nls_territory='AMERICA'*.open_cursors=300*.pga_aggregate_target=1g*.processes=2000*.remote_login_passwordfile='exclusive'*.sga_max_size=2147483648*.sga_target=2147483648dup2.thread=2dup1.thread=1*.undo_retention=8640dup1.undo_tablespace='UNDOTBS1'dup2.undo_tablespace='UNDOTBS2'*.db_file_name_convert=('+DATA/JY/','+fra/dup')*.log_file_name_convert=('+DATA/JY/','+fra/dup')[oracle@jytest1dbs]$exportORACLE_SID=dup1[oracle@jytest1dbs]$sqlplus/assysdbaSQL*Plus:Release12.2.0.1.0ProductiononFriJan1919:46:072018Copyright(c)1982,2016,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupnomountpfile='/u01/app/oracle/product/12.2.0/db/dbs/initdup1.ora'ORACLEinstancestarted.TotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1459621152bytesDatabaseBuffers671088640bytesRedoBuffers7979008bytesSQL>createspfile='+fra/dup/spfiledup.ora'frompfile='/u01/app/oracle/product/12.2.0/db/dbs/initdup1.ora';Filecreated.[oracle@jytest1dbs]$viinitdup1.oraspfile=+fra/dup/spfiledup.ora[oracle@jytest2dbs]$viinitdup1.oraspfile=+fra/dup/spfiledup.ora

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

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

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

[grid@jytest1admin]$vilistener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=dup1)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db)(GLOBAL_DBNAME=dup)))[grid@jytest2admin]$vilistener.oraSID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=dup2)(ORACLE_HOME=/u01/app/oracle/product/12.2.0/db)(GLOBAL_DBNAME=dup)))[grid@jytest1admin]$srvctlstoplistener-listenerLISTENER[grid@jytest1admin]$srvctlstartlistener-listenerLISTENER[grid@jytest1admin]$lsnrctlstatusLSNRCTLforLinux:Version12.2.0.1.0-Productionon19-JAN-201822:36:22Copyright(c)1991,2016,Oracle.Allrightsreserved.Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUSoftheLISTENER------------------------AliasLISTENERVersionTNSLSNRforLinux:Version12.2.0.1.0-ProductionStartDate19-JAN-201822:32:51Uptime0days0hr.3min.31secTraceLeveloffSecurityON:LocalOSAuthenticationSNMPOFFListenerParameterFile/u01/app/product/12.2.0/crs/network/admin/listener.oraListenerLogFile/u01/app/grid/diag/tnslsnr/jytest1/listener/alert/log.xmlListeningEndpointsSummary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.171)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.175)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=jytest1.jydba.net)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0/db/admin/jy/xdb_wallet))(Presentation=HTTP)(Session=RAW))ServicesSummary...Service"+ASM"has1instance(s).Instance"+ASM1",statusREADY,has1handler(s)forthisservice...Service"+ASM_CRS"has1instance(s).Instance"+ASM1",statusREADY,has1handler(s)forthisservice...Service"+ASM_DATA"has1instance(s).Instance"+ASM1",statusREADY,has1handler(s)forthisservice...Service"+ASM_FRA"has1instance(s).Instance"+ASM1",statusREADY,has1handler(s)forthisservice...Service"+ASM_TEST"has1instance(s).Instance"+ASM1",statusREADY,has1handler(s)forthisservice...Service"5f9ac6865e87549fe053ab828a0ade94"has1instance(s).Instance"jy1",statusREADY,has1handler(s)forthisservice...Service"600d6f56deb669cce053ab828a0aab7e"has1instance(s).Instance"jy1",statusREADY,has1handler(s)forthisservice...Service"dup"has1instance(s).Instance"dup1",statusUNKNOWN,has1handler(s)forthisservice...Service"jy"has1instance(s).Instance"jy1",statusREADY,has1handler(s)forthisservice...Service"jyXDB"has1instance(s).Instance"jy1",statusREADY,has1handler(s)forthisservice...Service"jypdb"has1instance(s).Instance"jy1",statusREADY,has1handler(s)forthisservice...Service"testpdb"has1instance(s).Instance"jy1",statusREADY,has1handler(s)forthisservice...Thecommandcompletedsuccessfully[grid@jytest2admin]$lsnrctlstatusLSNRCTLforLinux:Version12.2.0.1.0-Productionon19-JAN-201822:41:01Copyright(c)1991,2016,Oracle.Allrightsreserved.Connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))STATUSoftheLISTENER------------------------AliasLISTENERVersionTNSLSNRforLinux:Version12.2.0.1.0-ProductionStartDate19-JAN-201822:37:29Uptime0days0hr.3min.31secTraceLeveloffSecurityON:LocalOSAuthenticationSNMPOFFListenerParameterFile/u01/app/product/12.2.0/crs/network/admin/listener.oraListenerLogFile/u01/app/grid/diag/tnslsnr/jytest2/listener/alert/log.xmlListeningEndpointsSummary...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.172)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.138.130.176)(PORT=1521)))(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=jytest2.jydba.net)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/12.2.0/db/admin/jy/xdb_wallet))(Presentation=HTTP)(Session=RAW))ServicesSummary...Service"+ASM"has1instance(s).Instance"+ASM2",statusREADY,has1handler(s)forthisservice...Service"+ASM_CRS"has1instance(s).Instance"+ASM2",statusREADY,has1handler(s)forthisservice...Service"+ASM_DATA"has1instance(s).Instance"+ASM2",statusREADY,has1handler(s)forthisservice...Service"+ASM_FRA"has1instance(s).Instance"+ASM2",statusREADY,has1handler(s)forthisservice...Service"+ASM_TEST"has1instance(s).Instance"+ASM2",statusREADY,has1handler(s)forthisservice...Service"5f9ac6865e87549fe053ab828a0ade94"has1instance(s).Instance"jy2",statusREADY,has1handler(s)forthisservice...Service"600d6f56deb669cce053ab828a0aab7e"has1instance(s).Instance"jy2",statusREADY,has1handler(s)forthisservice...Service"dup"has1instance(s).Instance"dup2",statusUNKNOWN,has1handler(s)forthisservice...Service"jy"has1instance(s).Instance"jy2",statusREADY,has1handler(s)forthisservice...Service"jyXDB"has1instance(s).Instance"jy2",statusREADY,has1handler(s)forthisservice...Service"jypdb"has1instance(s).Instance"jy2",statusREADY,has1handler(s)forthisservice...Service"testpdb"has1instance(s).Instance"jy2",statusREADY,has1handler(s)forthisservice...Thecommandcompletedsuccessfully

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

[oracle@jytest1admin]$vitnsnames.oraDUP=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.130.171)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dup)(UR=A)))[oracle@jytest2admin]$vitnsnames.oraDUP=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.130.172)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=dup)(UR=A)))

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

[oracle@jytest1admin]$sqlplus/nologSQL*Plus:Release12.2.0.1.0ProductiononFriJan1922:58:342018Copyright(c)1982,2016,Oracle.Allrightsreserved.SQL>connsys/abcd@dupassysdbaConnected.SQL>connsys/abcd@jyassysdbaConnected.

9.执行数据库复制

[oracle@jytest1admin]$rmantargetsys/abcd@jycatalogrco/abcd@jypdb_173auxiliarysys/abcd@dupRecoveryManager:Release12.2.0.1.0-ProductiononFriJan1923:16:152018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723)connectedtorecoverycatalogdatabaseconnectedtoauxiliarydatabase:DUP(notmounted)RMAN>duplicatetargetdatabasetodupfromactivedatabasenofilenamecheckusingcompressedbackupset;StartingDuplicateDbat19-JAN-18allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=2275devicetype=DISKcurrentlogarchivedcontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''JY''comment=''ModifiedbyRMANduplicate''scope=spfile";sqlclone"altersystemsetdb_unique_name=''DUP''comment=''ModifiedbyRMANduplicate''scope=spfile";shutdowncloneimmediate;startupcloneforcenomountrestoreclonefromservice'jy'usingcompressedbackupsetprimarycontrolfile;alterclonedatabasemount;}executingMemoryScriptsqlstatement:altersystemsetdb_name=''JY''comment=''ModifiedbyRMANduplicate''scope=spfilesqlstatement:altersystemsetdb_unique_name=''DUP''comment=''ModifiedbyRMANduplicate''scope=spfileOracleinstanceshutdownOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1459621152bytesDatabaseBuffers671088640bytesRedoBuffers7979008bytesStartingrestoreat19-JAN-18allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=1519devicetype=DISKchannelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringcontrolfilechannelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:06outputfilename=+FRA/dup/CONTROLFILE/control01.ctlFinishedrestoreat19-JAN-18databasemountedRMAN-05529:warning:DB_FILE_NAME_CONVERTresultedininvalidASMnames;nameschangedtodiskgrouponly.contentsofMemoryScript:{sqlclone'alterdatabaseflashbackoff';setnewnamefordatafile1to"+FRA";setnewnamefordatafile3to"+FRA";setnewnamefordatafile4to"+FRA";setnewnamefordatafile5to"+FRA";setnewnamefordatafile6to"+FRA";setnewnamefordatafile7to"+FRA";setnewnamefordatafile8to"+FRA";setnewnamefordatafile9to"+FRA";setnewnamefordatafile10to"+FRA";setnewnamefordatafile11to"+FRA";setnewnamefordatafile12to"+FRA";setnewnamefordatafile13to"+FRA";setnewnamefordatafile14to"+FRA";setnewnamefordatafile15to"+FRA";setnewnamefordatafile16to"+FRA";setnewnamefordatafile17to"+FRA";setnewnamefordatafile18to"+FRA";setnewnamefordatafile19to"+FRA";setnewnamefordatafile20to"+FRA";setnewnamefordatafile21to"+FRA";restorefromnonsparsefromservice'jy'usingcompressedbackupsetclonedatabase;sql'altersystemarchivelogcurrent';}executingMemoryScriptsqlstatement:alterdatabaseflashbackoffexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEStartingrestoreat19-JAN-18usingchannelORA_AUX_DISK_1channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00001to+FRAchannelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:55channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00003to+FRAchannelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:01:46channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00004to+FRAchannelORA_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:restoringdatafile00005to+FRAchannelORA_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+FRAchannelORA_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+FRAchannelORA_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+FRAchannelORA_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:restoringdatafile00009to+FRAchannelORA_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:restoringdatafile00010to+FRAchannelORA_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+FRAchannelORA_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:restoringdatafile00012to+FRAchannelORA_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+FRAchannelORA_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+FRAchannelORA_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:restoringdatafile00015to+FRAchannelORA_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:restoringdatafile00016to+FRAchannelORA_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+FRAchannelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:35channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00018to+FRAchannelORA_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:restoringdatafile00019to+FRAchannelORA_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:restoringdatafile00020to+FRAchannelORA_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:restoringdatafile00021to+FRAchannelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:04Finishedrestoreat19-JAN-18sqlstatement:altersystemarchivelogcurrentcurrentlogarchivedcontentsofMemoryScript:{restorecloneforcefromservice'jy'usingcompressedbackupsetarchivelogfromscn13147698;switchclonedatafileall;}executingMemoryScriptStartingrestoreat19-JAN-18usingchannelORA_AUX_DISK_1channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=137channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:08channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=138channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=1sequence=139channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:02channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=114channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01channelORA_AUX_DISK_1:startingarchivedlogrestoretodefaultdestinationchannelORA_AUX_DISK_1:usingcompressednetworkbackupsetfromservicejychannelORA_AUX_DISK_1:restoringarchivedlogarchivedlogthread=2sequence=115channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:04Finishedrestoreat19-JAN-18datafile1switchedtodatafilecopyinputdatafilecopyRECID=24STAMP=965863480filename=+FRA/DUP/DATAFILE/system.376.965863053datafile3switchedtodatafilecopyinputdatafilecopyRECID=25STAMP=965863482filename=+FRA/DUP/DATAFILE/sysaux.379.965863109datafile4switchedtodatafilecopyinputdatafilecopyRECID=26STAMP=965863482filename=+FRA/DUP/DATAFILE/undotbs1.380.965863215datafile5switchedtodatafilecopyinputdatafilecopyRECID=27STAMP=965863482filename=+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.381.965863229datafile6switchedtodatafilecopyinputdatafilecopyRECID=28STAMP=965863482filename=+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.382.965863245datafile7switchedtodatafilecopyinputdatafilecopyRECID=29STAMP=965863483filename=+FRA/DUP/DATAFILE/users.364.965863281datafile8switchedtodatafilecopyinputdatafilecopyRECID=30STAMP=965863483filename=+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.365.965863281datafile9switchedtodatafilecopyinputdatafilecopyRECID=31STAMP=965863483filename=+FRA/DUP/DATAFILE/undotbs2.366.965863289datafile10switchedtodatafilecopyinputdatafilecopyRECID=32STAMP=965863483filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.367.965863293datafile11switchedtodatafilecopyinputdatafilecopyRECID=33STAMP=965863483filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.326.965863309datafile12switchedtodatafilecopyinputdatafilecopyRECID=34STAMP=965863484filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.285.965863345datafile13switchedtodatafilecopyinputdatafilecopyRECID=35STAMP=965863484filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.325.965863349datafile14switchedtodatafilecopyinputdatafilecopyRECID=36STAMP=965863484filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.369.965863351datafile15switchedtodatafilecopyinputdatafilecopyRECID=37STAMP=965863484filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.370.965863387datafile16switchedtodatafilecopyinputdatafilecopyRECID=38STAMP=965863484filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.371.965863391datafile17switchedtodatafilecopyinputdatafilecopyRECID=39STAMP=965863485filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.372.965863407datafile18switchedtodatafilecopyinputdatafilecopyRECID=40STAMP=965863485filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.373.965863443datafile19switchedtodatafilecopyinputdatafilecopyRECID=41STAMP=965863485filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.375.965863445datafile20switchedtodatafilecopyinputdatafilecopyRECID=42STAMP=965863485filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.377.965863449datafile21switchedtodatafilecopyinputdatafilecopyRECID=43STAMP=965863485filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.378.965863451contentsofMemoryScript:{setuntilscn13148610;recoverclonedatabasedeletearchivelog;}executingMemoryScriptexecutingcommand:SETuntilclauseStartingrecoverat19-JAN-18usingchannelORA_AUX_DISK_1startingmediarecoveryarchivedlogforthread1withsequence137isalreadyondiskasfile+TEST/arch/dup/1_137_961976319.dbfarchivedlogforthread1withsequence138isalreadyondiskasfile+TEST/arch/dup/1_138_961976319.dbfarchivedlogforthread1withsequence139isalreadyondiskasfile+TEST/arch/dup/1_139_961976319.dbfarchivedlogforthread2withsequence114isalreadyondiskasfile+TEST/arch/dup/2_114_961976319.dbfarchivedlogforthread2withsequence115isalreadyondiskasfile+TEST/arch/dup/2_115_961976319.dbfarchivedlogfilename=+TEST/arch/dup/2_114_961976319.dbfthread=2sequence=114archivedlogfilename=+TEST/arch/dup/1_137_961976319.dbfthread=1sequence=137archivedlogfilename=+TEST/arch/dup/1_138_961976319.dbfthread=1sequence=138archivedlogfilename=+TEST/arch/dup/2_115_961976319.dbfthread=2sequence=115archivedlogfilename=+TEST/arch/dup/1_139_961976319.dbfthread=1sequence=139mediarecoverycomplete,elapsedtime:00:00:04Finishedrecoverat19-JAN-18OracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1459621152bytesDatabaseBuffers671088640bytesRedoBuffers7979008bytescontentsofMemoryScript:{sqlclone"altersystemsetdb_name=''DUP''comment=''ResettooriginalvaluebyRMAN''scope=spfile";sqlclone"altersystemresetdb_unique_namescope=spfile";}executingMemoryScriptsqlstatement:altersystemsetdb_name=''DUP''comment=''ResettooriginalvaluebyRMAN''scope=spfilesqlstatement:altersystemresetdb_unique_namescope=spfileOracleinstancestartedTotalSystemGlobalArea2147483648bytesFixedSize8794848bytesVariableSize1459621152bytesDatabaseBuffers671088640bytesRedoBuffers7979008bytessqlstatement:CREATECONTROLFILEREUSESETDATABASE"DUP"RESETLOGSARCHIVELOGMAXLOGFILES192MAXLOGMEMBERS3MAXDATAFILES1024MAXINSTANCES32MAXLOGHISTORY292LOGFILEGROUP1('+FRA')SIZE200MREUSE,GROUP2('+FRA')SIZE200MREUSEDATAFILE'+FRA/DUP/DATAFILE/system.376.965863053','+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/system.381.965863229','+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/system.367.965863293','+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/system.371.965863391'CHARACTERSETZHS16GBKsqlstatement:ALTERDATABASEADDLOGFILEINSTANCE'i2'GROUP3('+FRA')SIZE200MREUSE,GROUP4('+FRA')SIZE200MREUSEcontentsofMemoryScript:{setnewnamefortempfile1to"+FRA";setnewnamefortempfile2to"+FRA";setnewnamefortempfile3to"+FRA";setnewnamefortempfile4to"+FRA";switchclonetempfileall;catalogclonedatafilecopy"+FRA/DUP/DATAFILE/sysaux.379.965863109","+FRA/DUP/DATAFILE/undotbs1.380.965863215","+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.382.965863245","+FRA/DUP/DATAFILE/users.364.965863281","+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.365.965863281","+FRA/DUP/DATAFILE/undotbs2.366.965863289","+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.326.965863309","+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.285.965863345","+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.325.965863349","+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.369.965863351","+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.370.965863387","+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.372.965863407","+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.373.965863443","+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.375.965863445","+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.377.965863449","+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.378.965863451";switchclonedatafileall;}executingMemoryScriptexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMErenamedtempfile1to+FRAincontrolfilerenamedtempfile2to+FRAincontrolfilerenamedtempfile3to+FRAincontrolfilerenamedtempfile4to+FRAincontrolfilecatalogeddatafilecopydatafilecopyfilename=+FRA/DUP/DATAFILE/sysaux.379.965863109RECID=1STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/DATAFILE/undotbs1.380.965863215RECID=2STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.382.965863245RECID=3STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/DATAFILE/users.364.965863281RECID=4STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.365.965863281RECID=5STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/DATAFILE/undotbs2.366.965863289RECID=6STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.326.965863309RECID=7STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.285.965863345RECID=8STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.325.965863349RECID=9STAMP=965863550catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.369.965863351RECID=10STAMP=965863551catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.370.965863387RECID=11STAMP=965863551catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.372.965863407RECID=12STAMP=965863551catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.373.965863443RECID=13STAMP=965863551catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.375.965863445RECID=14STAMP=965863551catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.377.965863449RECID=15STAMP=965863551catalogeddatafilecopydatafilecopyfilename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.378.965863451RECID=16STAMP=965863551datafile3switchedtodatafilecopyinputdatafilecopyRECID=1STAMP=965863550filename=+FRA/DUP/DATAFILE/sysaux.379.965863109datafile4switchedtodatafilecopyinputdatafilecopyRECID=2STAMP=965863550filename=+FRA/DUP/DATAFILE/undotbs1.380.965863215datafile6switchedtodatafilecopyinputdatafilecopyRECID=3STAMP=965863550filename=+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/sysaux.382.965863245datafile7switchedtodatafilecopyinputdatafilecopyRECID=4STAMP=965863550filename=+FRA/DUP/DATAFILE/users.364.965863281datafile8switchedtodatafilecopyinputdatafilecopyRECID=5STAMP=965863550filename=+FRA/DUP/5F9AA264B21F3ED9E053AB828A0A6088/DATAFILE/undotbs1.365.965863281datafile9switchedtodatafilecopyinputdatafilecopyRECID=6STAMP=965863550filename=+FRA/DUP/DATAFILE/undotbs2.366.965863289datafile11switchedtodatafilecopyinputdatafilecopyRECID=7STAMP=965863550filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/sysaux.326.965863309datafile12switchedtodatafilecopyinputdatafilecopyRECID=8STAMP=965863550filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undotbs1.285.965863345datafile13switchedtodatafilecopyinputdatafilecopyRECID=9STAMP=965863550filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/undo_2.325.965863349datafile14switchedtodatafilecopyinputdatafilecopyRECID=10STAMP=965863551filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/users.369.965863351datafile15switchedtodatafilecopyinputdatafilecopyRECID=11STAMP=965863551filename=+FRA/DUP/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/test.370.965863387datafile17switchedtodatafilecopyinputdatafilecopyRECID=12STAMP=965863551filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/sysaux.372.965863407datafile18switchedtodatafilecopyinputdatafilecopyRECID=13STAMP=965863551filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undotbs1.373.965863443datafile19switchedtodatafilecopyinputdatafilecopyRECID=14STAMP=965863551filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/undo_2.375.965863445datafile20switchedtodatafilecopyinputdatafilecopyRECID=15STAMP=965863551filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/users.377.965863449datafile21switchedtodatafilecopyinputdatafilecopyRECID=16STAMP=965863551filename=+FRA/DUP/600D6F56DEB669CCE053AB828A0AAB7E/DATAFILE/test.378.965863451contentsofMemoryScript:{Alterclonedatabaseopenresetlogs;}executingMemoryScriptdatabaseopenedcontentsofMemoryScript:{sqlclone"alterpluggabledatabaseallopen";}executingMemoryScriptsqlstatement:alterpluggabledatabaseallopenFinishedDuplicateDbat19-JAN-18

10.检查数据是否一致
在源数据库查询表记录

SQL>connsys/abcd@jyassysdbaConnected.SQL>showparameterdb_nameNAMETYPEVALUE-----------------------------------------------------------------------------db_namestringjySQL>altersessionsetcontainer=jypdb;Sessionaltered.SQL>selectcount(*)fromJY.SALES_Q3_1998;COUNT(*)----------50515

在目标数据库查询表记录

SQL>connsys/abcd@dupassysdbaConnected.SQL>showparameterdb_nameNAMETYPEVALUE-----------------------------------------------------------------------------db_namestringDUPSQL>altersessionsetcontainer=jypdb;Sessionaltered.SQL>selectcount(*)fromJY.SALES_Q3_1998;COUNT(*)----------50515

“怎么复制一个RAC CDB数据库”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注亿速云网站，小编将为大家输出更多高质量的实用文章！