Hi.

Which version of Oracle is it?
Do you have backups?

Can you find out which tablespace this datafile belongs too?

Nico


-----Original Message-----
From: Luis Cardenas
[mailto:oracledba-ezmlmshield-x61479495.[Email address protected]
Sent: Wednesday, May 30, 2007 1:13 PM
To: LazyDBA Discussion
Subject: Data File missing.

Expertos,



got this error in my alert log:



Errors in file /u01/app/oracle/admin/QWEB1/bdump/qweb11_dbw0_6415.trc:

ORA-01186: Message 1186 not found; No message file for product=RDBMS,
facility=ORA; arguments: [76]

ORA-01157: Message 1157 not found; No message file for product=RDBMS,
facility=ORA; arguments: [76]

ORA-01110: Message 1110 not found; No message file for product=RDBMS,
facility=ORA; arguments: [76]
[/u01/app/oracle/product/10.1/db/dbs/ts_dba_ola_data01.dbf]





The database is up and running, when I query dba_data_files it brings
back the same error as above.





How to procede? Thanks






-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page