redo文件丢失恢复

redo文件最好采用多路复用：可以防止单点故障，如果不是多路复用，在redo文件丢失时，数据库会报错，如何恢复呢，如下：

 

SQL> startup;
ORACLE instance started.

Total System Global Area  218103808 bytes
Fixed Size                  2019672 bytes
Variable Size             113249960 bytes
Database Buffers           96468992 bytes
Redo Buffers                6365184 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/oradata/hzkj/redo01.log'

SQL> recover database until cancel using backup controlfile;
ORA-00279: change 882256 generated at 10/19/2010 15:36:50 needed for thread 1
ORA-00289: suggestion : /u01/arch/1_5_732812782.dbf
ORA-00280: change 882256 for thread 1 is in sequence #5

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.

SQL> alter database open resetlogs;

Database altered.

SQL>

数据库顺利打开。呵呵，原来这么简单