Home » RDBMS Server » Backup & Recovery » Recovery of Deleted datafile (Windows,10.2.0.3)
Recovery of Deleted datafile [message #468748] Mon, 02 August 2010 01:12 Go to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Hi I Have a database in which a datafile is deleted.I want to know how to recover the datafile if the file doesnot exist but we have all the archive logs.

I know we have to create a empty datafile and apply the logs but i cannot mount the database as the datafile is not found.Please help me
Re: Recovery of Deleted datafile [message #468757 is a reply to message #468748] Mon, 02 August 2010 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 59786
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The datafile belongs to which tablespace?

Regards
Michel
Re: Recovery of Deleted datafile [message #468771 is a reply to message #468757] Mon, 02 August 2010 02:57 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
DATA is the tablespace name...I created it manually....
Re: Recovery of Deleted datafile [message #468772 is a reply to message #468771] Mon, 02 August 2010 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 59786
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can create what the file or the tablespace? Does the tablespace still exist?
How did you delete the file? At OS level or SQL one?

Regards
Michel
Re: Recovery of Deleted datafile [message #468821 is a reply to message #468772] Mon, 02 August 2010 04:50 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
OS level and I have all the archive logs since database was created....Yes the tablespace still exists...How can I create the datafile again....When I open the database it says database not found...
Re: Recovery of Deleted datafile [message #468824 is a reply to message #468821] Mon, 02 August 2010 04:56 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
A Basic Question sekar52 , since you have delete the data file at OS level can't you get it
from recycle bin ? ( unless it too big the OS will directly Delete it [with Message Box] )
Re: Recovery of Deleted datafile [message #468830 is a reply to message #468824] Mon, 02 August 2010 05:05 Go to previous messageGo to next message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
its deleted from recycle bin also...
Re: Recovery of Deleted datafile [message #468849 is a reply to message #468830] Mon, 02 August 2010 05:23 Go to previous messageGo to next message
Michel Cadot
Messages: 59786
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ALTER DATABASE CREATE DATAFILE ...

Regards
Michel
Re: Recovery of Deleted datafile [message #468863 is a reply to message #468849] Mon, 02 August 2010 05:39 Go to previous message
sekar52
Messages: 141
Registered: May 2010
Location: Mumbai
Senior Member
Thanks Michel
Previous Topic: Restore table fails
Next Topic: Recovering a DB with different name
Goto Forum:
  


Current Time: Wed Nov 26 05:46:54 CST 2014

Total time taken to generate the page: 0.28302 seconds