Re: deleted undotbs01.dbf...

On Aug 1, 11:13 am, Krish <Krishna.Bu..._at_gmail.com> wrote:
> On Aug 1, 10:50 am, de12261 <de12..._at_gmail.com> 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
>
> Try this
>
> SQL> startup mount
>
> SQL> Alter database datafile < datafile path or file number> offline
> drop;
>
> SQL> alter database open;
>
> Then
> * create a new Undo Tablespace
> * Make the newly created Undo tablespace as default undo
> tablespace
> * drop the old undo tablespace.
>
> Thanks,
> Krishna- Hide quoted text -
>

I tested this script and worked for me on my laptop ( running Oracle 10.2.0.1 on windows).

Check your alert log for a more descriptive report of the exact startup problem. post if you find any new error messages .

Krishna. Received on Wed Aug 01 2007 - 10:43:17 CDT