Re: Oracle recovery
- From: Rachel Carmichael <wisernet100@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 3 May 2004 20:01:39 -0700 (PDT)
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@xxxxxxxxx> 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.
>
> 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.
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
----------------------------------------------------------------
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:
