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

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博客 ” ，链接：http://blog.itpub.net/31448824/viewspace-2137534/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31448824/viewspace-2137534/