RE: Oracle recovery
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 3 May 2004 14:25:37 -0500
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@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of M.Godlewski
Sent: Monday, May 03, 2004 2:15 PM
To: oracle-l@xxxxxxxxxxxxx
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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
