本篇内容主要讲解“如何使用备份集跨平台传输整个CDB数据库”，感兴趣的朋友不妨来看看。本文介绍的方法操作简单快捷，实用性强。下面就让小编来带大家学习“如何使用备份集跨平台传输整个CDB数据库”吧!

可以从源平台传输整个数据库到有相同字节序的不同平台。当为了传输数据库而创建跨平台备份时，可以在源平台或目标平台上执行对数据库的转换。在目标平台执行对数据库的转换的最大好处就是执行转换的开锁从源平台转 移到了目标平台。
使用备份集执行跨平台数据库传输的先决条件
在为了跨平台传输数据库而创建跨平台备份之前需要满足以下条件:
.源数据库与目标数据库的spfile文件中的compatible参数必须设置为12.0.0或更高的版本。
.源数据库必须是read-only模式打开。
.dbms_tdb.check_db过程必须成功运行。
.源平台与目标平台必须有相同的字节序。

下面的例子将使用备份集执行跨平台传输数据库，源平台为Linux 64位，目标平台为windows 64位其具体操作如下
1.在目标平台上创建数据库实例jy
设置环境变量ORACLE_SID

C:\Users\Administrator>setORACLE_SID=jy

创建实例

C:\Users\Administrator>oradim-new-sidjy-startmodem输入Oracle服务用户的口令:实例已创建。

创建Oracle口令文件

C:\Users\Administrator>orapwdfile=D:\app\oracle\product\12.2.0\dbhome_1\database\pwdjy.orapassword=xxzx$7817600sysbackup=xxzx$7817600

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = jy)
(ORACLE_HOME =D:\app\oracle\product\12.2.0\dbhome_1)
(GLOBAL_DBNAME=jy)
)
)

在tnsnames.ora文件中增加以下内容

JY=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-ROUOJ6ERFO3)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=jy)(UR=A)))

2.利用源数据库的spfile文件来为目标数据库创建spfile文件

SQL>createpfile='$ORACLE_HOME/dbs/inityyl.ora'fromspfile;Filecreated.

将上面生成的inityyl.ora文件复制到目标平台D:\app\oracle\product\12.2.0\dbhome_1\database目录下并将其内容修改成如下所示

*.audit_file_dest='D:\app\oracle\admin\jy\adump'*.cluster_database=false*.compatible='12.2.0'*.control_files='D:\APP\ORACLE\ORADATA\JY\CONTROLFILE\control01.ctl'*.db_block_size=8192*.db_create_file_dest='D:\app\oracle\oradata\'*.db_name='jy'*.diagnostic_dest='D:\app\oracle\'*.dispatchers='(PROTOCOL=TCP)(SERVICE=jyXDB)'*.enable_pluggable_database=truejy2.instance_number=2jy1.instance_number=1*.log_archive_dest_1='location=D:\app\oracle\oradata\arch\jy'*.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=2147483648jy2.thread=2jy1.thread=1*.undo_retention=8640jy1.undo_tablespace='UNDOTBS1'jy2.undo_tablespace='UNDOTBS2'

3.在目标平台上启动实例jy

C:\Users\Administrator>sqlplus/assysdbaSQL*Plus:Release12.2.0.1.0Productionon星期四2月101:23:542018Copyright(c)1982,2016,Oracle.Allrightsreserved.已连接到空闲例程。SQL>startupnomountORACLE例程已经启动。TotalSystemGlobalArea2147483648bytesFixedSize8920984bytesVariableSize1392509032bytesDatabaseBuffers738197504bytesRedoBuffers7856128bytes

创建spfile参数文件并重启实例到nomount状态

SQL>createspfilefrompfile='D:\app\oracle\product\12.2.0\dbhome_1\database\initjy.ora';文件已创建。SQL>shutdownimmediateORA-01507:??????ORACLE例程已经关闭。SQL>startupnomountORACLE例程已经启动。TotalSystemGlobalArea2147483648bytesFixedSize8920984bytesVariableSize1392509032bytesDatabaseBuffers738197504bytesRedoBuffers7856128bytesSQL>showparameterspfileNAMETYPEVALUE---------------------------------------------------------------------------------------------------------------------spfilestringD:\APP\ORACLE\PRODUCT\12.2.0\DBHOME_1\DATABASE\SPFILEJY.ORA

