SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

[oracle@localhost NACEC]$ rm -rf redo03.log;

SQL> startup;

ORACLE instance started.

Total System Global Area 419430400 bytes

Fixed Size 1267836 bytes

Variable Size 356517764 bytes

Database Buffers 58720256 bytes

Redo Buffers 2924544 bytes

Database mounted.

ORA-00313: open failed for members of log group 3 of thread 1

ORA-00312: online log 3 thread 1: '/dat/DBData/oradata/NACEC/redo03.log'

SQL> recover database until cancel;恢复的时候，告诉恢复到最后一个可用的redolog

Media recovery complete.

SQL> alter database open resetlogs;

SQL> select group#,status from v$log;

GROUP# STATUS

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

1 INACTIVE

2 CURRENT

3 UNUSED

再看日志文件，丢失的第三个文件已经出来了

ITPub博客

模拟数据文件和控制文件完好无损，日志文件损坏