Home » RDBMS Server » Server Administration » deleted datafile (10g Release2 SUSE Linux)
deleted datafile [message #436703] Sat, 26 December 2009 00:50 Go to next message
prabhaher
Messages: 6
Registered: December 2009
Location: Muscat
Junior Member
Hi All,

Mistakenly i deleted one dbf file.
when i restarted the database im getting this error.

SQL> startup
ORACLE instance started.

Total System Global Area 364904448 bytes
Fixed Size 1261804 bytes
Variable Size 339742484 bytes
Database Buffers 16777216 bytes
Redo Buffers 7122944 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 18 - see DBWR trace file
ORA-01110: data file 18: '/U02/database/mydb/qab_temp01.dbf'



I have oracle 10g Release 2 in Suse Linux. my database is not in Archivelog mode and i dont have any cold backups.


Im in bad shape. Pls Help me ASAP.

Thanks
Prabhaher.
Re: deleted datafile [message #436708 is a reply to message #436703] Sat, 26 December 2009 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In mounted state, put the file offline, then you can open the database, create a new tablespace, move most objects you can, and drop the old tablespace.

And for the future, activate the archive log mode and make regular backups.

Regards
Michel

[Updated on: Sat, 26 December 2009 02:00]

Report message to a moderator

Re: deleted datafile [message #436711 is a reply to message #436708] Sat, 26 December 2009 07:19 Go to previous message
prabhaher
Messages: 6
Registered: December 2009
Location: Muscat
Junior Member
Thanks Michel,

i drop the datafile offline and opened the database;

prabhaher
Previous Topic: Error - PL/SQL cannot understand the stored format of a library unit
Next Topic: STARTUP PFILE, CATAUDIT & Session ID....
Goto Forum:
  


Current Time: Fri Dec 02 14:31:16 CST 2016

Total time taken to generate the page: 0.31501 seconds