could not get database running normally
hi,
i'm running oracle 8.0.5.
whenever i start my database, i have the following entries in my alert log:
Code:
Starting up ORACLE RDBMS Version: 8.0.5.0.0.
System parameters with non-default values:
processes = 100
shared_pool_size = 8000000
control_files = C:\orant\DATABASE\ctl1ORCL.ora
db_block_buffers = 30000
db_block_size = 2048
log_buffer = 3276800
log_checkpoint_interval = 10000
db_files = 1024
db_file_multiblock_read_count= 32
sequence_cache_entries = 30
sequence_cache_hash_buckets= 23
remote_login_passwordfile= SHARED
global_names = TRUE
distributed_lock_timeout = 300
distributed_transactions = 5
open_links = 4
db_name = ORCL
text_enable = TRUE
job_queue_processes = 2
job_queue_interval = 10
job_queue_keep_connections= FALSE
parallel_max_servers = 5
background_dump_dest = %RDBMS80%\trace
user_dump_dest = %RDBMS80%\trace
max_dump_file_size = 10240
PMON started with pid=2
DBW0 started with pid=3
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
Tue Jun 27 17:35:02 2006
alter database mount
LGWR started with pid=4
CKPT started with pid=5
Tue Jun 27 17:35:08 2006
Successful mount of redo thread 1, with mount id 1122022988.
Tue Jun 27 17:35:08 2006
Database mounted in Exclusive Mode.
Completed: alter database mount
Tue Jun 27 17:35:08 2006
alter database open
Beginning crash recovery of 1 threads
Recovery of Online Redo Log: Thread 1 Group 4 Seq 222456 Reading mem 0
Mem# 0 errs 0: C:\ORANT\DATABASE\LOG1ORCL.ORA
Crash recovery completed successfully
Tue Jun 27 17:35:09 2006
Thread 1 advanced to log sequence 222457
Thread 1 opened at log sequence 222457
Current log# 1 seq# 222457 mem# 0: C:\ORANT\DATABASE\LOG4ORCL.ORA
Successful open of redo thread 1.
Tue Jun 27 17:35:10 2006
SMON: enabling cache recovery
SMON: enabling tx recovery
ORACLE Instance orcl (pid = 6) - Error 376 encountered while recovering transaction (5, 19)
on object 4826.
Tue Jun 27 17:35:11 2006
Errors in file C:\orant\RDBMS80\trace\orclSMON.TRC:
ORA-00376: file 5 cannot be read at this time
ORA-01110: data file 5: 'E:\DATA\ERICDATA'
with these errors, i could not do any query to my database (ERICDATA) but can see the tables and desc on each table.
is there a way i can recover my database? the database is running in NO ARCHIEVLOG.
in addition, my datafile has a "RECOVER" status even after i do an OFFLINE DROP prior to opening the database.