-
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.
Last edited by nyagi; 06-28-2006 at 04:17 AM.
-
do you have a valid cold backup?
-
-
well you are screwed then, your data is gone - unless you pay oracle a lot of money to use their data unload tool to scrape out the data from the datafile
-
Looks like the whole directory is screwed ORA-01110: data file 5: 'E:\DATA\ERICDATA'
unless of course you named the actual file ericdata which in that case if you did I'd like to know what you were thinking?
Hey Davey lets say hypothetically this poor sod did name his datafile "ericdata" and the data in that datafile was hypothetically expendable, then he could hypothetically take the datafile off line and blow it away. hypothetically speaking of course.
Oracle it's not just a database it's a lifestyle!
--------------
BTW....You need to get a girlfriend who's last name isn't .jpg
-
Is there anymore to the error message besides
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'
Where is this file? Can you physically see the file from the OS?
-
just to clarify... this database was just handed down to me. i've been working with this database for the past week. i dont know what the former dba did to this database!
anyway, ERICDATA is the datafile used. the file is physically visible in the OS. i know its screwed up, just hoping that we can retrieve the data in the said datafile. i was thinking of dropping the tablespace and recreate it just so the application using it will run. am i thinking it right?
thanks!
-
no you are not, the data is gone
-
Davey23uk... the data is gone.
At least until you perform media recovery. And since you're in no archive log mode, Media recovery is impossible. Hence the data is gone.
How important is the data? I may be able to perform a partial/incomplete extract of the data from the raw datafile. Please PM, if you are interested in this.
Ken
-
How important is the data? I may be able to perform a partial/incomplete extract of the data from the raw datafile. Please PM, if you are interested in this.
And what is the hourly rate for this work?
Tamil
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|