| deleted datafile [message #436703] |
Sat, 26 December 2009 00:50  |
prabhaher
Messages: 11
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  |
 |
Michel Cadot
Messages: 68665
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
