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 to recover without backup

834639Feb 10 2011 — edited Feb 10 2011

hi,

I offlined one of my datafile containing in undo tablespace. Now my database is in mount stage when I tried to open the database it gives me the following error:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00376: file 17 cannot be read at this time
ORA-01110: data file 17: '/misc/live_tbs/undotbstest.dbf'

My database is in noarchive mode plus I dont have a backup.

Thank you for your cooperation.

Regards,

Adnan Hamdus Salam.

This post has been answered by Aman.... on Feb 10 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 10 2011

Added on Feb 10 2011

#general-database-discussions

9 comments

856 views