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!

Undo tablespace currupt and no clean backup

user599727Aug 23 2008 — edited Nov 29 2012

Hello,

We are facing critical problem with database. We have not any clean backup and database in no archive log mode. Suddenly database is shutdown and when we are trying to open database it is giving error:-

ORA-01172: recovery of thread 1 stuck at block 350230 of file 3
ORA-01151: use media recovery to recover block, restore backup if needed

File 3 is Undo file.

Is there any way to open database?

Thanks in advance and please reply us ASAP.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 21 2008

Added on Aug 23 2008

#general-database-discussions

8 comments

7,488 views