我先是用rman恢复
restore database;
recover database until time '2008-06-22 20:00:00';

执行成功

alter database open resetlogs;

执行成功

然后做了些事务操作

接着打算回复到时简点'2008-06-22 20:00:00'

再执行
restore database;


RMAN> recover database until time '2008-06-22 20:00:00';

Starting recover at 2008-06-23 12:13:04
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/23/2008 12:13:04
RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

请问如何回复数据库呀？

你的库是9I？
提示的已经很清楚了，不能RECOVER 到你RESETLOGS之前的时间点。

是oracle 10g
那请问如何把数据库恢复到能open呢？

RMAN> shutdown immediate;

database dismounted
Oracle instance shut down

RMAN> startup nomount

connected to target database (not started)
Oracle instance started

Total System Global Area     167772160 bytes

Fixed Size                     1260672 bytes
Variable Size                150995840 bytes
Database Buffers               8388608 bytes
Redo Buffers                   7127040 bytes

RMAN> alter database mount
2> ;

database mounted
released channel: ORA_DISK_1

RMAN> reset database to incarnation 2 ;


RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORCL     1168992346       PARENT  1          2006-11-16 18:40:24
2       2       ORCL     1168992346       CURRENT 456954     2007-12-13 10:20:12
3       3       ORCL     1168992346       ORPHAN  3326890    2008-06-23 11:07:57

RMAN> RESTORE DATABASE UNTIL SCN 3326890
2> ;

Starting restore at 2008-06-23 12:27:19
using channel ORA_DISK_1

skipping datafile 1; already restored to file /u/app/oracle/oradata/orcl/systemf
skipping datafile 2; already restored to file /u/app/oracle/oradata/orcl/undotbf
skipping datafile 3; already restored to file /u/app/oracle/oradata/orcl/sysauxf
skipping datafile 4; already restored to file /u/app/oracle/oradata/orcl/users0f
restore not done; all files readonly, offline, or already restored
Finished restore at 2008-06-23 12:27:19

RMAN> alter database open resetlogs;

database opened

RMAN> list incarnation;
List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORCL     1168992346       PARENT  1          2006-11-16 18:40:24
2       2       ORCL     1168992346       PARENT  456954     2007-12-13 10:20:12
4       4       ORCL     1168992346       CURRENT 3326784    2008-06-23 12:27:43
3       3       ORCL     1168992346       ORPHAN  3326890    2008-06-23 11:07:57


至此数据库恢复到较早前一个时间点。

关于这个，你要首先理解incarnation(对应物)的概念

使用RMAN可以进行穿越 resetlogs的恢复，即可以恢复到前一个对应物。

可以看看我的笔记：

[ Oracle备份与恢复总结] 4. RMAN_备份与恢复管理器