| 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: TSPITR Question
Brian - Since nobody seems to have responded to your question, yes, there
are plenty of opportunities for "gotchas" with TSPITR. To recover deleted
data, you may want to take a look at LogMiner. Less risk. Normally, to
recover deleted data, you will be performing the TSPITR on a test (or
recovery) database so you avoid losing the data changes that were made to
your production system after the deletion. Otherwise, you are performing a
"full database point in time recovery". The concept behind TSPITR is to
perform recovery on a small subset of your database somewhere separate from
your production database, then once you've recovered the data you need,
export and import it back to the production system.
Without more details on your situation and your experience level, about the most help I can be is to say "take a full backup first".
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, September 30, 2002 4:03 PM
To: Multiple recipients of list ORACLE-L
List -
I have the "opportunity" to learn first-hand about TSPITR today. I need to recover a good bit of data that was recently deleted, and do not have a recent enough export to work from.
My question is this - I'm reading the documentation now, and one of the big, bold Notes is that you should *NOT* try TSPITR for the first time on a production database, or if you have a time constraint. From looking at the instructions, I believe that I understand what to do, and while I would love to test this on another instance, I may not be able to.
So I ask you - do you know of any "gotchas" that I need to be aware of??
Thanks In Advance,
Brian
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Sep 30 2002 - 21:03:18 CDT
 |
 |