Re: Anyone use log miner?
Date: Thu, 14 Jan 2010 06:53:44 -0800 (PST)
Message-ID: <d728c078-da97-4187-a526-4afebea79a86_at_m26g2000yqb.googlegroups.com>
[Quoted] On Jan 13, 1:07 pm, The Magnet <a..._at_unsu.com> wrote:
> Hi,
>
> I've been looking over ON & Metalink with no luck, We have to
> restore some data and are looking through the logs. But the changes
> took place via a stored procedure using passed parameters and it looks
> like the parameters are not resolved in the logs. Are we SOL? Or is
> there another way.
>
> Wish RMAN did table level restores.
>
> Thanks!
Where Log Miner is documented depends on your release. See Oracle support document How to Setup LogMiner #111886.1 for help.
Oracle8i Administrator's Guide, Release 8.1.6 Oracle8i Administrator's Guide, Release 8.1.7 Oracle9i Database Administrator's Guide Release 2 (9.2)
OracleŽ Database Utilities 10g Release 1 (10.1) OracleŽ Database Utilities 10g Release 2 (10.2) OracleŽ Database Utilities 11g Release 1 (11.1)
While the actual procedure parameters may not be part of the redo log the DML executed by the procedure will be. Log Miner will generate the SQL necessary to backout each change.
HTH -- Mark D Powell -- Received on Thu Jan 14 2010 - 15:53:44 CET