Home » RDBMS Server » Server Administration » Oracle startup problem for deleting data file manually
Oracle startup problem for deleting data file manually [message #58930] Wed, 15 October 2003 05:48 Go to next message
sanjib
Messages: 1
Registered: October 2003
Junior Member
Accidentally I've deleted the a new data file without off line the same,now I'm facing problem to start the oracle,it is giving error.

Any body can help me out in this regard?

Report message to a moderator

Re: Oracle startup problem for deleting data file manually [message #58932 is a reply to message #58930] Wed, 15 October 2003 06:21 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Are you operating your database in ARchivelog or Noarchivelog mode ?
How did you delete the datafile ?

Did you try to offline the datafile and startup the database ?

startup mount
alter database datafile 'filename' offline [[drop]];
alter database open;

drop optin is reqauired in NOARchivelog mode.
Do you have backup of the datafile or archivelogs ?

-Thiru

Report message to a moderator

Previous Topic: How to migrate db from one OS to another without using exp/imp utility
Next Topic: Documentum
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 04 22:20:40 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.