Home » RDBMS Server » Backup & Recovery » Datafile deleted (10g, RHEL 5.3 )
Datafile deleted [message #571860] Mon, 03 December 2012 01:45 Go to next message
morad_dba
Messages: 93
Registered: June 2008
Member

Daar all,

I have mistakenly deleted a datafle of 10 database. At that time database was shutdown.

When i try to startup the database it returns errors and stays at mount state.

Erros is :

SQL> startup
ORACLE instance started.

Total System Global Area 205520896 bytes
Fixed Size 2019576 bytes
Variable Size 104861448 bytes
Database Buffers 92274688 bytes
Redo Buffers 6365184 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 16 - see DBWR trace file
ORA-01110: data file 16: '/u01/app/oracle/oradata/orcl/dataidx01.dbf'


I do not have any types of backup.


Now what to do... Please help me..


Regards
Morad.
Sad

Report message to a moderator

Re: Datafile deleted [message #571863 is a reply to message #571860] Mon, 03 December 2012 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I do not have any types of backup.


Are you in ARCHIVELOG mode?
Have you ALL the archived logs since the file was created?

Regards
Michel

Report message to a moderator

Re: Datafile deleted [message #571866 is a reply to message #571863] Mon, 03 December 2012 02:40 Go to previous messageGo to next message
morad_dba
Messages: 93
Registered: June 2008
Member

I am using the database for last one year.. but i enabled archive log mode just nearly one month ago.

Report message to a moderator

Re: Datafile deleted [message #571867 is a reply to message #571866] Mon, 03 December 2012 02:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
So you lose the data in this file and maybe more depending on which objects where in the file.
As it is name "dataidx01.dbf", I think there were only indexes so it is not too serious.

In mount stage, put the file offline then you can open the database. After that query dba_extents to know which indexes were in this file. If you can't, you have to put the whole tablespace offline and query dba_segments to know all indexes in the tablespace and drop them, then drop the tablespace, recreate it and the indexes.
That's all.

Regards
Michel

Report message to a moderator

Re: Datafile deleted [message #571869 is a reply to message #571867] Mon, 03 December 2012 03:35 Go to previous message
morad_dba
Messages: 93
Registered: June 2008
Member

Thanks Michel,

I followed your procedure and successfully open database and recreated TS.

Thank you very much.

Report message to a moderator

Previous Topic: RMAN restoration
Next Topic: Dataguard Issue
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 05:40:09 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.