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

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • Date: Wed, 28 Feb 2007 21:35:48 +0700

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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Ujang Jaenudin
*Sent:* Wednesday, February 28, 2007 8:46 AM
*To:* oracle-l@xxxxxxxxxxxxx
*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

Other related posts: