OraFAQ Forum: Server Utilities » Can't open database because of a datafile deleted

Home » RDBMS Server » Server Utilities » Can't open database because of a datafile deleted

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't open database because of a datafile deleted [message #74374]

Wed, 01 December 2004 03:01

waveblue
Messages: 22
Registered: December 2004

Junior Member

HEllo,

I have a little problem.
i use oracle 10g.
A datafile of data has been deleted.
there is no backup and the big problem is that my database can't be open.
i can make only "start mount".
i can't make a "alter tablespace" because the database is not open.
I would like only open my database, the datafile is not important.

Please, somebody have an idea.

Thanks

Report message to a moderator

Re: Can't open database because of a datafile deleted [message #74375 is a reply to message #74374]

Wed, 01 December 2004 03:27

Tarun Biswas
Messages: 23
Registered: May 2004

Junior Member

Hi

if datafile is not important. u give following command.

Sql>startup mount
sql>alter database datafile '/user1...../' offline;
sql>alter database open;

try it , i think prob will solve.

Regards,

Tarun

Report message to a moderator

Re: Can't open database because of a datafile deleted [message #74376 is a reply to message #74375]

Wed, 01 December 2004 03:39

wavblue
Messages: 1
Registered: December 2004

Junior Member

the command "alter database datafile ..." don't run.
i have already tried it.
then, i have an error message = ORA-01145

have you an other idea?

Report message to a moderator

Re: Can't open database because of a datafile deleted [message #74381 is a reply to message #74376]

Wed, 01 December 2004 18:16

Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas

Senior Member

Hi,

If your database is not in archivelog mode then use :

ALTER DATABASE DATAFILE 'PATH_OF_DATA_FILE' OFFLINE DROP;

It will solve your problem.

Daljit Singh.

Report message to a moderator

Previous Topic:	external table. Data not fetching
Next Topic:	Import-Export issue - Version difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 03 01:49:02 CDT 2024