Re: Help! 9.0.2 dead!

More: Looking in the alert log i see:

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=13
ARC0: Archival started
ARC1 started with pid=14
ARC1: Archival started
Tue Aug 23 10:45:37 2005
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Aug 23 10:45:37 2005
ARC0: Thread not mounted
Tue Aug 23 10:45:37 2005
ARC1: Thread not mounted
Tue Aug 23 10:45:37 2005
alter database mount exclusive
Tue Aug 23 10:45:44 2005
Successful mount of redo thread 1, with mount id 3961891604. Tue Aug 23 10:45:44 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive Tue Aug 23 10:45:44 2005
alter database open
Tue Aug 23 10:45:45 2005
Beginning crash recovery of 1 threads
Tue Aug 23 10:45:45 2005
Started first pass scan
Tue Aug 23 10:45:45 2005
Completed first pass scan
 3491 redo blocks read, 72 data blocks need recovery Tue Aug 23 10:45:45 2005
Started recovery at
 Thread 1: logseq 254, block 174239, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 1 Seq 254 Reading mem 0   Mem# 0 errs 0: C:\ORACLE\ORADATA\HYDRO\REDO01.LOG Tue Aug 23 10:45:45 2005
Ended recovery at
 Thread 1: logseq 254, block 177730, scn 0.32437551  72 data blocks read, 72 data blocks written, 3491 redo blocks read Crash recovery completed successfully
Tue Aug 23 10:45:46 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode Tue Aug 23 10:45:46 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_600.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

and

Tue Aug 23 10:45:46 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_600.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

and

Database mounted in Exclusive Mode.
Completed: alter database mount exclusive Tue Aug 23 11:03:56 2005
alter database open
Tue Aug 23 11:03:57 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode Tue Aug 23 11:03:57 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_568.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file

and

Tue Aug 23 11:03:57 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_568.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

and

LGWR: Primary database is in CLUSTER CONSISTENT mode Tue Aug 23 12:32:53 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_544.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Aug 23 12:32:53 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_544.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Aug 23 12:32:53 2005
ORA-313 signalled during: alter database open... Tue Aug 23 12:52:32 2005
/* OracleOEM */ ALTER DATABASE OPEN
Tue Aug 23 12:52:33 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode Tue Aug 23 12:52:33 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_544.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Aug 23 12:52:33 2005
Errors in file c:\oracle\admin\hydro\bdump\hydro_lgwr_544.trc:

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'C:\ORACLE\ORADATA\HYDRO\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Aug 23 12:52:33 2005
ORA-313 signalled during: /* OracleOEM */ ALTER DATABASE OPEN ... Received on Tue Aug 23 2005 - 14:01:12 CDT