Home » RDBMS Server » Backup & Recovery » Is it possible to recover with only users datafile (If lost system tablespace,redo,control file etc.)
Is it possible to recover with only users datafile [message #336505] Sun, 27 July 2008 22:57 Go to next message
IT Guru
Messages: 59
Registered: January 2007
Member
Oracle 9i , windows / linux

If one have created new tablespace user with datafile user.dbf.

Which contain tables like emp , dept etc.


Now If I have only user.dbf , nothing else like system tablespace,control file , & not any kind of backup.


User.dbf physically contain all imp data I require.


Is't possible to recover in this situation.

Re: Is it possible to recover with only users datafile [message #336506 is a reply to message #336505] Sun, 27 July 2008 22:59 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Is't possible to recover in this situation.
NOT possible.
Previous Topic: Database Synchronisation
Next Topic: What is wrong? Open DB recover
Goto Forum:
  


Current Time: Sun Dec 11 08:30:16 CST 2016

Total time taken to generate the page: 0.15714 seconds