원문 : http://www.ischo.net -- 조인상 //시스템 엔지니어

+++++++++++++++++++++++++++++++++++++++++++++++++++++++

time-based recovery.  

SYS> startup mount

 ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              83888372 bytes
Database Buffers           79691776 bytes
Redo Buffers                2973696 bytes
Database mounted.

SYS> alter session set nls_date_format ='yyyy-mm-dd hh24:mi:ss';

Session altered.

SYS> recover database until time '2010-08-24 01:00:00';
Media recovery complete.

SYS> alter database open resetlogs;

Database altered.