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" <[EMAIL PROTECTED]> 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. > > > --- [EMAIL PROTECTED] wrote: > > > > > > > > > > How was the timestamp derived prior to logminer as Point-In-Time > > recovery > > has been around a long time? > > > > Thanks > > Rick > > > > > > > > > > "Scott Canaan" > > > > <[EMAIL PROTECTED]> To: Multiple > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Sent by: cc: > > > > [EMAIL PROTECTED] 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 ([EMAIL PROTECTED]) > > (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).