这篇文章主要介绍RMAN如何恢复drop purge的表，文中介绍的非常详细，具有一定的参考价值，感兴趣的小伙伴们一定要看完！

@ORA12C>altersessionsetnls_date_format='yyyy-mm-ddhh34:mi:ss';Sessionaltered.SYS@ORA12C>createtablet_0920asselect*fromdba_objects;Tablecreated.SYS@ORA12C>selectcount(*)fromt_0920;COUNT(*)-----------------916911rowselected.SYS@ORA12C>selectsysdatefromdual;SYSDATE-------------------2015-09-2014:17:491rowselected.SYS@ORA12C>droptablet_0920purge;Tabledropped.SYS@ORA12C>desct_0920;ERROR:ORA-04043:objectt_0920doesnotexistSYS@ORA12C>createtablet_09201asselect*fromdba_objects;Tablecreated.SYS@ORA12C>selectcount(*)fromt_09201;COUNT(*)-----------------916911rowselected.SYS@ORA12C>shutdownimmediate;Databaseclosed.Databasedismounted.ORACLEinstanceshutdown.SYS@ORA12C>startupmount;ORACLEinstancestarted.TotalSystemGlobalArea729808896bytesFixedSize2928680bytesVariableSize570429400bytesDatabaseBuffers150994944bytesRedoBuffers5455872bytesDatabasemounted.

现在需要把t_0920表恢复过来：

run{sql"altersessionsetnls_date_format=''yyyy-mm-ddhh34:mi:ss''";setuntiltime'2015-09-2014:17:49';restoredatabase;recoverdatabase;6>}usingtargetdatabasecontrolfileinsteadofrecoverycatalogsqlstatement:altersessionsetnls_date_format=''yyyy-mm-ddhh34:mi:ss''executingcommand:SETuntilclauseStartingrestoreat20-SEP-15allocatedchannel:ORA_DISK_1channelORA_DISK_1:SID=355devicetype=DISKcreatingdatafilefilenumber=2name=/u01/app/oracle/oradata/ORA12C/t2.dbfchannelORA_DISK_1:startingdatafilebackupsetrestorechannelORA_DISK_1:specifyingdatafile(s)torestorefrombackupsetchannelORA_DISK_1:restoringdatafile00001to/u01/app/oracle/oradata/ORA12C/system01.dbfchannelORA_DISK_1:restoringdatafile00003to/u01/app/oracle/oradata/ORA12C/sysaux01.dbfchannelORA_DISK_1:restoringdatafile00004to/u01/app/oracle/oradata/ORA12C/undotbs01.dbfchannelORA_DISK_1:restoringdatafile00005to/u01/app/oracle/oradata/ORA12C/example01.dbfchannelORA_DISK_1:restoringdatafile00006to/u01/app/oracle/oradata/ORA12C/users01.dbfchannelORA_DISK_1:readingfrombackuppiece/u01/app/oracle/fast_recovery_area/ORA12C/backupset/2015_09_20/o1_mf_nnndf_TAG20150920T120820_bzwd9ntd_.bkpchannelORA_DISK_1:piecehandle=/u01/app/oracle/fast_recovery_area/ORA12C/backupset/2015_09_20/o1_mf_nnndf_TAG20150920T120820_bzwd9ntd_.bkptag=TAG20150920T120820channelORA_DISK_1:restoredbackuppiece1channelORA_DISK_1:restorecomplete,elapsedtime:00:01:56Finishedrestoreat20-SEP-15Startingrecoverat20-SEP-15usingchannelORA_DISK_1startingmediarecoveryarchivedlogforthread1withsequence18isalreadyondiskasfile/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_18_bzwh058r_.arcarchivedlogforthread1withsequence19isalreadyondiskasfile/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_19_bzwhh60d_.arcarchivedlogforthread1withsequence20isalreadyondiskasfile/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_20_bzwhzsts_.arcarchivedlogforthread1withsequence1isalreadyondiskasfile/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_1_bzwmprks_.arcarchivedlogfilename=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_18_bzwh058r_.arcthread=1sequence=18archivedlogfilename=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_19_bzwhh60d_.arcthread=1sequence=19archivedlogfilename=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_20_bzwhzsts_.arcthread=1sequence=20archivedlogfilename=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_1_bzwm5k1c_.arcthread=1sequence=1archivedlogfilename=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_1_bzwmprks_.arcthread=1sequence=1mediarecoverycomplete,elapsedtime:00:00:07Finishedrecoverat20-SEP-15RMAN>alterdatabaseopenresetlogs;Statementprocessed

验证：t_0920 表已经恢复了，t_09201表不存在了。

SYS@ORA12C>selectcount(*)fromt_0920;COUNT(*)-----------------916911rowselected.SYS@ORA12C>selectcount(*)fromt_09201;selectcount(*)fromt_09201*ERRORatline1:ORA-00942:tableorviewdoesnotexist

以上是“RMAN如何恢复drop purge的表”这篇文章的所有内容，感谢各位的阅读！希望分享的内容对大家有帮助，更多相关知识，欢迎关注亿速云行业资讯频道！