time-based recovery
2010.08.24 18:41
원문 : http://www.ischo.net -- 조인상 // 시스템 엔지니어
Writer : http://www.ischo.net -- ischo // System Engineer in Replubic Of Korea
+++++++++++++++++++++++++++++++++++++++++++++++++++++++
원문 : 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.
