Oracle 12C如何使用RMAN将Non-CDB中分表的多个分区恢复到新用户方案中

2025-03-12 技术教程

这篇文章主要介绍了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.在删除表sh.sales的SALES_Q3_1998与SALES_Q4_1998分区中的数据之前记录当前时间,在执行恢复时它们被用来指定恢复时间点

SQL>selectcount(*)fromsalespartition(SALES_Q3_1998);COUNT(*)----------505151rowselected.SQL>selectcount(*)fromsalespartition(SALES_Q4_1998);COUNT(*)----------488741rowselected.SQL>selectsysdatefromdual;SYSDATE-------------------2018-01-1103:11:061rowselected.SQL>selectcurrent_scnfromv$database;CURRENT_SCN-----------525382SQL>deletefromsalespartition(SALES_Q3_1998);50515rowsdeleted.SQL>deletefromsalespartition(SALES_Q4_1998);48874rowsdeleted.SQL>commit;Commitcomplete.SQL>selectcount(*)fromsalespartition(SALES_Q3_1998);COUNT(*)----------01rowselected.SQL>selectcount(*)fromsalespartition(SALES_Q4_1998);COUNT(*)----------01rowselected.

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子句将分区SH.SALES:SALES_Q3_1998恢复成表 JY.SALES_Q3_1998，分区SH.SALES:SALES_Q4_1998恢复成表JY.SALES_Q4_1998使用remap tablespace子句将sh用户方案中的表分区从user表空间恢复到usertbs表空间中

