基于时间不完全恢复之rman篇(三)
must be restored from backup created before 2013-07-31 22:36:51
RMAN> recover database until time '2013-07-31 22:34:51';--往前调是不认的
Starting recover at 2013-07-31 23:06:22
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/31/2013 23:06:22
RMAN-06555: datafile 1 must be restored from backup created before 2013-07-31 22:34:51
RMAN> recover database until time '2013-07-31 22:36:51';
Starting recover at 2013-07-31 23:08:36
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/31/2013 23:08:36
RMAN-06555: datafile 1 must be restored from backup created before 2013-07-31 22:36:51
RMAN> recover database until time '2013-07-31 22:46:51';--只有往后调时间点点才能恢复
Starting recover at 2013-07-31 23:09:31
using channel ORA_DISK_1
starting media recovery
media recovery complete, elapsed time: 00:00:03
Finished recover at 2013-07-31 23:09:34
RMAN> alter database open resetlogs;
database opened