hi,
i'm running oracle 8.0.5.
whenever i start my database, i have the following entries in my alert log:
with these errors, i could not do any query to my database (ERICDATA) but can see the tables and desc on each table.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'
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.


Reply With Quote
Bookmarks