Skip to Main Content
Forums

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!

Create undo tablespace while at mount state, possible?

sape007Sep 1 2008 — edited Sep 1 2008
Oracle 10g (10.2.0.1.0), on RedHat 4 (both 64 bit)

My test db’s undo tablespace is corrupt (no RMAN or user backups).
DB fails to open, fails during 
"Doing block recovery for file 2 block 209910"
Is there a way of creating undo tablespace while at mount state?

I am pretty confident it’s not possible, also searched the net and found no fix, I thought I will ask.

I get error:


CREATE UNDO TABLESPACE UNDOTBS1_new DATAFILE  '/u01/oracle/oradata/TEST_DB1/undotbs2_01.dbf' SIZE 512M
*
ERROR at line 1:
ORA-01109: database not openp{code}As a last option, I will open the db with *'reset logs'*, wondering is any thing else I can try to fix the issue.

Thanks for any input.
This post has been answered by 525507 on Sep 1 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2008
Added on Sep 1 2008
#general-database-discussions
2 comments
2,103 views