Re: Point-In-Time recovery question, Non-RMAN solution

although it is logged in 9i.

joe

Rachel Carmichael wrote:

>You guessed and hoped you were close enough. If you were wrong, you
>repeated the exercise until you found the point in time before the drop
>
>I'm not sure logminer will show you the drop table in any case. At
>least not explicitly as drop table is NOT a logged operation. You might
>see the effect of it on fet$ and uet$ in that extents would be
>released back to the tablespace but if you have locally managed
>tablespaces you'd have to search for the update to tab$ to find the
>time.
>
>
>--- Rick_Cale_at_teamhealth.com wrote:
>
>
>>
>>
>>How was the timestamp derived prior to logminer as Point-In-Time
>>recovery
>>has been around a long time?
>>
>>Thanks
>>Rick
>>
>>
>>
>>
>> "Scott Canaan"
>>
>> <srcdco_at_rit.edu> To: Multiple
>>recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>> Sent by: cc:
>>
>> ml-errors_at_fatcity Subject: RE:
>>Point-In-Time recovery question, Non-RMAN solution
>>
>> .com
>>
>>
>>
>>
>>
>> 11/06/2003 10:09
>>
>> AM
>>
>> Please respond to
>>
>> ORACLE-L
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>Have you looked into using logminer? Even if it can't restore your
>>table, it can give you the exact time that it was dropped.
>>
>>Scott Canaan (srcdco_at_rit.edu)
>>(585) 475-7886
>>"Life is like a sewer, what you get out of it depends on what you put
>>into it." - Tom Lehrer.
>>
>>
>>-----Original Message-----
>>Sent: Thursday, November 06, 2003 8:45 AM
>>To: Multiple recipients of list ORACLE-L
>>
>>
>>
>>
>>
>>Hi DBAs,
>>
>>Oracle 8i, ArchiveLog, No RMAN
>>Testing Point-In-Time Recovery
>>
>>I am confused on what time to substitute in the RECOVER DATABASE
>>UNTIL
>>TIME
>>'timestamp';
>>
>>For example 2 days ago 11/04/2003 approximately 17:00 I drop a table.
>>Today I decide I want that table back. I want to do an incomplete
>>recovery
>>to get the table back.
>>How do I know what timestamp to use? I have an idea the I dropped
>>the
>>table but not exact.
>>
>>
>>1. SHUTDOWN Normal
>>2. BACKUP current database
>>3. Restore datafile that has the table in it.
>>4. connect internal
>>5. startup mount
>>6. recover database until time 'timestamp??????';
>>7. Alter database open resetlogs;
>>8. BACKUP current database
>>
>>Step 5 is my confusion.
>>
>>Also I assume all data is now lost since last archive restored to
>>the
>>present.
>>The only way I know to get that data back is to
>>1. Export the table that was dropped.
>>2. Restore database from step2
>>3. Import table from step1
>>
>>Is there better ways.
>>
>>Thanks
>>Rick
>>
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>>--
>>Author:
>> INET: Rick_Cale_at_teamhealth.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.net
>>--
>>Author: Scott Canaan
>> INET: srcdco_at_rit.edu
>>
>>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.net
>>--
>>Author:
>> INET: Rick_Cale_at_teamhealth.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).
>>
>>
>
>
>__________________________________
>Do you Yahoo!?
>Protect your identity with Yahoo! Mail AddressGuard
>http://antispam.yahoo.com/whatsnewfree
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Testa
  INET: oracle-l_at_oracle-dba.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).