| Datafile Missing...not able to connect [message #192889] |
Thu, 14 September 2006 01:56  |
barjunreddy
Messages: 8
Registered: August 2006
Location: Hyderabad
|
Junior Member |
|
|
Hi Gurus,
I am new to the BKP and Recovery techniques. Today i tried to recover a database whenever a datafile got delted accidentally. The following are the steps i exeuted in the test
1.I created a tablespace test in the database.
2.Shutdown immediate.
3.Now with the another session at OS level i deleted the test.dbf file.
4.Now i tried to connect to the same database then it started throwing the following error.
===========================================================
ORA-01041: internal error. hostdef extension doesn't exist
===========================================================
This is the message in the alter.log file
*** SERVICE NAME:() 2006-09-14 11:23:49.906
*** SESSION ID:(167.1) 2006-09-14 11:23:49.906
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: 'E:\ORCL\TEST.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
Thanks in advance....
Regards,
Nagarjun.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
