Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Question of degrees in Oracle DB recovery

RE: Question of degrees in Oracle DB recovery

From: Nelson, Allan <>
Date: Tue, 29 Jun 2004 11:12:39 -0500
Message-ID: <>

You don't really need TSPITR if you loose the whole db. What you would need is to be running the database in archive log mode and be backing up both the database files and all archived logs. Your cold backup could then be flexibly rolled forward to what ever point in time you wanted to.

TSPITR on the other hand allows you to work at the single tablespace level. Suppose someone drops an object or commits something that they really didn't want to. Or suppose that someone deletes a file from a tablesapce by accident. These are example scenarios where TSPITR would be used.


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

[] On Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI
Sent: Tuesday, June 29, 2004 11:00 AM
Subject: Question of degrees in Oracle DB recovery

=46irst 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=3F

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
=66ailure (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
=66older 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
=66ailure. 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)
=66or 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=3F


Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
(813) 827-9972 DSN 651-9972=3D20

Please see the official ORACLE-L FAQ:

To unsubscribe send email to: put 'unsubscribe' in the subject line.
Archives are at

=46AQ is at
----------------------------------------------------------------- ______________________________________________________________________________ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: ---------------------------------------------------------------- To unsubscribe send email to: put 'unsubscribe' in the subject line. -- Archives are at FAQ is at -----------------------------------------------------------------
Received on Tue Jun 29 2004 - 11:10:23 CDT

Original text of this message