Home » RDBMS Server » Backup & Recovery » Error: indx_data.dbf
Error: indx_data.dbf [message #259983] Fri, 17 August 2007 01:39 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
Morning 9 am I started oracle 10.2.0.1.0 database ,by 10.25am I got connection error.Then I restarted the server ,I am able to MOUNT the database, while OPENNING I am getting the following error
Error:ORA-01157: cannot identify/lock data file 7 -see DBWR trace file
ORA-01110:data file 7: '\\host_number\F$\----\INDX_DATA.DBF

My alert log file error
-----------------------
Fri Aug 17 10:26:27 2007
Errors in file f:\oracle\product\10.1.0\admin\teng\udump\teng_ora_300.trc:

Fri Aug 17 10:26:43 2007
Errors in file f:\oracle\product\10.1.0\admin\teng\udump\teng_ora_3760.trc:

Fri Aug 17 10:28:17 2007
Errors in file f:\oracle\product\10.1.0\admin\teng\udump\teng_ora_1996.trc:

Fri Aug 17 10:28:17 2007
Errors in file f:\oracle\product\10.1.0\admin\teng\udump\teng_ora_2580.trc:
ORA-25254: time-out in LISTEN while waiting for a message
ORA-06512: at "SYS.DBMS_AQ", line 577
ORA-06512: at "SYSMAN.EMD_NOTIFICATION", line 492
ORA-06512: at line 1

In trace file message
---------------------
In the trace file teng_ora_300.trc & teng_ora_3760.trc:
I am getting error as

kwqidafp: cursor from different session
kwqidafp: cursor from different session

In the trace file teng_ora_1996,I am getting error as

ksedmp: internal or fatal error

How to recover the database ?

by
sbmk_design

Re: Error: indx_data.dbf [message #259993 is a reply to message #259983] Fri, 17 August 2007 02:04 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
see DBWR trace file

Have a look at bdump directory.

Quote:
\\host_number\F$\----\INDX_DATA.DBF

Afaik, Oracle never supported UNC for data files as instance should be started with a local user and not a domain one.
Have a look if your host is up and share/directory accessible by Oracle instance owner.

Regards
Michel

Previous Topic: restoring database to different box
Next Topic: 10gR2 : flash recovery area backup
Goto Forum:
  


Current Time: Mon Dec 05 19:08:49 CST 2016

Total time taken to generate the page: 0.10422 seconds