oracle全库基于时间点的恢复,使用RMAN进行基于时间点的不完全恢复

[oracle@stat ~]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'

[oracle@stat ~]$ rman target /

Recovery Manager: Release 10.2.0.2.0 - Production on Thu Sep 14 22:50:22 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: order (DBID=1341966532, not open)

RMAN> recover database until time '2006-09-14 19:00:00'

2> ;

Starting recover at 2006-09-14 22:50:26

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=544 devtype=DISK

starting media recovery

archive log thread 1 sequence 303 is already on disk as file

/oradata/archive/1_303_592917188.dbf

archive log thread 1 sequence 304 is already on disk as file

/oradata/archive/1_304_592917188.dbf

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=299

channel ORA_DISK_1: reading from backup piece /data3/ordrbak/arch_order_20060913_171

channel ORA_DISK_1: restored backup piece 1

piece handle=/data3/ordrbak/orderarch_order_20060913_171 tag=order

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

archive log filename=/oradata/archive/1_299_592917188.dbf thread=1 sequence=299

channel ORA_DISK_1: starting archive log restore to default destination

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=300

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=301

channel ORA_DISK_1: restoring archive log

archive log thread=1 sequence=302

channel ORA_DISK_1: reading from backup piece /data3/ordrbak/arch_order_20060914_173

channel ORA_DISK_1: restored backup piece 1

piece handle=/data3/ordrbak/orderarch_order_20060914_173 tag=TAG20060914T033004

channel ORA_DISK_1: restore complete, elapsed time: 00:00:08

archive log filename=/oradata/archive/1_300_592917188.dbf thread=1 sequence=300

archive log filename=/oradata/archive/1_301_592917188.dbf thread=1 sequence=301

archive log filename=/oradata/archive/1_302_592917188.dbf thread=1 sequence=302

archive log filename=/oradata/archive/1_303_592917188.dbf thread=1 sequence=303

archive log filename=/oradata/archive/1_304_592917188.dbf thread=1 sequence=304

media recovery complete, elapsed time: 00:00:57

Finished recover at 2006-09-14 22:51:39