oh god I was teasing about flashback query! I don't really think it's
robust enough for production recoveries. Technically you don't need
server-managed undo to use flashback query, it will work with manually
managed rollback segments. But you have less of a chance for the data
to still be in the rollback segment than you do with automatic undo
management.
and I've done the recover table from backup -- in fact that's what we
did, on a 7.3.4 database when the programmer did an update without the
where clause and then committed the transaction. although we used a
database link and did our own update of the original data back into the
production database as we couldn't take the table away from the app and
it was historical data that had been changed.
As for those developer flashbacks, see above. He did live after I got
through with him. barely. :)
- Jeremiah Wilton <jwilton_at_speakeasy.net> wrote:
> It is pretty easy to restore and recover a single table to an
> arbitrary point in time from a physical backup. I don't think Oracle
> needs to provide an extra feature.
>
> You restore a small subset of the database (system, rollbacks and the
> tablespace with the table in it), offline drop the datafiles you
> didn't restore, and roll the "mini-clone" forward to the point in
> time
> you want.
>
> Export/import the table from the "mini-clone" into the original
> database via named pipes.
>
> Query flashback won't work past a certain timeframe, and it won't
> work
> on tables that have been mangled by DDL (drop/truncate). And you
> have
> to use server-managed undo to use query flashback.
>
> Personally, there are a lot of queries the developers here have come
> up with that I have flashbacks of anyway, usually around 3 or 4 in
> the
> morning.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> On Tue, 28 May 2002, Rachel Carmichael wrote:
>
> > isn't that supposed to be flashback query? :)
> >
> > --- Gene Sais <Gsais_at_co.palm-beach.fl.us> wrote:
> > > maybe 10i will allow table pt in time recovery :)
> > >
> > > >>> wisernet100_at_yahoo.com 05/25/02 05:53PM >>>
> > > you mean the export? it's a lot easier to recover a single table
> from
> > > an export and let everyone else keep working. AFAIK, Oracle still
> > > doesn't do table-level recovery, the lowest granularity is
> > > tablespace.
> > >
> > > Also, exports are good at letting you clone users and application
> > > schemas
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeremiah Wilton
> INET: jwilton_at_speakeasy.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Received on Tue May 28 2002 - 11:38:33 CDT