Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with recovery
kevinmmcgowan_at_yahoo.com (Kevin) wrote in message news:<288965ad.0404280845.37533c29_at_posting.google.com>...
> I need to restore a table to its state this morning. Unfortunately,
> don't have any exports recently and would essentially like to rollback
> everything previous to 945 this morning. It looks like I can
> accomplish this using the RECOVER command (yes, I understand I'm going
> to have to recover the whole database, I can deal with that). I just
> want to make sure there's nothing else I need to do besides RECOVER
> DATABASE UNTIL TIME '2004-04-28:09:00:00'
>
> Thanks in advance
Don't forget to post platform and version info. 10g has flashback table command, but requires some configuration and thought to be able to go back more than 15 minutes. It's kind of the opposite of archive logging.
jg
-- @home.com is bogus. "How many people here are using RAC?" 2 people raise hands, out of ~70 DBA's.Received on Wed Apr 28 2004 - 18:47:19 CDT