测试tns连接实例jy是否能够成功

C:\Users\Administrator>sqlplus/nologSQL*Plus:Release12.2.0.1.0Productionon星期四2月118:01:522018Copyright(c)1982,2016,Oracle.Allrightsreserved.SQL>connsys/abcd@jyassysdba已连接。

4.使用有sysdba权限的用户通过SQL*Plus连接到源数据库，并查询v$transportable_platform来查询目标平台的名字，因为传输整个数据库源平台与目标平台的字节序应该相同。

[oracle@jytest1~]$sqlplus/assysdbaSQL*Plus:Release12.2.0.1.0ProductiononThuFeb118:06:372018Copyright(c)1982,2016,Oracle.Allrightsreserved.Connectedto:OracleDatabase12cEnterpriseEditionRelease12.2.0.1.0-64bitProductionSQL>setlong200SQL>setlinesize200SQL>selectplatform_name,endian_formatfromv$transportable_platform;PLATFORM_NAMEENDIAN_FORMAT-------------------------------------------------------------------------------------------------------------------Solaris[tm]OE(32-bit)BigSolaris[tm]OE(64-bit)BigMicrosoftWindowsIA(32-bit)LittleLinuxIA(32-bit)LittleAIX-BasedSystems(64-bit)BigHP-UX(64-bit)BigHPTru64UNIXLittleHP-UXIA(64-bit)BigLinuxIA(64-bit)LittleHPOpenVMSLittleMicrosoftWindowsIA(64-bit)LittleIBMzSeriesBasedLinuxBigLinuxx8664-bitLittleAppleMacOSBigMicrosoftWindowsx8664-bitLittleSolarisOperatingSystem(x86)LittleIBMPowerBasedLinuxBigHPIAOpenVMSLittleSolarisOperatingSystem(x86-64)LittleAppleMacOS(x86-64)Little20rowsselected.

我这里源平台为Linux x86 64-bit,目标平台为Microsoft Windows IA (64-bit),两个平台的字节序都是Little

5.给RMAN备份输出文件选择命名方法
使用backup命令的format子句来为备份输出文件选择输出方法。比如使用format子句来为备份输出文件指定存储目录/ora_backup/tdb并且为每个文件生成以transport_为前缀的唯一文件名。FORMAT '/ora_backup/tdb/transport_%U'

6.启动RMAN连接到源数据库(整个RAC CDB)并将重启源数据库并以只读方式打开。

[oracle@jytest1tdb]$rmantargetsys/abcd0@jycatalogrco/abcd@jypdb_173RecoveryManager:Release12.2.0.1.0-ProductiononThuFeb118:37:042018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:JY(DBID=979425723)connectedtorecoverycatalogdatabaseRMAN>shutdownimmediatestartingfullresyncofrecoverycatalogfullresynccompletedatabasecloseddatabasedismountedOracleinstanceshutdownRMAN>startupmountconnectedtotargetdatabase:JY(DBID=979425723)databaseisalreadystartedstartingfullresyncofrecoverycatalogfullresynccompleteRMAN>alterdatabaseopenreadonly;startingfullresyncofrecoverycatalogfullresynccompleteStatementprocessed

7.在backup命令中使用for transport或to platform子句来备份源数据库。下面的例子对整个数据库创建跨平台传输备份。备份可以被还原到任何与源平台有相同字节序的平台。这里源平台为Linux x86 64-bit，因为使用了 for transport子句，那么对整个数据库的转换操作将在目标平台上执行。跨平台数据库备份被存储在/ora_backup/tdb目录中。

