Oracle Database Discussions

DB VERSION 9.2.0.8.0
OS Win 2003 Server.

In morning, I found my hard disk got crashed. fortunetly, my oracle software and
system datafiles were on the second disk.So, I hough of putting those datafile
in offline mode and try to open the database. but after putting the datafiles in offline mode and making the DB open. it causes ORA-01092: ORACLE instance terminated. Disconnection forced to occur. then, I decided to recreate the controlfile and removing those dbfiles from controlfile which I put offline, prior to database open. Now, after recreating the CTL file. I still failed to open it. then
I invastigated the alert.log file to pin point the problem. According to alert.log file, it says the Errors in file e:\oracle\admin\devdb\bdump\devdb_pmon_1276.trc:
ORA-00376: file cannot be read at this time. but when I searched for the above file, it exist on the above mentioned location. I am pasting the part of my Alert.log file.

Error 376 happened during db open, shutting down database
USER: terminating instance due to error 376
Mon Jun 23 13:02:01 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_pmon_1276.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:02:01 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_reco_1280.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:02:01 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_lgwr_2704.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:02:02 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_ckpt_1228.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:02:02 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_dbw0_3756.trc:
ORA-00376: file cannot be read at this time

Instance terminated by USER, pid = 3908
ORA-1092 signalled during: alter database open ...
Mon Jun 23 13:02:17 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.8.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
resource_limit = TRUE
shared_pool_size = 109051904
large_pool_size = 8388608
java_pool_size = 33554432
control_files = E:\oracle\oradata\DEVDB\CONTROL01.CTL, E:\oracle\oradata\DEVDB\CONTROL02.CTL, E:\oracle\oradata\DEVDB\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 209715200
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = DEVDB
dispatchers = (PROTOCOL=TCP) (SERVICE=DEVDBXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = E:\oracle\admin\DEVDB\bdump
user_dump_dest = E:\oracle\admin\DEVDB\udump
max_dump_file_size = 400M
core_dump_dest = E:\oracle\admin\DEVDB\cdump
sort_area_size = 524288
db_name = DEVDB
open_cursors = 300
sql_trace = FALSE
star_transformation_enabled= FALSE
query_rewrite_enabled = TRUE
query_rewrite_integrity = ENFORCED
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2, OS id=3872
DBW0 started with pid=3, OS id=3248
LGWR started with pid=4, OS id=1420
CKPT started with pid=5, OS id=1968
SMON started with pid=6, OS id=3056
RECO started with pid=7, OS id=132
CJQ0 started with pid=8, OS id=2756
QMN0 started with pid=9, OS id=716
Mon Jun 23 13:02:20 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Jun 23 13:02:21 2008
ALTER DATABASE MOUNT
Mon Jun 23 13:02:25 2008
Successful mount of redo thread 1, with mount id 562894173
Mon Jun 23 13:02:25 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon Jun 23 13:05:22 2008
alter database datafile 32 offline
Mon Jun 23 13:05:22 2008
Completed: alter database datafile 32 offline
Mon Jun 23 13:05:29 2008
alter database open
Mon Jun 23 13:05:29 2008
Beginning crash recovery of 1 threads
Mon Jun 23 13:05:29 2008
Started redo scan
Mon Jun 23 13:05:30 2008
Completed redo scan
59 redo blocks read, 4 data blocks need recovery
Mon Jun 23 13:05:30 2008
Started recovery at
Thread 1: logseq 7691, block 3, scn 0.0
Mon Jun 23 13:05:30 2008
Recovery of Online Redo Log: Thread 1 Group 1 Seq 7691 Reading mem 0
Mem# 0 errs 0: E:\ORACLE\ORADATA\DEVDB\REDO01.LOG
Mon Jun 23 13:05:30 2008
Completed redo application
Mon Jun 23 13:05:30 2008
Ended recovery at
Thread 1: logseq 7691, block 62, scn 3.1301372458
4 data blocks read, 4 data blocks written, 59 redo blocks read
Crash recovery completed successfully
Mon Jun 23 13:05:30 2008
Thread 1 advanced to log sequence 7692
Thread 1 opened at log sequence 7692
Current log# 2 seq# 7692 mem# 0: E:\ORACLE\ORADATA\DEVDB\REDO02.LOG
Successful open of redo thread 1
Mon Jun 23 13:05:31 2008
SMON: enabling cache recovery
Mon Jun 23 13:05:32 2008
Successfully onlined Undo Tablespace 1.
Mon Jun 23 13:05:32 2008
SMON: enabling tx recovery
Mon Jun 23 13:05:32 2008
Database Characterset is AL32UTF8
Mon Jun 23 13:05:33 2008
Errors in file e:\oracle\admin\devdb\udump\devdb_ora_140.trc:
ORA-00376: file 32 cannot be read at this time
ORA-01111: name for data file 32 is unknown - rename to correct file
ORA-01110: data file 32: 'E:\ORACLE\ORA92\DATABASE\MISSING00032'

Error 376 happened during db open, shutting down database
USER: terminating instance due to error 376
Mon Jun 23 13:05:34 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_pmon_3872.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:05:34 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_ckpt_1968.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:05:34 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_reco_132.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:05:34 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_lgwr_1420.trc:
ORA-00376: file cannot be read at this time

Mon Jun 23 13:05:34 2008
Errors in file e:\oracle\admin\devdb\bdump\devdb_dbw0_3248.trc:
ORA-00376: file cannot be read at this time

Instance terminated by USER, pid = 140
ORA-1092 signalled during: alter database open ...

If there is a way to open the database, then please let me know.

hare krishna
Alok