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

you kinda/sorta had to know when it happened and hope for the best.

joe

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