这篇文章主要介绍Oracle 12C如何使用RMAN将Non-CDB多个用户方案中的多个表或表分区恢复到新用户方案中，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

Oracle 12C使用RMAN将Non-CDB中多个用户方案中的多个表或表分区恢复到新用户方案中的操作如下
1.对整个Non-CDB(orcl)生成RMAN备份

RMAN>backupascompressedbackupsetdatabaseformat'+data/backup/%d_%I_%U_%t'plusarchivelogformat'arc_%d_%T_%U';Startingbackupat10-JAN-18currentlogarchivedusingchannelORA_DISK_1channelORA_DISK_1:startingcompressedarchivedlogbackupsetchannelORA_DISK_1:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=1sequence=13RECID=1STAMP=964995986inputarchivedlogthread=1sequence=14RECID=2STAMP=965007422inputarchivedlogthread=1sequence=15RECID=3STAMP=965007493inputarchivedlogthread=1sequence=16RECID=4STAMP=965007542inputarchivedlogthread=1sequence=17RECID=5STAMP=965011311inputarchivedlogthread=1sequence=18RECID=6STAMP=965011687channelORA_DISK_1:startingpiece1at10-JAN-18channelORA_DISK_1:finishedpiece1at10-JAN-18piecehandle=/u01/app/oracle/product/12.2.0/db/dbs/arc_ORCL_20180110_21so9q78_1_1tag=TAG20180110T024807comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:15Finishedbackupat10-JAN-18Startingbackupat10-JAN-18usingchannelORA_DISK_1channelORA_DISK_1:startingcompressedfulldatafilebackupsetchannelORA_DISK_1:specifyingdatafile(s)inbackupsetinputdatafilefilenumber=00004name=+DATA/orcl/datafile/users01.dbfinputdatafilefilenumber=00001name=+DATA/orcl/datafile/system01.dbfinputdatafilefilenumber=00002name=+DATA/orcl/datafile/sysaux01.dbfinputdatafilefilenumber=00003name=+DATA/orcl/datafile/undotbs01.dbfinputdatafilefilenumber=00005name=+DATA/orcl/datafile/usertbs01.dbfchannelORA_DISK_1:startingpiece1at10-JAN-18channelORA_DISK_1:finishedpiece1at10-JAN-18piecehandle=+DATA/backup/orcl_1492772871_22so9q7p_1_1_965011705tag=TAG20180110T024824comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:45Finishedbackupat10-JAN-18Startingbackupat10-JAN-18currentlogarchivedusingchannelORA_DISK_1channelORA_DISK_1:startingcompressedarchivedlogbackupsetchannelORA_DISK_1:specifyingarchivedlog(s)inbackupsetinputarchivedlogthread=1sequence=19RECID=7STAMP=965011751channelORA_DISK_1:startingpiece1at10-JAN-18channelORA_DISK_1:finishedpiece1at10-JAN-18piecehandle=/u01/app/oracle/product/12.2.0/db/dbs/arc_ORCL_20180110_23so9q98_1_1tag=TAG20180110T024912comment=NONEchannelORA_DISK_1:backupsetcomplete,elapsedtime:00:00:01Finishedbackupat10-JAN-18StartingControlFileandSPFILEAutobackupat10-JAN-18piecehandle=+DATA/backup/c-1492772871-20180110-01comment=NONEFinishedControlFileandSPFILEAutobackupat10-JAN-18

2.在删除表t_emp之前记录当前时间,在执行恢复时它们被用来指定恢复时间点

SQL>selectcount(*)fromcs.t1;COUNT(*)----------8SQL>selectcount(*)fromhr.t1;COUNT(*)----------81rowselected.SQL>selectsysdatefromdual;SYSDATE-------------------2018-01-1022:56:161rowselected.SQL>truncatetablecs.t1;Tabletruncated.SQL>truncatetablehr.t1;Tabletruncated.SQL>selectcount(*)fromcs.t1;COUNT(*)----------0SQL>selectcount(*)fromhr.t1;COUNT(*)----------0

3.启动RMAN并使用有sysbacup或sysdba权限的用户连接到目标数据库

[oracle@jytest3~]$exportNLS_DATE_FORMAT='yyyy-mm-ddhh34:mi:ss'[oracle@jytest3~]$rmantarget/RecoveryManager:Release12.2.0.1.0-ProductiononWedJan1002:22:132018Copyright(c)1982,2017,Oracleand/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:ORCL(DBID=1492772871)

