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

I think it is possible to enable DDL command logging in 9i, it can be used in logical standby.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 06, 2003 6:09 PM

> 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: Rachel Carmichael
> INET: wisernet100_at_yahoo.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: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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