Re: disk crash no mirror, NOARCHILEG mode, and NO BACKUP, some datafiles & undo missing

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Wed, 28 Feb 2007 21:35:48 +0700
Message-ID: <3edcb66e0702280635t69019ce5h8ae6a24f32bcd1c9@mail.gmail.com>

ops...

got a bit info:

Wed Feb 28 21:33:23 2007
Errors in file /oracle1/product/orabase/admin/DWOR/udump/dwor_ora_4233.trc:

ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 2
ORA-00376: file 93 cannot be read at this time
ORA-01110: data file 93: '/oracle5/oradata/DWOR/undotbs04.dbf'

Wed Feb 28 21:33:23 2007
Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Instance terminated by USER, pid = 4233
ORA-1092 signalled during: ALTER DATABASE OPEN...

any ideas?

regards
ujang

On 2/28/07, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> Ujang,
>
>
>
> You did just about everything the wrong way that you possibly could do.
> You missed having only one control file on the lost disk.
>
>
>
> Have you contacted Oracle Support yet? No matter what happens, the data
> in the lost data files is gone. You might be able to comment out the
> undo_tablespace parameter in the init.ora file to get the database back
> up, and then bring the data files on line one at a time. But then you will
> run into recovery problems.
>
>
>
> You might be hosed. Start looking for your database create scripts.
>
>
> Tom
>
>
> ------------------------------
>
> This transmission may contain confidential, proprietary, or privileged
> information which is intended solely for use by the individual or entity to
> whom it is addressed. If you are not the intended recipient, you are
> hereby notified that any disclosure, dissemination, copying or distribution
> of this transmission or its attachments is strictly prohibited. In
> addition, unauthorized access to this transmission may violate federal or
> State law, including the Electronic Communications Privacy Act of 1985. If
> you have received this transmission in error, please notify the sender
> immediately by return e-mail and delete the transmission and its
> attachments.
>
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Ujang Jaenudin
> *Sent:* Wednesday, February 28, 2007 8:46 AM
> *To:* oracle-l_at_freelists.org
> *Subject:* disk crash no mirror, NOARCHILEG mode, and NO BACKUP, some
> datafiles & undo missing
>
>
>
> folks,
>
> and luckily user was SHUTDOWN ABORT database after make datafiles OFFLINE,
> so when startup, it always try to find the missing undo file.....
> this is worst case, please help me on this situation......
>
>
> regards
> ujang
>
>

-- 
regards
ujang

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 28 2007 - 08:35:48 CST