LOSS OF REDO LOG FILE

consistent:

SQL>start up;

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

SQL>select * from v$log;

SQL>alter database clear logfile group 3;

SQL> alter database  clear unarchived logfile group 3;

SQL> alter database open;

when loss of archived ACTIVE log file and instance crashed:

SQL>start up mount ;

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

ORA-00312:online log 3 thread 3:'redo03.log'

SQL>recover database until cancel;

SQL>alter database open resetlogs;

when loss of unarchived active file or current logfile and instance crashed

SQL>start up mount ;

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

ORA-00312:online log 3 thread 3:'redo03.log'

SQL> host cp .........

SQL>recover database until cancel;

SQL>alter database open resetlogs;