Re: LogMiner question

From: Howard J. Rogers <howardjr_at_www.com>
Date: Tue, 20 Mar 2001 18:13:18 +1100
Message-ID: <3ab70326@news.iprimus.com.au>

<u132781982_at_spawnkill.ip-mobilphone.net> wrote in message news:l.985043610.1821929931@[198.138.198.252]...
> Hi, Folks,
>
> We are interested in using LogMiner
> for auditing the access of a table
> without turning on the audit. But
> from my understanding of reading,
> everytime you want to analyze the redo
> logs, you have to shutdown and mount
> the database, is that true?

Utterly, utterly UNtrue. Log Miner is most frequently applied to archived redo logs, which are not part of the database anyway, and the view to see the contents of the logs is a V$ (V$logmnr_contents, actually), so naturally the database has to be open to be able to do meaningful work with such a view.

Having said it's good for archives, it can quite happily read the contents of current and active online redo logs, too. And absolutely no shutdown is required, ever (except to set the thing up -there has to be a utl_file_dir parameter set in your init.ora. One bounce should do it, however).

>
> We are running 24 x 7 database, so we
> can not use this new feature, is it right?
>

No, it's totally wrong. This is an excellent audit utility for 24x7 shops.

Regards
HJR
> Thanks for your help.
>
>
>
>
> --
> Sent by dbadba62 from hotmail piece from com
> This is a spam protected message. Please answer with reference header.
> Posted via http://www.usenet-replayer.com/cgi/content/new
Received on Tue Mar 20 2001 - 01:13:18 CST