| 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
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.
Allan
-----Original Message-----
=46rom: 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 11:00 AM
To: oracle-l_at_freelists.org
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
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe_at_macdill.af.mil
(813) 827-9972 DSN 651-9972=3D20
-- Archives are at http://www.freelists.org/archives/oracle-l/Received on Tue Jun 29 2004 - 11:10:23 CDT
=46AQ is at http://www.freelists.org/help/fom-serve/cache/1.html
----------------------------------------------------------------- ______________________________________________________________________________ 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: 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 -----------------------------------------------------------------
 |
 |