| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question of degrees in Oracle DB recovery
Forward recovery is a standard for all production databases. Turn on
archiving and mirror the online redo logs then you can apply the archived
redo logs to the cold backup and provide forward recovery capacity for all
but catastrophic losses when the disaster recovery plan comes into effect.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Wolfe Stephen S GS-11
6 MDSS/SGSI
Sent: Tuesday, June 29, 2004 12:00 PM
To: oracle-l_at_freelists.org
Subject: Question of degrees in Oracle DB recovery
First off, I'm an Oracle newbie for sure. My main question now is more
DR policy/intent
Oriented than technical. I'm still in the discovery process of all the
ways an Oracle instance can be recovered, I'm now reading a PDF on
online point-in-time recovery strategies and this is where I have a
question.
How many of you guys provide as close as possible to the transaction-on-the-fly point-in-time recovery?
Currently, we do only an offline, once a day backup to a SAN on two Oracle applications. I was asked last Friday if we had a catastrophic failure (server destruction or totally non-recoverable disk failure) how would I recover our TPOCS database. I replied I could recover to whatever was there at 00:15 that day, because, with Crondsys we stop the database, then backup the entire Oracle directory and all of its subdirectories (I was told I actually only needed to keep the oradata folder but we have a large SAN so why not get all the stuff config file, etc) and an interface directory where daily interface files and archives are kept from a system that sends data to TPOCS via importable text delimited flat files.
I received a few concerned looks because the using departments were under the impression that I could bring them back to just before the failure. I can't and the vendor that was tasked to provide the database application was only tasked to provide a 24 hour backup scenario. If a site wants anything better they have to do it on their own after submitting the plan and procedures to the tier 3 helpdesk (the vendor) for approval.
I am doing a lot of reading right now, but I would like to get your ideas on the cost and complexity of getting a true PIT recovery system in place or can a near PIT be established like configuring the redo logs to reside on the SAN instead of the local server?
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9972 DSN 651-9972=20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |