Re: flashback query vs. log miner
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 24 Jul 2004 13:40:21 +0100
comments embedded
On Fri, 23 Jul 2004 18:06:11 -0400, paula_stankus@xxxxxxxxxxxxxxx
<paula_stankus@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
