Home » RDBMS Server » Backup & Recovery » Recover Database - All Files Deleted while DB was running (10.2.0.3)
Recover Database - All Files Deleted while DB was running [message #345502] Wed, 03 September 2008 21:18 Go to next message
andydba
Messages: 34
Registered: September 2008
Member

Hi,

I have a database which was open. BY mistake I deleted all the datafiles (.dbf) files.

I have following:
Control Files
Archive Logs
Online Redo Log
Backup Set (RMAN)

How can I recover dbf files and make DB operational once again.

When I tried "restore database" from RMAN it says "not logged on". Also, I am not able to shutdown the DB from RMAN.

-Andy
Re: Recover Database - All Files Deleted while DB was running [message #345520 is a reply to message #345502] Wed, 03 September 2008 23:29 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/m/345501/74940/#msg_345501
Previous Topic: backup controlfile to trace
Next Topic: About downloaded Oracle 10.2 from Internet
Goto Forum:
  


Current Time: Sun Dec 04 00:05:49 CST 2016

Total time taken to generate the page: 0.10174 seconds