Home » RDBMS Server » Server Administration » Recovering database after a datafile got deleted accidently
Recovering database after a datafile got deleted accidently [message #53642] Wed, 02 October 2002 23:29 Go to next message
kiran
Messages: 503
Registered: July 2000
Senior Member
One of the datafiles in the database was deleted accidentally, the data of the tablespace is not important, I need to just bring up the database.

Can anybody help me?

Thanks in advance
Kiran

Report message to a moderator

Re: Recovering database after a datafile got deleted accidently [message #53649 is a reply to message #53642] Thu, 03 October 2002 06:07 Go to previous message
zeeshan
Messages: 6
Registered: May 2002
Junior Member
if ur database is in no archive mode, then mount the database, drop the offline deleted file and open the database and then u can later drop the appropriate tablespace.

if u r running in archive log mode. then proper and complete recovery may be possible by restoring from backup and then replaying archives.

Cheers,

Report message to a moderator

Previous Topic: oracle 9i - to large
Next Topic: Installation steps for Oracle Tools
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 13 22:14:34 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.