RE: Oracle recovery

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Mon, 3 May 2004 14:25:37 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0055D@EXCHMN3>

I think the larger issues are:

What data loss is acceptable? With exports you can only recover to the time of the last export. Archive logging combined with a backup practice such as cold, hot, or RMAN backups can recover to the last transaction.
What is the recovery window? As David says, with just an export to recover from, you may need to perform some work on the database to get it usable for your import. This could take additional time.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of M.Godlewski Sent: Monday, May 03, 2004 2:15 PM
To: oracle-l_at_freelists.org
Subject: Oracle recovery

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_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:29:22 CDT