RMAN>backupfortransportformat'/ora_backup/tdb/db_transport_%U'database;Startingbackupat01-FEB-18usingchannelORA_DISK_1channelORA_DISK_1:startingfulldatafilebackupsetchannelORA_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:startingpiece1at01-FEB-18channelORA_DISK_1:finishedpiece1at01-FEB-18piecehandle=/ora_backup/tdb/db_transport_7ssq5l1i_1_1tag=TAG20180201T192745comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:02:05channelORA_DISK_1:startingfulldatafilebackupsetchannelORA_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.962210609inputdatafilefilenumber=00022name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353inputdatafilefilenumber=00023name=+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783channelORA_DISK_1:startingpiece1at01-FEB-18channelORA_DISK_1:finishedpiece1at01-FEB-18piecehandle=/ora_backup/tdb/db_transport_7tsq5l5g_1_1tag=TAG20180201T192745comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:01:45channelORA_DISK_1:startingfulldatafilebackupsetchannelORA_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:startingpiece1at01-FEB-18channelORA_DISK_1:finishedpiece1at01-FEB-18piecehandle=/ora_backup/tdb/db_transport_7usq5l8p_1_1tag=TAG20180201T192745comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:01:25channelORA_DISK_1:startingfulldatafilebackupsetchannelORA_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:startingpiece1at01-FEB-18channelORA_DISK_1:finishedpiece1at01-FEB-18piecehandle=/ora_backup/tdb/db_transport_7vsq5lbf_1_1tag=TAG20180201T192745comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:25Finishedbackupat01-FEB-18[oracle@jytest1tdb]$ls-lrttotal5532808-rw-r-----1oracleasmadmin3146178560Feb113:27db_transport_7ssq5l1i_1_1-rw-r-----1oracleasmadmin990789632Feb113:29db_transport_7tsq5l5g_1_1-rw-r-----1oracleasmadmin988348416Feb113:30db_transport_7usq5l8p_1_1-rw-r-----1oracleasmadmin540270592Feb113:31db_transport_7vsq5lbf_1_1

备份源数据库的控制文件到跨踪文件中用于在目标平台为目标数据库重新创建控制文件

