Question

如何用Oracle归档日志恢复到之前的某个时间点

Answer 1

方法
SQL> startup mount
ORACLE instance started.
Total System Global Area 3724541952 bytes
Fixed Size 2025168 bytes
Variable Size 754977072 bytes
Database Buffers 2952790016 bytes
Redo Buffers 14749696 bytes
Database mounted.
SQL> recover database until time '2016-07-06:15:00:00';
Media recovery complete.
SQL> alter database open resetlogs ;
Database altered.