Home » RDBMS Server » Backup & Recovery » Accidentally delete a data file (Oracle9i Enterprise Edition Release 9.2.0.1.0)
Accidentally delete a data file [message #495234] Thu, 17 February 2011 17:13 Go to next message
primecontrol
Messages: 3
Registered: February 2011
Location: Brasil
Junior Member
I have a database "BD001" for example, inside got 90 schemes, each
one has two tablespaces, see below script I use to create:

CREATE TABLESPACE TS_F_ORA9_027_DAT NOLOGGING DATAFILE
'E: \ DataBases \ ORACLE \ 92 \ DAT \ TS_F_ORA9_027_DAT.ora' SIZE 5M REUSE ON AUTOEXTEND
NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT
AUTO;

CREATE TABLESPACE TS_F_ORA9_027_IND NOLOGGING DATAFILE
'E: \ DataBases \ ORACLE \ 92 \ IND \ TS_F_ORA9_027_IND.ORA' SIZE 5M REUSE ON AUTOEXTEND
NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT
AUTO;

CREATE USER "F_ORA9_027" PROFILE DEFAULT IDENTIFIED BY prime DEFAULT
TABLESPACE QUOTA UNLIMITED ON TS_F_ORA9_027_DAT TS_F_ORA9_027_DAT SHARE
UNLIMITED ON ACCOUNT UNLOCK TS_F_ORA9_027_IND;

At one point I did a drop and delete user "F_ORA9_027," only the
files "TS_F_ORA9_027_DAT" and "TS_F_ORA9_027_IND.ORA" continued in the folder,
so I manually delete these two files and thereafter could not
Starting Oracle with more success when I try to get into the sqlplus
following message:

Enter the name of usußrio: system
Enter password:
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress

When I try to force got the following message:

Enter the name of usußrio: sys as sysdba
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> shutdown abort
ORACLE InstÔncia disabled.
SQL> startup
ORACLE InstÔncia started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01157: noo Ú possÝvel identify / lock data file 187 - see
file anßlise DBWR
ORA-01110: data file 187:
'E: \ DATABASES \ ORACLE \ 92 \ DAT \ F_ORA9_027_DAT.ORA'

I have the dmp this scheme "F_ORA9_027" but have no way to restore it once
I can not connect to the service.

Re: Accidentally delete a data file [message #495236 is a reply to message #495234] Thu, 17 February 2011 17:23 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:515222144417
Re: Accidentally delete a data file [message #495248 is a reply to message #495236] Thu, 17 February 2011 17:46 Go to previous messageGo to next message
primecontrol
Messages: 3
Registered: February 2011
Location: Brasil
Junior Member
SQL> shutdown abort
InstÔncia ORACLE desativada.
SQL> startup
InstÔncia ORACLE iniciada.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Banco de dados montado.
ORA-01157: nÒo Ú possÝvel identificar/bloquear arquivo de dados 187 - consulte
arquivo de anßlise DBWR
ORA-01110: 187 do arquivo de dados:
'E:\DATABASES\ORACLE\92\DAT\F_ORA9_027_DAT.ORA'


SQL> alter database recover datafile 187;
alter database recover datafile 187
*
ERRO na linha 1:
ORA-00283: sessÒo de recuperaþÒo cancelada devido a erros
ORA-01110: 187 do arquivo de dados:
'E:\DATABASES\ORACLE\92\DAT\F_ORA9_027_DAT.ORA'
ORA-01157: nÒo Ú possÝvel identificar/bloquear arquivo de dados 187 - consulte
arquivo de anßlise DBWR
ORA-01110: 187 do arquivo de dados:
'E:\DATABASES\ORACLE\92\DAT\F_ORA9_027_DAT.ORA'
Re: Accidentally delete a data file [message #495250 is a reply to message #495248] Thu, 17 February 2011 17:51 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=Oracle+missing+datafile
Re: Accidentally delete a data file [message #495260 is a reply to message #495250] Thu, 17 February 2011 18:09 Go to previous message
primecontrol
Messages: 3
Registered: February 2011
Location: Brasil
Junior Member
Thanks!

Problem solved.

I did several searches on google but all the codes of the past mistakes made and so far none of the solutions has solved the problem.
Previous Topic: Remove Duplicate DBID In Rman Catalog
Next Topic: control file directory missing
Goto Forum:
  


Current Time: Sat Nov 22 23:03:10 CST 2014

Total time taken to generate the page: 0.23357 seconds