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

  • From: "Mercadante, Thomas F \(LABOR\)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <ujang.jaenudin@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Feb 2007 09:23:58 -0500



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.



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



and luckily user was SHUTDOWN ABORT database after make datafiles
OFFLINE, so when startup, it always try to find the missing undo
this is worst case, please help me on this situation......


Other related posts: