Home » RDBMS Server » Backup & Recovery » Restore datafiles in another database (Oracle 10.2.0.4 Windows Server 2003 R2)
Restore datafiles in another database [message #513831] Wed, 29 June 2011 10:59 Go to next message
PLSQLPROB
Messages: 11
Registered: May 2003
Junior Member
Can we restore a database if we have only the datafiles available? The database has been dropped but we have just the datafiles with NO system, sysaux,users and undo datafiles that were saved after taking the database offline and then dropping the database. I know this is strange but if poosible, I want to see if we can retrieve some of the data from those datafiles to another database. BTW, There is no backup available for this database except the dbf files on OS. Let me know if this is possible. Thanks

[Updated on: Wed, 29 June 2011 11:07]

Report message to a moderator

Re: Restore datafiles in another database [message #513833 is a reply to message #513831] Wed, 29 June 2011 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
You can call Oracle to retrieve your data.

Regards
Michel
Re: Restore datafiles in another database [message #514190 is a reply to message #513833] Sat, 02 July 2011 08:10 Go to previous messageGo to next message
hitesh80
Messages: 2
Registered: July 2011
Location: MUMBAI
Junior Member

mostly the answer is "NO"
your DB was in Archive mode and also you have archives available?
than try to create initial P-file and try to start DB ...... its not possible but try as i never come across this situation where we dont have backups also !!!!!

Thanks,
Hitesh
Re: Restore datafiles in another database [message #514202 is a reply to message #514190] Sat, 02 July 2011 10:53 Go to previous message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you have NO system tablespace, you can't start, archivelog mode or not.

Regards
Michel
Previous Topic: transportable tablespace
Next Topic: Why RMAN wait for a long time??
Goto Forum:
  


Current Time: Wed Oct 01 14:22:07 CDT 2014

Total time taken to generate the page: 0.11118 seconds