SQL>altersessionsettracefile_identifier='create';Sessionaltered.SQL>alterdatabasebackupcontrolfiletotraceresetlogs;Databasealtered.[root@jytest1/]#find/-name*create*.trc/u01/app/oracle/diag/rdbms/jy/jy1/trace/jy1_ora_22752_create.trc[root@jytest1/]#cat/u01/app/oracle/diag/rdbms/jy/jy1/trace/jy1_ora_22752_create.trcTracefile/u01/app/oracle/diag/rdbms/jy/jy1/trace/jy1_ora_22752_create.trcOracleDatabase12cEnterpriseEditionRelease12.2.0.1.0-64bitProductionBuildlabel:RDBMS_12.2.0.1.0_LINUX.X64_170125ORACLE_HOME:/u01/app/oracle/product/12.2.0/dbSystemname:LinuxNodename:jytest1.jydba.netRelease:3.8.13-55.1.6.el7uek.x86_64Version:#2SMPWedFeb1114:18:22PST2015Machine:x86_64Instancename:jy1Redothreadmountedbythisinstance:1Oracleprocessnumber:40Unixprocesspid:22752,image:oracle@jytest1.jydba.net(TNSV1-V3)***2018-02-01T23:42:02.696976+08:00(CDB$ROOT(1))***SESSIONID:(6.7558)2018-02-01T23:42:02.697094+08:00***CLIENTID:()2018-02-01T23:42:02.697109+08:00***SERVICENAME:(SYS$USERS)2018-02-01T23:42:02.697120+08:00***MODULENAME:(sqlplus@jytest1.jydba.net(TNSV1-V3))2018-02-01T23:42:02.697131+08:00***ACTIONNAME:()2018-02-01T23:42:02.697141+08:00***CLIENTDRIVER:(SQL*PLUS)2018-02-01T23:42:02.697150+08:00***CONTAINERID:(1)2018-02-01T23:42:02.697161+08:00--ThefollowingarecurrentSystem-scopeREDOLogArchivalrelated--parametersandcanbeincludedinthedatabaseinitializationfile.----LOG_ARCHIVE_DEST=''--LOG_ARCHIVE_DUPLEX_DEST=''----LOG_ARCHIVE_FORMAT=%t_%s_%r.dbf----DB_UNIQUE_NAME="jy"----LOG_ARCHIVE_CONFIG='SEND,RECEIVE,NODG_CONFIG'--LOG_ARCHIVE_MAX_PROCESSES=4--STANDBY_FILE_MANAGEMENT=MANUAL--STANDBY_ARCHIVE_DEST=?#/dbs/arch--FAL_CLIENT=''--FAL_SERVER=''----LOG_ARCHIVE_DEST_1='LOCATION=+TEST/arch'--LOG_ARCHIVE_DEST_1='OPTIONALREOPEN=300NODELAY'--LOG_ARCHIVE_DEST_1='ARCHNOAFFIRMNOVERIFYSYNC'--LOG_ARCHIVE_DEST_1='REGISTERNOALTERNATENODEPENDENCY'--LOG_ARCHIVE_DEST_1='NOMAX_FAILURENOQUOTA_SIZENOQUOTA_USEDNODB_UNIQUE_NAME'--LOG_ARCHIVE_DEST_1='VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILES)'--LOG_ARCHIVE_DEST_STATE_1=ENABLE----Thefollowingcommandswillcreateanewcontrolfileanduseit--toopenthedatabase.--DatausedbyRecoveryManagerwillbelost.--Thecontentsofonlinelogswillbelostandallbackupswill--beinvalidated.Usethisonlyifonlinelogsaredamaged.--Aftermountingthecreatedcontrolfile,thefollowingSQL--statementwillplacethedatabaseintheappropriate--protectionmode:--ALTERDATABASESETSTANDBYDATABASETOMAXIMIZEPERFORMANCESTARTUPNOMOUNTCREATECONTROLFILEREUSEDATABASE"JY"RESETLOGSARCHIVELOGMAXLOGFILES192MAXLOGMEMBERS3MAXDATAFILES1024MAXINSTANCES32MAXLOGHISTORY292LOGFILEGROUP1'+DATA/JY/ONLINELOG/group_1.261.961976319'SIZE200MBLOCKSIZE512,GROUP2'+DATA/JY/ONLINELOG/group_2.302.961976321'SIZE200MBLOCKSIZE512--STANDBYLOGFILEDATAFILE'+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.962469409','+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/tts.257.966380353','+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/DATAFILE/cs.294.966380783'CHARACTERSETZHS16GBK;--ConfiguresnapshotcontrolfilefilenameEXECUTESYS.DBMS_BACKUP_RESTORE.CFILESETSNAPSHOTNAME('+TEST/jy/snapcf_jy.f');--ConfigureRMANconfigurationrecord1VARIABLERECNONUMBER;EXECUTE:RECNO:=SYS.DBMS_BACKUP_RESTORE.SETCONFIG('SNAPSHOTCONTROLFILENAME','TO''+test/jy/snapcf_jy.f''');--ConfigureRMANconfigurationrecord2VARIABLERECNONUMBER;EXECUTE:RECNO:=SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILEAUTOBACKUPFORMATFORDEVICETYPE','DISKTO''+test/rman_backup/%F''');--ConfigureRMANconfigurationrecord3VARIABLERECNONUMBER;EXECUTE:RECNO:=SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILEAUTOBACKUP','ON');--Commandstore-createincarnationtable--BelowlognamesMUSTbechangedtoexistingfilenameson--disk.Anyonelogfilefromeachbranchcanbeusedto--re-createincarnationrecords.--ALTERDATABASEREGISTERLOGFILE'+TEST/arch/1_1_934293149.dbf';--ALTERDATABASEREGISTERLOGFILE'+TEST/arch/1_1_961976319.dbf';--Recoveryisrequiredifanyofthedatafilesarerestoredbackups,--orifthelastshutdownwasnotnormalorimmediate.RECOVERDATABASEUSINGBACKUPCONTROLFILE--Createlogfilesforthreadsotherthanthreadone.ALTERDATABASEADDLOGFILETHREAD2GROUP3'+DATA/JY/ONLINELOG/group_3.263.961976697'SIZE200MBLOCKSIZE512REUSE,GROUP4'+DATA/JY/ONLINELOG/group_4.262.961976705'SIZE200MBLOCKSIZE512REUSE;--Databasecannowbeopenedzeroingtheonlinelogs.ALTERDATABASEOPENRESETLOGS;--OpenallthePDBs.ALTERPLUGGABLEDATABASEALLOPEN;--Commandstoaddtempfilestotemporarytablespaces.--Onlinetempfileshavecompletespaceinformation.--Othertempfilesmayrequireadjustment.ALTERTABLESPACETEMPADDTEMPFILE'+DATA/JY/TEMPFILE/temp.299.961976339'SIZE150994944REUSEAUTOEXTENDONNEXT655360MAXSIZE32767M;ALTERSESSIONSETCONTAINER=PDB$SEED;ALTERTABLESPACETEMPADDTEMPFILE'+DATA/JY/5F9AA264B21F3ED9E053AB828A0A6088/TEMPFILE/temp.297.962209865'SIZE67108864REUSEAUTOEXTENDONNEXT655360MAXSIZE32767M;ALTERSESSIONSETCONTAINER=JYPDB;ALTERTABLESPACETEMPADDTEMPFILE'+DATA/JY/5F9AC6865E87549FE053AB828A0ADE94/TEMPFILE/temp.276.962210519'REUSE;ALTERSESSIONSETCONTAINER=TESTPDB;ALTERTABLESPACETEMPADDTEMPFILE'+DATA/JY/600D6F56DEB669CCE053AB828A0AAB7E/TEMPFILE/temp.258.962469435'REUSE;ALTERSESSIONSETCONTAINER=CDB$ROOT;--Endoftempfileadditions.

