Re: deleted undotbs01.dbf...

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 01 Aug 2007 08:27:40 -0700
Message-ID: <1185982058.243316@bubbleator.drizzle.com>

de12261 wrote:
> On 1 Ago, 16:30, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:

>> Since the only rollback segment available would be the SYSTEM rollback
>> segment I doubt even that would get this database open; it might allow
>> it to mount, however, which may be enough to create a new undotbs1.dbf
>> file.
>>
>> It's probably worth a try; as I said earlier any port in this storm is
>> better than no port at all.
>>
>> David Fitzjarrell

>
>
> Hello
>
> i cannot open...
> when I try "alter database open" it gives me the error ORA-01092:
> oracle instance terminated....
>
> so I cannot create a new undo tablespace...
>
>
> is there any other solution to recreate a tablespace????
>
> they do not have a backup ...
>
> :-(
>
> thank you

Push yourself away from the keyboard and stop doing stuff.

You are as likely to be making things worse as better.

Go to metalink.oracle.com and open an SR.

And generic advice to everyone and anyone: If you aren't doing regular backups with RMAN seriously consider getting another form of employment.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Wed Aug 01 2007 - 10:27:40 CDT