RE: Oracle recovery

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Mon, 3 May 2004 14:59:34 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B85088B2@okcexg3.kmg.com>

We do full exports on all databases at least once a day for table level recovery if needed. We also do daily hot backups for point in time recovery. I feel there is a need for both.

Ron Smith

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daniel Fink Sent: Monday, May 03, 2004 2:42 PM
To: oracle-l_at_freelists.org
Subject: Re: Oracle recovery

I recall a paper from Oracle (about 5 years ago) that analyzed the various outages, the methods of recovery and how long they took. I have it at home and I'll see if I can get a doc_id from it.

The point I would make with the DBA is that exports are not a recovery mechanism, they are only able to restore to a given point (time of the export) and they do not restore everything (sys objects). With an export, there is no way to roll-forward. Of course, a cold backup w/out archive logs is also unable to roll-forward. All data from the last export and the current time is lost period end of story. Is this acceptable? Perhaps. In certain environments where data loss is not a problem, exports are a pretty simple way of capturing a snapshot of the data. It is also not just 'data' that is lost. It is anything stored inside the db, including procedures, packages, etc. In a development environment, a days worth of coding could easily run into the 10s of 1000s of dollars.

Daniel

"M.Godlewski" wrote:

>=20

> Believe it or not the database I'm currently using the DBA is forcing=20
> us to use exports as our applications recovery scenario. I'm trying=20
> to locate information about archive logging and the tablespace point=20
> in time recovery versus full database recovery. I wanted to find some

> kind of percentages about the number of databases that need full=20
> database recovery (ie applying all archive logs) and percentages of=20
> databases that only needed TSPIR.

>=20

> I thinking if I can get some type of failure rate it could help sway=20
> him into using archive log mode which would give us better recovery
options.

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 Mon May 03 2004 - 14:59:26 CDT