Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

database recovery with missing datafile

431960Jun 1 2007 — edited Jun 4 2007

i have a 8.1.6 database, with certain datafiles gone with a crippled device, i still have all the datafiles for SYSTEM, USERS tablespace and the tablespace that most of user objects resides on. while i lost the rollback tablespace datafile.

wonder if i can still recover my data tablespace? i made offline the datafile that belong to the rollback tablespace and attempt to open the database (normal mode or read only mode), which all failed.....

need all guru to give me some advice...i felt i just 1 step away to recover all the data that useful to me, which i know may be impossible to do it, still bear some hope...

thanks again for all input.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 2 2007

Added on Jun 1 2007

#general-database-discussions

13 comments

4,535 views