Skip to Main Content
  • Questions

  • Deleted Data File from OS Side - How to Get Oracle to Ignore so data can be added back in

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Douglas.

Asked: August 13, 2019 - 8:13 pm UTC

Last updated: August 14, 2019 - 2:47 am UTC

Version: 11g

Viewed 1000+ times

You Asked

I've inherited a situation where a previous Oracle 11g DBA manually deleted a number of files on the operating system side (Red Hat Enterprise) several months ago. No backups were made and the database is not in ARCHIVE mode. The sys.dba_data_file view says the data files are empty and offine.

Data recovery is probably impossible, but if I can have the database stop looking for the missing data file(s) every time a query is run, then I can maybe reload the tables again using Oracle's bulk load programs.

So how do I get the database to stop looking for a data file that does not exist?

I'm not an Oracle DBA, but have been tasked with fixing this.

Any suggestions would be greatly appreciated.

and Connor said...

Take a look here

https://asktom.oracle.com/pls/apex/asktom.search?tag=how-to-drop-a-datafile

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

I'm not an Oracle DBA, but have been tasked with fixing this.

A reader, August 14, 2019 - 7:02 am UTC 

I feel sorry for you.. but have been in such a position cleaning up other people's mess (good learning curve).

But these got me to wonder: 

"previous Oracle 11g DBA manually deleted a number of files" - Clearly he/she wasn't much of a DBA :P

"I'm not an Oracle DBA, but have been tasked with fixing this." - Aren't there other Oracle DBAs who could/should have helped with it?

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database