| accidentally deleted data file [message #342361] |
Fri, 22 August 2008 02:28  |
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 #342409 is a reply to message #342383] |
Fri, 22 August 2008 04:58  |
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.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