RMAN>run{2>3>recovertableSH.SALES:SALES_Q3_1998,SH.SALES:SALES_Q4_19984>untiltime'2018-01-1103:11:06'5>auxiliarydestination'/ora_xtts/recover'6>datapumpdestination'/ora_xtts/dump'7>dumpfile't_emp_recvr.dmp'8>remaptableSH.SALES:SALES_Q3_1998:JY.SALES_Q3_1998,SH.SALES:SALES_Q4_1998:JY.SALES_Q4_19989>remaptablespace'USERS':'USERTBS';10>}Startingrecoverat2018-01-1103:21:12usingchannelORA_DISK_1RMAN-05026:warning:presumingfollowingsetoftablespacesappliestospecifiedpoint-in-timeListoftablespacesexpectedtohaveUNDOsegmentsTablespaceSYSTEMTablespaceUNDOTBS1Creatingautomaticinstance,withSID='xDyx'initializationparametersusedforautomaticinstance:db_name=ORCLdb_unique_name=xDyx_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-1103:11:06";#restorethecontrolfilerestoreclonecontrolfile;#mountthecontrolfilesqlclone'alterdatabasemountclonedatabase';#archivecurrentonlinelogsql'altersystemarchivelogcurrent';}executingMemoryScriptexecutingcommand:SETuntilclauseStartingrestoreat2018-01-1103:22:20allocatedchannel: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_f5dszl5f_.ctlFinishedrestoreat2018-01-1103:22:27sqlstatement:alterdatabasemountclonedatabasesqlstatement:altersystemarchivelogcurrentcontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1103:11:06";#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-1103:22:34usingchannelORA_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-1103:23:20datafile1switchedtodatafilecopyinputdatafilecopyRECID=4STAMP=965100201filename=/ora_xtts/recover/ORCL/datafile/o1_mf_system_f5dszvs1_.dbfdatafile3switchedtodatafilecopyinputdatafilecopyRECID=5STAMP=965100201filename=/ora_xtts/recover/ORCL/datafile/o1_mf_undotbs1_f5dszvt5_.dbfdatafile2switchedtodatafilecopyinputdatafilecopyRECID=6STAMP=965100201filename=/ora_xtts/recover/ORCL/datafile/o1_mf_sysaux_f5dszvsm_.dbfcontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1103:11:06";#onlinethedatafilesrestoredorswitchedsqlclone"alterdatabasedatafile1online";sqlclone"alterdatabasedatafile3online";sqlclone"alterdatabasedatafile2online";#recoverandopendatabasereadonlyrecoverclonedatabasetablespace"SYSTEM","UNDOTBS1","SYSAUX";sqlclone'alterdatabaseopenreadonly';}executingMemoryScriptexecutingcommand:SETuntilclausesqlstatement:alterdatabasedatafile1onlinesqlstatement:alterdatabasedatafile3onlinesqlstatement:alterdatabasedatafile2onlineStartingrecoverat2018-01-1103:23:22usingchannelORA_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.dbfarchivedlogforthread1withsequence33isalreadyondiskasfile+DATA/arch/orcl/1_33_964992135.dbfarchivedlogforthread1withsequence34isalreadyondiskasfile+DATA/arch/orcl/1_34_964992135.dbfarchivedlogforthread1withsequence35isalreadyondiskasfile+DATA/arch/orcl/1_35_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=32archivedlogfilename=+DATA/arch/orcl/1_33_964992135.dbfthread=1sequence=33archivedlogfilename=+DATA/arch/orcl/1_34_964992135.dbfthread=1sequence=34archivedlogfilename=+DATA/arch/orcl/1_35_964992135.dbfthread=1sequence=35mediarecoverycomplete,elapsedtime:00:00:51Finishedrecoverat2018-01-1103:24:16sqlstatement:alterdatabaseopenreadonlycontentsofMemoryScript:{sqlclone"createspfilefrommemory";shutdowncloneimmediate;startupclonenomount;sqlclone"altersystemsetcontrol_files=''/ora_xtts/recover/ORCL/controlfile/o1_mf_f5dszl5f_.ctl''comment=''RMANset''scope=spfile";shutdowncloneimmediate;startupclonenomount;#mountdatabasesqlclone'alterdatabasemountclonedatabase';}executingMemoryScriptsqlstatement:createspfilefrommemorydatabasecloseddatabasedismountedOracleinstanceshutdownconnectedtoauxiliarydatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea1073741824bytesFixedSize8628936bytesVariableSize293602616bytesDatabaseBuffers763363328bytesRedoBuffers8146944bytessqlstatement:altersystemsetcontrol_files=''/ora_xtts/recover/ORCL/controlfile/o1_mf_f5dszl5f_.ctl''comment=''RMANset''scope=spfileOracleinstanceshutdownconnectedtoauxiliarydatabase(notstarted)OracleinstancestartedTotalSystemGlobalArea1073741824bytesFixedSize8628936bytesVariableSize293602616bytesDatabaseBuffers763363328bytesRedoBuffers8146944bytessqlstatement:alterdatabasemountclonedatabasecontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1103:11:06";#setdestinationsforrecoverysetandauxiliarysetdatafilessetnewnamefordatafile4tonew;#restorethetablespacesintherecoverysetandtheauxiliarysetrestoreclonedatafile4;switchclonedatafileall;}executingMemoryScriptexecutingcommand:SETuntilclauseexecutingcommand:SETNEWNAMEStartingrestoreat2018-01-1103:25:26allocatedchannel: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/XDYX_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:00:55Finishedrestoreat2018-01-1103:26:22datafile4switchedtodatafilecopyinputdatafilecopyRECID=8STAMP=965100383filename=/ora_xtts/recover/XDYX_PITR_ORCL/datafile/o1_mf_users_f5dt57w8_.dbfcontentsofMemoryScript:{#setrequestedpointintimesetuntiltime"2018-01-1103:11:06";#onlinethedatafilesrestoredorswitchedsqlclone"alterdatabasedatafile4online";#recoverandopenresetlogsrecoverclonedatabasetablespace"USERS","SYSTEM","UNDOTBS1","SYSAUX"deletearchivelog;alterclonedatabaseopenresetlogs;}executingMemoryScriptexecutingcommand:SETuntilclausesqlstatement:alterdatabasedatafile4onlineStartingrecoverat2018-01-1103:26:23usingchannelORA_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.dbfarchivedlogforthread1withsequence33isalreadyondiskasfile+DATA/arch/orcl/1_33_964992135.dbfarchivedlogforthread1withsequence34isalreadyondiskasfile+DATA/arch/orcl/1_34_964992135.dbfarchivedlogforthread1withsequence35isalreadyondiskasfile+DATA/arch/orcl/1_35_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=32archivedlogfilename=+DATA/arch/orcl/1_33_964992135.dbfthread=1sequence=33archivedlogfilename=+DATA/arch/orcl/1_34_964992135.dbfthread=1sequence=34archivedlogfilename=+DATA/arch/orcl/1_35_964992135.dbfthread=1sequence=35mediarecoverycomplete,elapsedtime:00:00:08Finishedrecoverat2018-01-1103:26:34databaseopenedcontentsofMemoryScript:{#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_xDyx_nniA":EXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLE_DATAEXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSEXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/MARKEREXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLEEXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANTEXPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/COMMENTEXPDP>..exported"SH"."SALES":"SALES_Q3_1998"1.634MB50515rowsEXPDP>..exported"SH"."SALES":"SALES_Q4_1998"1.581MB48874rowsEXPDP>Mastertable"SYS"."TSPITR_EXP_xDyx_nniA"successfullyloaded/unloadedEXPDP>******************************************************************************EXPDP>DumpfilesetforSYS.TSPITR_EXP_xDyx_nniAis:EXPDP>/ora_xtts/dump/t_emp_recvr.dmpEXPDP>Job"SYS"."TSPITR_EXP_xDyx_nniA"successfullycompletedatThuJan1103:27:332018elapsed000:00:39ExportcompletedcontentsofMemoryScript:{#shutdownclonebeforeimportshutdowncloneabort}executingMemoryScriptOracleinstanceshutdownPerformingimportoftables...IMPDP>Mastertable"SYS"."TSPITR_IMP_xDyx_xeDs"successfullyloaded/unloadedIMPDP>Starting"SYS"."TSPITR_IMP_xDyx_xeDs":IMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLEIMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/TABLE_DATAIMPDP>..imported"JY"."SALES_Q3_1998"1.634MB50515rowsIMPDP>..imported"JY"."SALES_Q4_1998"1.581MB48874rowsIMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANTIMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICSIMPDP>ProcessingobjecttypeTABLE_EXPORT/TABLE/STATISTICS/MARKERIMPDP>Job"SYS"."TSPITR_IMP_xDyx_xeDs"completedwith9error(s)atThuJan1103:28:182018elapsed000:00:36importcompletedwitherrors;OracleDataPumpdumpfilet_emp_recvr.dmpisretainedRemovingautomaticinstanceAutomaticinstanceremovedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_tempts1_f5dt3146_.tmpdeletedauxiliaryinstancefile/ora_xtts/recover/XDYX_PITR_ORCL/onlinelog/o1_mf_3_f5dt7brh_.logdeletedauxiliaryinstancefile/ora_xtts/recover/XDYX_PITR_ORCL/onlinelog/o1_mf_2_f5dt7bqr_.logdeletedauxiliaryinstancefile/ora_xtts/recover/XDYX_PITR_ORCL/onlinelog/o1_mf_1_f5dt7bq5_.logdeletedauxiliaryinstancefile/ora_xtts/recover/XDYX_PITR_ORCL/datafile/o1_mf_users_f5dt57w8_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_sysaux_f5dszvsm_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_undotbs1_f5dszvt5_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/datafile/o1_mf_system_f5dszvs1_.dbfdeletedauxiliaryinstancefile/ora_xtts/recover/ORCL/controlfile/o1_mf_f5dszl5f_.ctldeletedFinishedrecoverat2018-01-1103:28:22

5.验证是否分区SH.SALES:SALES_Q3_1998被恢复成表JY.SALES_Q3_1998，分区SH.SALES:SALES_Q4_1998被恢复成表JY.SALES_Q4_1998，从查询记录可以看到已经成功恢复

SQL>selectcount(*)fromJY.SALES_Q3_1998;COUNT(*)----------50515SQL>selectcount(*)fromJY.SALES_Q4_1998;COUNT(*)----------48874

感谢你能够认真阅读完这篇文章，希望小编分享的“Oracle 12C如何使用RMAN将Non-CDB中分表的多个分区恢复到新用户方案中”这篇文章对大家有帮助，同时也希望大家多多支持亿速云，关注亿速云行业资讯频道，更多相关知识等着你来学习!