1.shutdown rdbms

SQL> shutdown immediate;

数据库已经关闭。

已经卸载数据库。

ORACLE 例程已经关闭。

2.delete all online redo logfile media

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 9月 2 15:08:16 2011

已连接到空闲例程。

3.try to start database

SQL> startup

ORACLE 例程已经启动。

Total System Global Area 612368384 bytes

Fixed Size 1250428 bytes

Variable Size 230689668 bytes

Database Buffers 373293056 bytes

Redo Buffers 7135232 bytes

数据库装载完毕。

ORA-00313: 无法打开日志组 1 (用于线程 1) 的成员

ORA-00312: 联机日志 1 线程 1:

'D:\ORACLE\PRODUCT\10.2.0\ORADATA\DOCTOR\REDO01.LOG'

4.get controlfile checkpoint scn and datafile checkpoint scn and v$recover_file

SQL> select checkpoint_change# from v$datafile;

CHECKPOINT_CHANGE#

------------------

1163739

SQL> select checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#

------------------

1163739

SQL> select change# from v$recover_file;

未选定行

compare the preceding result，found just need to recover online redo logfile media.

5.recover database

SQL> recover database until cancel;

完成介质恢复。

6.try to open database directly.

SQL> alter database open;

alter database open

*

第 1 行出现错误:

ORA-01589: 要打开数据库则必须使用 RESETLOGS 或 NORESETLOGS 选项

7.open database via resetlogs. then all logfile sequence return to 1.

SQL> alter database open resetlogs; --after this step. all the lost online redo logfile media would be recover

8.check the recovered logfile media whether exist on specify location.

ITPub博客

recover all online redo logfile media which were lost