Redo file Best Use multiplexing: To prevent a single point of failure, if not multiplexing, in the redo file loss, the database will be an error, how to recover it, as follows:
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 for thread 1
Ora-00289:suggestion:/u01/arch/1_5_732812782.dbf
Ora-00280:change 882256 for thread 1 was in sequence #5
Specify log: {<ret>=suggested | AUTO | CANCEL}
Cancel
Media recovery cancelled.
sql> ALTER DATABASE open resetlogs;
Database altered.
Sql>
The database is open successfully. Oh, it turns out so simple