Home » RDBMS Server » Backup & Recovery » Datafile Missing...not able to connect
Datafile Missing...not able to connect [message #192889] Thu, 14 September 2006 01:56 Go to next message
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....

Re: Datafile Missing...not able to connect [message #192894 is a reply to message #192889] Thu, 14 September 2006 02:25 Go to previous message
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
restore the backup datafile to same location.
startup in mount
issue command recover database;
alter database open

i assume, u have backup datafile ,and u are running archive log mode
Previous Topic: Set NLS_DATE_FORMAT RMAN for Windows XP
Next Topic: HOT backup Question
Goto Forum:

Current Time: Fri Jul 28 04:35:53 CDT 2017

Total time taken to generate the page: 0.09683 seconds