dbTalk Databases Forums  

Pls help,oracle error

comp.databases.oracle comp.databases.oracle


Discuss Pls help,oracle error in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Raghuraman
 
Posts: n/a

Default Pls help,oracle error - 02-24-2005 , 11:31 AM






Hi,

In my web app , i am using oracle 9i as db.i an open the oracle
database but i cant retrieve the data.

It tells

ORA-00376: file 7 cannot be read at this time ORA-01110: data file 7:
'/mnt/ora_data/tcms/data02.dbf'

Error.

Could u pls tell me , how can i look around that.


Regards
Raghu

Reply With Quote
  #2  
Old   
Eric de Redelijkheid
 
Posts: n/a

Default Re: Pls help,oracle error - 02-24-2005 , 11:48 AM






Anno Domini 24-2-2005 18:31, Raghuraman sprak aldus:

Quote:
Hi,

In my web app , i am using oracle 9i as db.i an open the oracle
database but i cant retrieve the data.

It tells

ORA-00376: file 7 cannot be read at this time ORA-01110: data file 7:
'/mnt/ora_data/tcms/data02.dbf'

Error.

Could u pls tell me , how can i look around that.


Regards
Raghu


the name of the directory (/mnt) would suggest that your datafile is
residing on a nfs volume which is currently not mounted?

ask the one with root access to the server to perform a 'mount -a'. This
should work if the mountpoint is listed in /etc/fstabs. Otherwise he or
she should manually mount it. I am not sure this would give immediate
access to your data.

If the datafile is lost, then you should restore it from backup and
perform recovery operations (you do backup your database?).


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.