Home » RDBMS Server » Backup & Recovery » accidentally deleted data file (10.0 win xp)
accidentally deleted data file [message #342361] Fri, 22 August 2008 02:28 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Hi,

I accidentally deleted a data file due to which the control file is not able to read the file name and giving me this error

C:\Documents and Settings\Dd>set oracle_sid=dbase

C:\Documents and Settings\Dd>sqlplus

SQL*Plus: Release 10.1.0.4.2 - Production on Fri Aug 22 12:49:09 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: das/das
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


The reason was evident when I logged in a SYSDBA.

Enter user-name: /as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'D:\FILES\DATA\DATA01.DBF'


What can be done in this case? I know this data is lost but how to fire fight and log in to save the rest.
Re: accidentally deleted data file [message #342367 is a reply to message #342361] Fri, 22 August 2008 02:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Restore the file from a backup and recover it.

Regards
Michel
Re: accidentally deleted data file [message #342373 is a reply to message #342367] Fri, 22 August 2008 03:19 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
I knew this but unfortunately there is no backup for the database.

What else could I do?
Re: accidentally deleted data file [message #342383 is a reply to message #342373] Fri, 22 August 2008 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Drop the whole tablespace.
This is the only way to save your database but of course you will lose all data in it.

Regards
Michel
Re: accidentally deleted data file [message #342409 is a reply to message #342383] Fri, 22 August 2008 04:58 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
yes...but without opening the database how do I find out which tablespace it belongs to .. I did not know that so did this.

alter database datafile 'D:\FILES\DATA\DATA01.DBF' offline drop;


shutdown the database opened it (which opened properly)

and then then dropped the tablespace.
Re: accidentally deleted data file [message #342486 is a reply to message #342409] Fri, 22 August 2008 08:57 Go to previous messageGo to next message
alanm
Messages: 282
Registered: March 2005
Senior Member

hi,
do you have a copy of the datafile elsewhere which you could catalog in rman?

regards

Alan
Re: accidentally deleted data file [message #342492 is a reply to message #342486] Fri, 22 August 2008 09:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think
Quote:
unfortunately there is no backup for the database.

answer your question.

Regards
Michel
Re: accidentally deleted data file [message #342499 is a reply to message #342492] Fri, 22 August 2008 09:40 Go to previous message
alanm
Messages: 282
Registered: March 2005
Senior Member

I assumed by this the OP mean't no RMAN backup.

Alan
Previous Topic: datbase not opened (merged)
Next Topic: Oracle 9i Recovery No Archive Logs
Goto Forum:
  


Current Time: Wed Dec 07 22:42:09 CST 2016

Total time taken to generate the page: 0.10041 seconds