8.将在源平台上使用rman backup命令生成的备份集与备份的控制文件传输到目标平台的D:\app\oracle\oradata\tdb目录中

9.使用rman连接到目标数据库并确保目标数据库(单实例CDB)处于nomount状态

C:\Users\Administrator>rmantargetsys/abcd@jy恢复管理器:Release12.2.0.1.0-Productionon星期四2月119:55:442018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.已连接到目标数据库:JY(未装载)

10.使用有foreign database子句的restore命令来还原从源平台传输过来的备份集

RMAN>restorefromplatform'Linuxx8664-bit'foreigndatabasetonewfrombackupset'D:\app\oracle\oradata\tdb\db_transport_7ssq5l1i_1_1'backupset'D:\app\oracle\oradata\tdb\db_transport_7tsq5l5g_1_1'backupset'D:\app\oracle\oradata\tdb\db_transport_7usq5l8p_1_1'backupset'D:\app\oracle\oradata\tdb\db_transport_7vsq5lbf_1_1';从位于02-2月-18的restore开始使用通道ORA_DISK_1通道ORA_DISK_1:正在开始还原数据文件备份集通道ORA_DISK_1:正在指定从备份集还原的数据文件通道ORA_DISK_1:正在还原备份片段中的所有外部文件通道ORA_DISK_1:正在读取备份片段D:\app\oracle\oradata\tdb\db_transport_7ssq5l1i_1_1通道ORA_DISK_1:将外部文件3还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H4FHX_.DBF通道ORA_DISK_1:将外部文件9还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS2_F76H4FHX_.DBF通道ORA_DISK_1:将外部文件4还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H4FHX_.DBF通道ORA_DISK_1:将外部文件1还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H4FHX_.DBF通道ORA_DISK_1:将外部文件7还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H4FJF_.DBF通道ORA_DISK_1:外部片段句柄=D:\app\oracle\oradata\tdb\db_transport_7ssq5l1i_1_1通道ORA_DISK_1:已还原备份片段1通道ORA_DISK_1:还原完成,用时:00:00:56通道ORA_DISK_1:正在开始还原数据文件备份集通道ORA_DISK_1:正在指定从备份集还原的数据文件通道ORA_DISK_1:正在还原备份片段中的所有外部文件通道ORA_DISK_1:正在读取备份片段D:\app\oracle\oradata\tdb\db_transport_7tsq5l5g_1_1通道ORA_DISK_1:将外部文件14还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H65NX_.DBF通道ORA_DISK_1:将外部文件11还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H65NX_.DBF通道ORA_DISK_1:将外部文件13还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H65NX_.DBF通道ORA_DISK_1:将外部文件10还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H65NX_.DBF通道ORA_DISK_1:将外部文件12还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H65NX_.DBF通道ORA_DISK_1:将外部文件15还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H65NX_.DBF通道ORA_DISK_1:将外部文件22还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TTS_F76H65OF_.DBF通道ORA_DISK_1:将外部文件23还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_CS_F76H65OF_.DBF通道ORA_DISK_1:外部片段句柄=D:\app\oracle\oradata\tdb\db_transport_7tsq5l5g_1_1通道ORA_DISK_1:已还原备份片段1通道ORA_DISK_1:还原完成,用时:00:00:26通道ORA_DISK_1:正在开始还原数据文件备份集通道ORA_DISK_1:正在指定从备份集还原的数据文件通道ORA_DISK_1:正在还原备份片段中的所有外部文件通道ORA_DISK_1:正在读取备份片段D:\app\oracle\oradata\tdb\db_transport_7usq5l8p_1_1通道ORA_DISK_1:将外部文件17还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H70CR_.DBF通道ORA_DISK_1:将外部文件16还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H70CR_.DBF通道ORA_DISK_1:将外部文件18还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H70D8_.DBF通道ORA_DISK_1:将外部文件19还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H70D8_.DBF通道ORA_DISK_1:将外部文件21还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H70D8_.DBF通道ORA_DISK_1:将外部文件20还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H70D8_.DBF通道ORA_DISK_1:外部片段句柄=D:\app\oracle\oradata\tdb\db_transport_7usq5l8p_1_1通道ORA_DISK_1:已还原备份片段1通道ORA_DISK_1:还原完成,用时:00:00:16通道ORA_DISK_1:正在开始还原数据文件备份集通道ORA_DISK_1:正在指定从备份集还原的数据文件通道ORA_DISK_1:正在还原备份片段中的所有外部文件通道ORA_DISK_1:正在读取备份片段D:\app\oracle\oradata\tdb\db_transport_7vsq5lbf_1_1通道ORA_DISK_1:将外部文件6还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H7HXK_.DBF通道ORA_DISK_1:将外部文件5还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H7HXK_.DBF通道ORA_DISK_1:将外部文件8还原到D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H7HXK_.DBF通道ORA_DISK_1:外部片段句柄=D:\app\oracle\oradata\tdb\db_transport_7vsq5lbf_1_1通道ORA_DISK_1:已还原备份片段1通道ORA_DISK_1:还原完成,用时:00:00:16在02-2月-18完成了restore

