RE: Question of degrees in Oracle DB recovery
- From: "Nelson, Allan" <anelson@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 29 Jun 2004 11:12:39 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Wolfe Stephen S
GS-11 6 MDSS/SGSI
Sent: Tuesday, June 29, 2004 11:00 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxx
(813) 827-9972 DSN 651-9972=3D20
----------------------------------------------------------------
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/
=46AQ is at //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@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:
