OraFAQ Forum: Backup & Recovery » Is it possible to recover with only users datafile

Home » RDBMS Server » Backup & Recovery » Is it possible to recover with only users datafile (If lost system tablespace,redo,control file etc.)

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

Is it possible to recover with only users datafile [message #336505]

Sun, 27 July 2008 22:57

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.

Report message to a moderator