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
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.
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
gkrishn
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 Dec 02 20:34:56 CST 2016

Total time taken to generate the page: 0.11693 seconds