Skip to Main Content

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 2 2007
Added on Jun 1 2007
13 comments
4,535 views