Oracle-L: RE: TSPITR Question

From: <Jared.Still_at_radisys.com>
Date: Wed, 02 Oct 2002 14:08:29 -0800
Message-ID: <F001.004DEA9A.20021002140829@fatcity.com>

Welcome back Babette!

Jared

"Babette Turner-Underwood" <babette_at_rogers.com> Sent by: root_at_fatcity.com
10/01/2002 07:03 PM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Subject:        RE: TSPITR Question

Also only available on Enterprise Edition. - Babette

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

WILLIAMS
Sent: Monday, September 30, 2002 10:03 PM To: Multiple recipients of list ORACLE-L

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

| Brian McGraw /* DBA */ Infinity Insurance | | mailto:Brian.McGraw_at_Infinity-Insurance.com <mailto:Brian.McGraw_at_Infinity-Insurance.com> |

--

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Babette Turner-Underwood
INET: babette_at_rogers.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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Jared.Still_at_radisys.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