RMAN如何恢复drop purge的表

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

@ORA12C>  alter session set nls_date_format='yyyy-mm-dd hh34:mi:ss';Session altered.SYS@ORA12C> create table  t_0920 as select * from dba_objects;Table created.SYS@ORA12C> select count(*) from t_0920;  COUNT(*)-----------------     916911 row selected.SYS@ORA12C> select sysdate from dual;SYSDATE-------------------2015-09-20 14:17:491 row selected.SYS@ORA12C> drop table t_0920 purge;Table dropped.SYS@ORA12C> desc t_0920;ERROR:ORA-04043: object t_0920 does not existSYS@ORA12C> create table t_09201 as select * from dba_objects;Table created.SYS@ORA12C> select count(*) from t_09201;  COUNT(*)-----------------     916911 row selected.SYS@ORA12C> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS@ORA12C> startup mount;ORACLE instance started.Total System Global Area  729808896 bytesFixed Size      2928680 bytesVariable Size    570429400 bytesDatabase Buffers   150994944 bytesRedo Buffers      5455872 bytesDatabase mounted.

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

run{sql "alter session set nls_date_format=''yyyy-mm-dd hh34:mi:ss''";set until time '2015-09-20 14:17:49';restore database;recover database;6> }using target database control file instead of recovery catalogsql statement: alter session set nls_date_format=''yyyy-mm-dd hh34:mi:ss''executing command: SET until clauseStarting restore at 20-SEP-15allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=355 device type=DISKcreating datafile file number=2 name=/u01/app/oracle/oradata/ORA12C/t2.dbfchannel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/ORA12C/system01.dbfchannel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORA12C/sysaux01.dbfchannel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ORA12C/undotbs01.dbfchannel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/oradata/ORA12C/example01.dbfchannel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/ORA12C/users01.dbfchannel ORA_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/ORA12C/backupset/2015_09_20/o1_mf_nnndf_TAG20150920T120820_bzwd9ntd_.bkpchannel ORA_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/ORA12C/backupset/2015_09_20/o1_mf_nnndf_TAG20150920T120820_bzwd9ntd_.bkp tag=TAG20150920T120820channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:01:56Finished restore at 20-SEP-15Starting recover at 20-SEP-15using channel ORA_DISK_1starting media recoveryarchived log for thread 1 with sequence 18 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_18_bzwh058r_.arcarchived log for thread 1 with sequence 19 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_19_bzwhh60d_.arcarchived log for thread 1 with sequence 20 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_20_bzwhzsts_.arcarchived log for thread 1 with sequence 1 is already on disk as file /u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_1_bzwmprks_.arcarchived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_18_bzwh058r_.arc thread=1 sequence=18archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_19_bzwhh60d_.arc thread=1 sequence=19archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_20_bzwhzsts_.arc thread=1 sequence=20archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_1_bzwm5k1c_.arc thread=1 sequence=1archived log file name=/u01/app/oracle/fast_recovery_area/ORA12C/archivelog/2015_09_20/o1_mf_1_1_bzwmprks_.arc thread=1 sequence=1media recovery complete, elapsed time: 00:00:07Finished recover at 20-SEP-15RMAN> alter database open resetlogs;Statement processed

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

SYS@ORA12C> select count(*) from t_0920;  COUNT(*)-----------------     916911 row selected.SYS@ORA12C> select count(*) from t_09201;select count(*) from t_09201                     *ERROR at line 1:ORA-00942: table or view does not exist

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