RE: Oracle recovery

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Tue, 4 May 2004 08:46:54 -0400
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA656D8487@25exch1.vicorpower.vicr.com>

Rachel,

And how many thousands of $$$???

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Rachel Carmichael [mailto:wisernet100_at_yahoo.com] Sent: Monday, May 03, 2004 11:02 PM
To: oracle-l_at_freelists.org
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

"M.Godlewski" <mcgodlewski_at_yahoo.com> wrote:
> Believe it or not the database I'm currently using the DBA is forcing
> us to use exports as our applications recovery scenario. I'm trying
> to locate information about archive logging and the tablespace point
> in time recovery versus full database recovery. I wanted to find
> some kind of percentages about the number of databases that need full
> database recovery (ie applying all archive logs) and percentages of
> databases that only needed TSPIR.
> =20
> I thinking if I can get some type of failure rate it could help sway
> him into using archive log mode which would give us better recovery
> options.
> =20
> =20
>=20
> =09
> ---------------------------------
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs=20
>=20
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

=09

Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs =20 http://hotjobs.sweepstakes.yahoo.com/careermakeover=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 04 2004 - 07:44:04 CDT