Re: Anyone use log miner?

On Jan 14, 9:53 am, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> 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 --

Read here:

http://oratips-ddf.blogspot.com/2008/10/workin-in-mines.html

David Fitzjarrell Received on Thu Jan 14 2010 - 18:51:52 CET