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!

Recovering System datafile with no backup.

ranz_dbaJun 8 2010 — edited Jan 14 2013

Hello Everyone,

I am simulating a scenario where in i lost a system datafile and i dint take any back up. The database i sin archive mode.Now i wanted to recover the database.I have googled everywhere and tried different things,but i am not able to recover it. can anybody please provide me a step by step process to recover the system datafile. DO we have to recreate the database?

Thanks,
ranz_bad

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 11 2013

Added on Jun 8 2010

#general-database-discussions

14 comments

12,784 views