RE: Oracle recovery
- From: April Wells <AWells@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 May 2004 06:25:27 -0500
Good thing they didn't loose that one day's sales!
=)
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: Rachel Carmichael [mailto:wisernet100@xxxxxxxxx]
Sent: Monday, May 03, 2004 10:02 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle recovery
From practical experience (unfortunately):
database exports taken once a day, not in consistent mode. Exports
taken around 6AM.
DB crash HARD at 5PM. Cannot open database, redo logs corrupted,
nothing we did (even with Oracle support on the line) could open the
database. Not "resetlogs", not editing the control file. Nothing.
We needed to get Field Support in to mine the data files using data
unloader because when push came to shove, senior management decided it
was "unacceptable" to lose a day's worth of sales (they didn't realize
this beforehand? Yes, I kept telling them but they had one tape drive
and didn't want to allocate it to me)
It took FORTY-EIGHT HOURS before we were back up and running.
Rachel
The information contained in this communication,
including attachments, is strictly confidential
and for the intended use of the addressee only;
it may also contain proprietary, price sensitive,
or legally privileged information. Notice is hereby
given that any disclosure, distribution, dissemination,
use, or copying of the information by anyone other
than the intended recipient is strictly prohibited
and may be illegal. If you have received this communication
in error, please notify the sender immediately by
reply e-mail, delete this communication, and destroy
all copies.
Corporate Systems, Inc. has taken reasonable precautions
to ensure that any attachment to this e-mail has been
swept for viruses. We specifically disclaim all liability
and will accept no responsibility for damage sustained
as a result of software viruses and advise you to carry
out your own virus checks before opening any attachment.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
