OraFAQ Forum: Backup & Recovery » Recover Database - All Files Deleted while DB was running

Home » RDBMS Server » Backup & Recovery » Recover Database - All Files Deleted while DB was running (10.2.0.3)

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

Recover Database - All Files Deleted while DB was running [message #345502]

Wed, 03 September 2008 21:18

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

Report message to a moderator