11.在目标平台上使用备份的控制文件来为目标数据库创建控制文件，将备分的控制文件记录的源数据文件修改成还原后的数据文件名，其创建语句如下

CREATECONTROLFILEREUSEDATABASE"JY"RESETLOGSARCHIVELOGMAXLOGFILES192MAXLOGMEMBERS3MAXDATAFILES1024MAXINSTANCES32MAXLOGHISTORY292LOGFILEGROUP1'D:\APP\ORACLE\ORADATA\JY\DATAFILE\redo01.log'SIZE200M,GROUP2'D:\APP\ORACLE\ORADATA\JY\DATAFILE\redo02.log'SIZE200M--STANDBYLOGFILEDATAFILE'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_CS_F76H65OF_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H4FHX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H65NX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H70CR_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H7HXK_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H4FHX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H65NX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H70CR_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H7HXK_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H65NX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H70D8_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TTS_F76H65OF_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H4FHX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H65NX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H70D8_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H7HXK_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS2_F76H4FHX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H65NX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H70D8_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H4FJF_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H65NX_.DBF','D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H70D8_.DBF'CHARACTERSETZHS16GBK;

执行上面的创建语句

SQL>CREATECONTROLFILEREUSEDATABASE"JY"RESETLOGSARCHIVELOG2MAXLOGFILES1923MAXLOGMEMBERS34MAXDATAFILES10245MAXINSTANCES326MAXLOGHISTORY2927LOGFILE8GROUP1'D:\APP\ORACLE\ORADATA\JY\DATAFILE\redo01.log'SIZE200M,9GROUP2'D:\APP\ORACLE\ORADATA\JY\DATAFILE\redo02.log'SIZE200M10--STANDBYLOGFILE11DATAFILE12'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_CS_F76H65OF_.DBF',13'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H4FHX_.DBF',14'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H65NX_.DBF',15'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H70CR_.DBF',16'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H7HXK_.DBF',17'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H4FHX_.DBF',18'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H65NX_.DBF',19'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H70CR_.DBF',20'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H7HXK_.DBF',21'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H65NX_.DBF',22'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H70D8_.DBF',23'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TTS_F76H65OF_.DBF',24'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H4FHX_.DBF',25'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H65NX_.DBF',26'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H70D8_.DBF',27'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H7HXK_.DBF',28'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS2_F76H4FHX_.DBF',29'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H65NX_.DBF',30'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H70D8_.DBF',31'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H4FJF_.DBF',32'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H65NX_.DBF',33'D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H70D8_.DBF'34CHARACTERSETZHS16GBK35;控制文件已创建。SQL>selectnamefromv$datafile;NAME--------------------------------------------------------------------------------D:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H4FHX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H4FHX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H4FHX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H7HXK_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H7HXK_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H4FJF_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H7HXK_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS2_F76H4FHX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H65NX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H65NX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H65NX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H65NX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H65NX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H65NX_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSTEM_F76H70CR_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_SYSAUX_F76H70CR_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDOTBS1_F76H70D8_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_UNDO_2_F76H70D8_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_USERS_F76H70D8_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TEST_F76H70D8_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_TTS_F76H65OF_.DBFD:\APP\ORACLE\ORADATA\JY\DATAFILE\O1_MF_CS_F76H65OF_.DBF已选择22行。

