Originally posted by Giani
Your database will crash.
Hi,

If ur database contains atleast one valid member in all the log groups, then your database won't get crash.

But ofcourse it will write the infomation about ur invaid member in the alert files as follows

Alert file Output
*****************

Dump file G:\Oracle\admin\fatma\bdump\fatmaALRT.LOG

11:30 AM 4/29/1999Thu Apr 29 11:34:56 1999
Thread 1 advanced to log sequence 152
Current log# 1 seq# 152 mem# 0: G:\ORACLE\ORADATA\FATMA\REDO01.LOG
Thu Apr 29 11:34:56 1999
ARC0: Beginning to archive log# 2 seq# 151
Thu Apr 29 11:35:00 1999
Errors in file G:\Oracle\admin\fatma\bdump\fatmaLGWR.TRC:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: invalid file header

Thu Apr 29 11:35:00 1999
Errors in file G:\Oracle\admin\fatma\bdump\fatmaLGWR.TRC:
ORA-00321: log 3 of thread 1, cannot update log file header
ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'

Thu Apr 29 11:35:00 1999
Errors in file G:\Oracle\admin\fatma\bdump\fatmaLGWR.TRC:
ORA-00313: open failed for members of log group 3 of thread 1

Trace file Output
*************************


*** SESSION ID:(3.1) 1999-04-29 11:24:47.477
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'
ORA-27048: skgfifi: file header information is invalid
OSD-04004: invalid file header
ORA-00321: log 3 of thread 1, cannot update log file header
ORA-00312: online log 3 thread 1: 'G:\ORACLE\ORADATA\FATMA\REDO31.LOG'
ORA-00313: open failed for members of log group 3 of thread 1

Seelan