Re: flashback query vs. log miner

comments embedded
On Fri, 23 Jul 2004 18:06:11 -0400, paula_stankus_at_doh.state.fl.us <paula_stankus_at_doh.state.fl.us> wrote:
> That could be a good article:
>
> -various ways of recovery, what they are, when you might use them...
>
> -recycle bin
> -log minor
> -the old rman restore/recovery
>
> I imagine it is a matter of volume - like one table - recycle/bin or =
> flashback

the recycle bin is 10g only. but yes recycle for small number of dropped objects

flashback, when you want to go back in time -

> Whole database rman

pretty much yes

> Log minor - ???

For recovery scenarios I'd say when you have corrupted a subset of the rows in a table and you want to undo the bad sql.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------