12.以open resetlogs选项打开数据库

SQL>alterdatabaseopenresetlogs;数据库已更改。SQL>alterpluggabledatabaseallopenreadwrite;插接式数据库已变更。SQL>selectname,open_modefromv$pdbs;NAMEOPEN_MODE----------------------------------------------PDB$SEEDREADONLYJYPDBREADWRITETESTPDBREADWRITE

13.给CDB数据库增加临进表空间数据文件

SQL>altertablespacetempaddtempfile'D:\APP\ORACLE\ORADATA\JY\DATAFILE\temp01.dbf'size100Mreuseautoextendonnext655360maxsize200m;表空间已更改。SQL>altersessionsetcontainer=pdb$seed;会话已更改。SQL>altertablespacetempaddtempfile'D:\APP\ORACLE\ORADATA\JY\DATAFILE\temp02.dbf'size100Mreuseautoextendonnext655360maxsize200m;表空间已更改。SQL>altersessionsetcontainer=jypdb;会话已更改。SQL>altertablespacetempaddtempfile'D:\APP\ORACLE\ORADATA\JY\DATAFILE\temp03.dbf'size100Mreuse;表空间已更改。SQL>altersessionsetcontainer=testpdb;会话已更改。SQL>altertablespacetempaddtempfile'D:\APP\ORACLE\ORADATA\JY\DATAFILE\temp04.dbf'size100Mreuse;表空间已更改。SQL>altersessionsetcontainer=cdb$root;会话已更改。

到此，相信大家对“如何使用备份集跨平台传输整个CDB数据库”有了更深的了解，不妨来实际操作一番吧！这里是亿速云网站，更多相关内容可以进入相关频道进行查询，关注我们，继续学习！