探索oracle不完全恢复之--基于时间恢复，基于时间的恢复将数据库恢复到备份点与失败点之间的某个时间点。基于时间的恢复不仅在介
基于时间（time）恢复
基于时间的恢复将数据库恢复到备份点与失败点之间的某个时间点。基于时间的恢复不仅在介质失败的时候使用，也可以在数据库正常运行的时候使用。例如：某个用户误删除了某个表的数据，这个时候我们可以通过基于时间的恢复来将删除的数据恢复出来，示例如下：
1、查看当前用户下的表，，只有一张wwl001
21:07:31 sql> select * from tab;
tname tabtype clusterid
------------------------------ -----------------
wwl001 table
elapsed: 00:00:00.06
我们通过wwl001来创建wwl002-wwl005 共四张表用来测试不完全恢复
21:08:28 sql> create table wwl002 asselect * from wwl001;
table created.
elapsed: 00:00:00.17
21:08:55 sql> create table wwl003 asselect * from wwl001;
table created.
elapsed: 00:00:00.04
21:09:00 sql> create table wwl004 asselect * from wwl001;
table created.
elapsed: 00:00:00.03
21:09:06 sql> create table wwl005 asselect * from wwl001;
table created.
elapsed: 00:00:00.05
如上表已经创建完成
2、我们在21:13:13开始删除表（请注意时间）
21:13:13 sql> drop table wwl002 purge;
table dropped.
elapsed: 00:00:00.16
21:13:28 sql> drop table wwl003 purge;
table dropped.
elapsed: 00:00:00.11
21:13:34 sql> truncate table wwl004;
table truncated.
elapsed: 00:00:00.32
21:13:44 sql> truncate table wwl005;
table truncated.
elapsed: 00:00:00.07
21:13:47 sql>
3、开始执行恢复，先将数据库启动到mount状态
21:14:40 sql> conn / as sysdba
connected.
21:14:44 sql> shutdown immediate
database closed.
database dismounted.
oracle instance shut down.
21:15:20 sql> startup mount;
oracle instance started.
total system global area 100663296 bytes
fixed size 1217884 bytes
variable size 88083108 bytes
database buffers 8388608 bytes
redo buffers 2973696 bytes
database mounted.
21:15:46 sql> e
4、开始执行restore到备份数据库的当前状态：
rman> restore database;
starting restore at 12-jul-12
using target database control file insteadof recovery catalog
allocated channel: ora_disk_1
channel ora_disk_1: sid=47 devtype=disk
channel ora_disk_1: starting datafilebackupset restore
channel ora_disk_1: specifying datafile(s)to restore from backup set
restoring datafile 00001 to/dbbak2/oradata/wwl/system01.dbf
restoring datafile 00002 to/dbbak2/oradata/wwl/undotbs01.dbf
restoring datafile 00003 to/dbbak2/oradata/wwl/sysaux01.dbf
restoring datafile 00004 to/dbbak2/oradata/wwl/users01.dbf
restoring datafile 00005 to/dbbak2/oradata/wwl/wwl01.dbf
restoring datafile 00006 to/dbbak2/oradata/wwl/wwl02.dbf
restoring datafile 00007 to/dbbak2/oradata/wwl/wwl03.dbf
channel ora_disk_1: reading from backuppiece /dbsoft/product/10.2.0/db_1/dbs/01nft4mu_1_1
channel ora_disk_1: restored backup piece1
piecehandle=/dbsoft/product/10.2.0/db_1/dbs/01nft4mu_1_1 tag=tag20120712t095437
channel ora_disk_1: restore complete,elapsed time: 00:01:35
finished restore at 12-jul-12
rman> exit
5、执行基于时间点的恢复：
21:27:54 sql> recover database untiltime ‘yyyy-mm-dd hh24:mi:ss’
21:27:54 sql> recover database untiltime '2012-07-12 21:10:00';
ora-00279: change 1436429 generated at07/12/2012 09:54:38 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_3_788372282.dbf
ora-00280: change 1436429 for thread 1 isin sequence #3
21:30:09 specify log:{=suggested | filename | auto | cancel}
auto
ora-00279: change 1440657 generated at 07/12/201214:00:52 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_1_788450452.dbf
ora-00280: change 1440657 for thread 1 isin sequence #1
ora-00279: change 1440855 generated at07/12/2012 15:08:58 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_1_788454538.dbf
ora-00280: change 1440855 for thread 1 isin sequence #1
ora-00279: change 1441316 generated at07/12/2012 15:19:50 needed for thread 1
ora-00289: suggestion : /dbsoft/product/10.2.0/db_1/dbs/arch1_1_788455190.dbf
ora-00280: change 1441316 for thread 1 isin sequence #1
ora-00279: change 1442275 generated at07/12/2012 15:52:01 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_1_788457121.dbf
ora-00280: change 1442275 for thread 1 isin sequence #1
ora-00279: change 1442953 generated at07/12/2012 16:25:06 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_1_788459106.dbf
ora-00280: change 1442953 for thread 1 is insequence #1
ora-00279: change 1462958 generated at07/12/2012 16:28:16 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_2_788459106.dbf
ora-00280: change 1462958 for thread 1 isin sequence #2
ora-00278: log file '/dbsoft/product/10.2.0/db_1/dbs/arch1_1_788459106.dbf'no longer needed for this recovery
ora-00279: change 1462963 generated at07/12/2012 17:17:59 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_1_788462279.dbf
ora-00280: change 1462963 for thread 1 isin sequence #1
ora-00279: change 1483784 generated at07/12/2012 17:54:25 needed for thread 1
ora-00289: suggestion :/dbsoft/product/10.2.0/db_1/dbs/arch1_2_788462279.dbf
ora-00280: change 1483784 for thread 1 isin sequence #2
ora-00278: log file'/dbsoft/product/10.2.0/db_1/dbs/arch1_1_788462279.dbf' no longer needed forthis recovery
log applied.
media recovery complete.
21:30:29 sql>
至此已经恢复完成。
6、因为做了不完全恢复，必须要做restlogs打开数据库。
21:30:29 sql> alter database open restlogs;
alter database open restlogs
7、数据已经恢复完成，数据都回来了。
21:34:04 sql> select * from wwl002;
id name
-------------------------------------------------------
1 wwl
2 prodence
3 woo
4 xgx
5 cms
elapsed: 00:00:00.01
21:34:16 sql> select * from wwl003;
id name
-------------------------------------------------------
1 wwl
2 prodence
3 woo
4 xgx
5 cms
elapsed: 00:00:00.00
21:34:18 sql> select * from wwl004;
id name
-------------------------------------------------------
1 wwl
2 prodence
3 woo
4 xgx
5 cms
elapsed: 00:00:00.01
21:34:20 sql> select * from wwl005;
id name
---------- ---------------------------------------------
1 wwl
2 prodence
3 woo
4 xgx
5 cms
elapsed: 00:00:00.01
21:34:22 sql>
相关阅读：
探索oracle之rman_01概念
探索oracle之rman_02基本使用
探索oracle之rman_03非一致性备份
探索oracle之rman_04非一致性备份
探索oracle之rman_05增量备份
探索oracle之rman_06备份策略
探索oracle之rman_07单个数文件丢失恢复
探索oracle之rman_07整个业务表空间丢失恢复
探索oracle之rman_07 磁盘损坏数据丢失恢复
探索oracle之rman_07 数据库所有文件全部丢失恢复
探索oracle之rman_07 重做日志redu文件丢失恢复
探索oracle之rman_07 参数文件丢失恢复
探索oracle之rman_07控制文件丢失恢复
探索oracle之rman_07 system表空间丢失恢复