4.通过使用recover table命令将要被恢复的表或表分区恢复到指定的时间点。 使用auxiliary destination子句（/ora_xtts/recover辅助数据文件存储目录)与until scn来指定恢复时间点,并且在recover命令中使用子句 dump file与datapump destination，指定包含被恢复表或表分区的导出dump文件的文件名(t_emp_recvr.dmp)与存储位置(/ora_xtts/dump)。 使用remap table子句将hr.t1恢复成jy.t1_1,cs.t1恢复成jy.t1_2。使用remap tablespace子句将hr与cs用户方案中的表t1从恢复到jy用户方案中

RMAN>run2>{3>recovertablehr.t1,cs.t14>untiltime'2018-01-1022:55:39'5>auxiliarydestination'/ora_xtts/recover'6>datapumpdestination'/ora_xtts/dump'7>dumpfile't_emp_recvr.dmp'8>remaptable'HR'.'T1':'JY'.'T1_1','CS'.'T1':'JY'.'T1_2'9>remaptablespace'USERS':'USERTBS';10>}Startingrecoverat2018-01-1023:26:43currentlogarchivedusingchannelORA_DISK_1RMAN-05026:warning:presumingfollowingsetoftablespacesappliestospecifiedpoint-in-timeListoftablespacesexpectedtohaveUNDOsegmentsTablespaceSYSTEMTablespaceUNDOTBS1Creatingautomaticinstance,withSID='fvtm'initializationparametersusedforautomaticinstance:db_name=ORCLdb_unique_name=fvtm_pitr_ORCLcompatible=12.2.0db_block_size=8192db_files=200diagnostic_dest=/u01/app/oracle_system_trig_enabled=FALSEsga_target=1024Mprocesses=120db_create_file_dest=/ora_xtts/recoverlog_archive_dest_1='location=/ora_xtts/recover'#NoauxiliaryparameterfileusedstartingupautomaticinstanceORCLOracleinstancestartedTotalSystemGlobalArea1073741824bytesFixedSize8628936bytesVariableSize293602616bytesDatabaseBuffers763363328bytesRedoBuffers8146944bytesAutomaticinstancecreatedcontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1022:55:39";#restorethecontrolfilerestoreclonecontrolfile;#mountthecontrolfilesqlclone'alterdatabasemountclonedatabase';#archivecurrentonlinelogsql'altersystemarchivelogcurrent';}executingMemoryScriptexecutingcommand:SETuntilclauseStartingrestoreat2018-01-1023:27:59allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=6devicetype=DISKchannelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:restoringcontrolfilechannelORA_AUX_DISK_1:readingfrombackuppiece+DATA/backup/c-1492772871-20180110-02channelORA_AUX_DISK_1:piecehandle=+DATA/backup/c-1492772871-20180110-02tag=TAG20180110T200959channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:05outputfilename=/ora_xtts/recover/ORCL/controlfile/o1_mf_f5dd84jp_.ctlFinishedrestoreat2018-01-1023:28:05sqlstatement:alterdatabasemountclonedatabasesqlstatement:altersystemarchivelogcurrentcontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1022:55:39";#setdestinationsforrecoverysetandauxiliarysetdatafilessetnewnameforclonedatafile1tonew;setnewnameforclonedatafile3tonew;setnewnameforclonedatafile2tonew;setnewnameforclonetempfile1tonew;#switchalltempfilesswitchclonetempfileall;#restorethetablespacesintherecoverysetandtheauxiliarysetrestoreclonedatafile1,3,2;switchclonedatafileall;}executingMemoryScriptexecutingcommand:SETuntilclauseexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMEexecutingcommand:SETNEWNAMErenamedtempfile1to/ora_xtts/recover/ORCL/datafile/o1_mf_tempts1_%u_.tmpincontrolfileStartingrestoreat2018-01-1023:28:15usingchannelORA_AUX_DISK_1channelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00001to/ora_xtts/recover/ORCL/datafile/o1_mf_system_%u_.dbfchannelORA_AUX_DISK_1:restoringdatafile00003to/ora_xtts/recover/ORCL/datafile/o1_mf_undotbs1_%u_.dbfchannelORA_AUX_DISK_1:restoringdatafile00002to/ora_xtts/recover/ORCL/datafile/o1_mf_sysaux_%u_.dbfchannelORA_AUX_DISK_1:readingfrombackuppiece+DATA/backup/orcl_1492772871_26sobn77_1_1_965074151channelORA_AUX_DISK_1:piecehandle=+DATA/backup/orcl_1492772871_26sobn77_1_1_965074151tag=TAG20180110T200911channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:45Finishedrestoreat2018-01-1023:29:02datafile1switchedtodatafilecopyinputdatafilecopyRECID=4STAMP=965086142filename=/ora_xtts/recover/ORCL/datafile/o1_mf_system_f5dd8k64_.dbfdatafile3switchedtodatafilecopyinputdatafilecopyRECID=5STAMP=965086142filename=/ora_xtts/recover/ORCL/datafile/o1_mf_undotbs1_f5dd8k8j_.dbfdatafile2switchedtodatafilecopyinputdatafilecopyRECID=6STAMP=965086142filename=/ora_xtts/recover/ORCL/datafile/o1_mf_sysaux_f5dd8k7d_.dbfcontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1022:55:39";#onlinethedatafilesrestoredorswitchedsqlclone"alterdatabasedatafile1online";sqlclone"alterdatabasedatafile3online";sqlclone"alterdatabasedatafile2online";#recoverandopendatabasereadonlyrecoverclonedatabasetablespace"SYSTEM","UNDOTBS1","SYSAUX";sqlclone'alterdatabaseopenreadonly';}executingMemoryScriptexecutingcommand:SETuntilclausesqlstatement:alterdatabasedatafile1onlinesqlstatement:alterdatabasedatafile3onlinesqlstatement:alterdatabasedatafile2onlineStartingrecoverat2018-01-1023:29:03usingchannelORA_AUX_DISK_1startingmediarecoveryarchivedlogforthread1withsequence24isalreadyondiskasfile+DATA/arch/orcl/1_24_964992135.dbfarchivedlogforthread1withsequence25isalreadyondiskasfile+DATA/arch/orcl/1_25_964992135.dbfarchivedlogforthread1withsequence26isalreadyondiskasfile+DATA/arch/orcl/1_26_964992135.dbfarchivedlogforthread1withsequence27isalreadyondiskasfile+DATA/arch/orcl/1_27_964992135.dbfarchivedlogforthread1withsequence28isalreadyondiskasfile+DATA/arch/orcl/1_28_964992135.dbfarchivedlogforthread1withsequence29isalreadyondiskasfile+DATA/arch/orcl/1_29_964992135.dbfarchivedlogforthread1withsequence30isalreadyondiskasfile+DATA/arch/orcl/1_30_964992135.dbfarchivedlogforthread1withsequence31isalreadyondiskasfile+DATA/arch/orcl/1_31_964992135.dbfarchivedlogforthread1withsequence32isalreadyondiskasfile+DATA/arch/orcl/1_32_964992135.dbfarchivedlogfilename=+DATA/arch/orcl/1_24_964992135.dbfthread=1sequence=24archivedlogfilename=+DATA/arch/orcl/1_25_964992135.dbfthread=1sequence=25archivedlogfilename=+DATA/arch/orcl/1_26_964992135.dbfthread=1sequence=26archivedlogfilename=+DATA/arch/orcl/1_27_964992135.dbfthread=1sequence=27archivedlogfilename=+DATA/arch/orcl/1_28_964992135.dbfthread=1sequence=28archivedlogfilename=+DATA/arch/orcl/1_29_964992135.dbfthread=1sequence=29archivedlogfilename=+DATA/arch/orcl/1_30_964992135.dbfthread=1sequence=30archivedlogfilename=+DATA/arch/orcl/1_31_964992135.dbfthread=1sequence=31archivedlogfilename=+DATA/arch/orcl/1_32_964992135.dbfthread=1sequence=32mediarecoverycomplete,elapsedtime:00:00:34Finishedrecoverat2018-01-1023:29:40sqlstatement:alterdatabaseopenreadonlycontentsofMemoryScript:{sqlclone"createspfilefrommemory";shutdowncloneimmediate;startupclonenomount;sqlclone"altersystemsetcontrol_files=''/ora_xtts/recover/ORCL/controlfile/o1_mf_f5dd84jp_.ctl''comment=''RMANset''scope=spfile";shutdowncloneimmediate;startupclonenomount;#mountdatabasesqlclone'alterdatabasemountclonedatabase';}executingMemoryScriptsqlstatement:createspfilefrommemorydatabasecloseddatabasedismountedOracleinstanceshutdownconnectedtoauxiliarydatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea1073741824bytesFixedSize8628936bytesVariableSize293602616bytesDatabaseBuffers763363328bytesRedoBuffers8146944bytessqlstatement:altersystemsetcontrol_files=''/ora_xtts/recover/ORCL/controlfile/o1_mf_f5dd84jp_.ctl''comment=''RMANset''scope=spfileOracleinstanceshutdownconnectedtoauxiliarydatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea1073741824bytesFixedSize8628936bytesVariableSize293602616bytesDatabaseBuffers763363328bytesRedoBuffers8146944bytessqlstatement:alterdatabasemountclonedatabasecontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1022:55:39";#setdestinationsforrecoverysetandauxiliarysetdatafilessetnewnamefordatafile4tonew;#restorethetablespacesintherecoverysetandtheauxiliarysetrestoreclonedatafile4;switchclonedatafileall;}executingMemoryScriptexecutingcommand:SETuntilclauseexecutingcommand:SETNEWNAMEStartingrestoreat2018-01-1023:30:43allocatedchannel:ORA_AUX_DISK_1channelORA_AUX_DISK_1:SID=7devicetype=DISKchannelORA_AUX_DISK_1:startingdatafilebackupsetrestorechannelORA_AUX_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_AUX_DISK_1:restoringdatafile00004to/ora_xtts/recover/FVTM_PITR_ORCL/datafile/o1_mf_users_%u_.dbfchannelORA_AUX_DISK_1:readingfrombackuppiece+DATA/backup/orcl_1492772871_26sobn77_1_1_965074151channelORA_AUX_DISK_1:piecehandle=+DATA/backup/orcl_1492772871_26sobn77_1_1_965074151tag=TAG20180110T200911channelORA_AUX_DISK_1:restoredbackuppiece1channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:01:05Finishedrestoreat2018-01-1023:31:50datafile4switchedtodatafilecopyinputdatafilecopyRECID=8STAMP=965086310filename=/ora_xtts/recover/FVTM_PITR_ORCL/datafile/o1_mf_users_f5ddf560_.dbfcontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1022:55:39";#onlinethedatafilesrestoredorswitchedsqlclone"alterdatabasedatafile4online";#recoverandopenresetlogsrecoverclonedatabasetablespace"USERS","SYSTEM","UNDOTBS1","SYSAUX"deletearchivelog;alterclonedatabaseopenresetlogs;}executingMemoryScriptexecutingcommand:SETuntilclausesqlstatement:alterdatabasedatafile4onlineStartingrecoverat2018-01-1023:31:50usingchannelORA_AUX_DISK_1startingmediarecoveryarchivedlogforthread1withsequence24isalreadyondiskasfile+DATA/arch/orcl/1_24_964992135.dbfarchivedlogforthread1withsequence25isalreadyondiskasfile+DATA/arch/orcl/1_25_964992135.dbfarchivedlogforthread1withsequence26isalreadyondiskasfile+DATA/arch/orcl/1_26_964992135.dbfarchivedlogforthread1withsequence27isalreadyondiskasfile+DATA/arch/orcl/1_27_964992135.dbfarchivedlogforthread1withsequence28isalreadyondiskasfile+DATA/arch/orcl/1_28_964992135.dbfarchivedlogforthread1withsequence29isalreadyondiskasfile+DATA/arch/orcl/1_29_964992135.dbfarchivedlogforthread1withsequence30isalreadyondiskasfile+DATA/arch/orcl/1_30_964992135.dbfarchivedlogforthread1withsequence31isalreadyondiskasfile+DATA/arch/orcl/1_31_964992135.dbfarchivedlogforthread1withsequence32isalreadyondiskasfile+DATA/arch/orcl/1_32_964992135.dbfarchivedlogfilename=+DATA/arch/orcl/1_24_964992135.dbfthread=1sequence=24archivedlogfilename=+DATA/arch/orcl/1_25_964992135.dbfthread=1sequence=25archivedlogfilename=+DATA/arch/orcl/1_26_964992135.dbfthread=1sequence=26archivedlogfilename=+DATA/arch/orcl/1_27_964992135.dbfthread=1sequence=27archivedlogfilename=+DATA/arch/orcl/1_28_964992135.dbfthread=1sequence=28archivedlogfilename=+DATA/arch/orcl/1_29_964992135.dbfthread=1sequence=29archivedlogfilename=+DATA/arch/orcl/1_30_964992135.dbfthread=1sequence=30archivedlogfilename=+DATA/arch/orcl/1_31_964992135.dbfthread=1sequence=31archivedlogfilename=+DATA/arch/orcl/1_32_964992135.dbfthread=1sequence=32mediarecoverycomplete,elapsedtime:00:00:05Finishedrecoverat2018-01-1023:31:58databaseopenedcontentsofMemoryScript:{#createdirectoryfordatapumpimportsql"createorreplacedirectoryTSPITR_DIROBJ_DPDIRas''/ora_xtts/dump''";#createdirectoryfordatapumpexportsqlclone"createorreplacedirectoryTSPITR_DIROBJ_DPDIRas''/ora_xtts/dump''";}executingMemoryScriptsqlstatement:createorreplacedirectoryTSPITR_DIROBJ_DPDIRas''/ora_xtts/dump''sqlstatement:createorreplacedirectoryTSPITR_DIROBJ_DPDIRas''/ora_xtts/dump''Performingexportoftables...EXPDP>Starting"SYS"."TSPITR_EXP_fvtm_ikCg":EXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLE_DATAEXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSEXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/MARKEREXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLEEXPDP>..exported"CS"."T1"39.66KB8rowsEXPDP>..exported"HR"."T1"39.66KB8rowsEXPDP>Mastertable"SYS"."TSPITR_EXP_fvtm_ikCg"successfullyloaded/unloadedEXPDP>******************************************************************************EXPDP>DumpfilesetforSYS.TSPITR_EXP_fvtm_ikCgis:EXPDP>/ora_xtts/dump/t_emp_recvr.dmpEXPDP>Job"SYS"."TSPITR_EXP_fvtm_ikCg"successfullycompletedatWedJan1023:32:532018elapsed000:00:34ExportcompletedcontentsofMemoryScript:{#shutdownclonebeforeimportshutdowncloneabort}executingMemoryScriptOracleinstanceshutdownPerformingimportoftables...IMPDP>Mastertable"SYS"."TSPITR_IMP_fvtm_Dybh"successfullyloaded/unloadedIMPDP>Starting"SYS"."TSPITR_IMP_fvtm_Dybh":IMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLEIMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLE_DATAIMPDP>..imported"JY"."T1_2"39.66KB8rowsIMPDP>..imported"JY"."T1_1"39.66KB8rowsIMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSIMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/MARKERIMPDP>Job"SYS"."TSPITR_IMP_fvtm_Dybh"successfullycompletedatWedJan1023:33:322018elapsed000:00:30ImportcompletedRemovingautomaticinstanceAutomaticinstanceremovedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_tempts1_f5ddc523_.tmpdeletedauxiliaryinstancefile/ora_xtts/recover/FVTM_PITR_ORCL/onlinelog/o1_mf_3_f5ddhgrn_.logdeletedauxiliaryinstancefile/ora_xtts/recover/FVTM_PITR_ORCL/onlinelog/o1_mf_2_f5ddhgqw_.logdeletedauxiliaryinstancefile/ora_xtts/recover/FVTM_PITR_ORCL/onlinelog/o1_mf_1_f5ddhgq8_.logdeletedauxiliaryinstancefile/ora_xtts/recover/FVTM_PITR_ORCL/datafile/o1_mf_users_f5ddf560_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_sysaux_f5dd8k7d_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_undotbs1_f5dd8k8j_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_system_f5dd8k64_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/controlfile/o1_mf_f5dd84jp_.ctldeletedauxiliaryinstancefilet_emp_recvr.dmpdeletedFinishedrecoverat2018-01-1023:33:36

5.验证表hr.t1,cs.t1的数据是否成功恢复到表jy.t1_1,jy_t1_2中，从查询记录可以看到已经成功恢复。

SQL>selectcount(*)fromjy.t1_1;COUNT(*)----------8SQL>selectcount(*)fromjy.t1_2;COUNT(*)----------8

以上是“Oracle 12C如何使用RMAN将Non-CDB多个用户方案中的多个表或表分区恢复到新用户方案中”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！