RE: oracle 9i LogMiner

From: Raj Jamadagni <rjamya_at_yahoo.com>
Date: Tue, 3 Aug 2004 07:12:26 -0700 (PDT)
Message-ID: <20040803141226.12669.qmail@web50009.mail.yahoo.com>

Dennis,

You are welcome ... we learned it the hard way.

To answer your questions ...

No, it is generally very fast operation.
We build dictionaries for all production databases on a daily basis at 5:50am through cron. We also re-build them on demand if there is a need.

Yes, we have (somewhat) strict change management, but operations like logminer and related tasks fall under (what is broadly catagorized as) "DBA Essentials", so are exempt from strict change controls and we have freedom to manipulate them. This was granted because building a text file (dictionary) has no business impact whatsoever, apart from some disk consumed, but then again disk is cheap 8:)

Plus to make the powers to be happy, we move archive files etc using backup private networks so we don't impact interconnects and public network when we move huge amount data across different nodes. Multiple network paths rock !!

Cheers
Raj

DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:

> Raj
> Thanks. Excellent tip. My problem was that I hadn't previously used
> LogMiner, so I wasn't sure how harmless it is to create a dictionary. Also,
> I thought maybe LogMiner would treat the databases as identical -- learned
> that ain't so.
> But even without a dictionary, LogMiner did yield a lot of useful
> information.
> This brings up a couple of questions for the list:
> 1. Has creating a LogMiner dictionary ever caused anyone a database
> problem?
> 2. If your site is under change management, do you file a change request
> in order to create a LogMiner dictionary?
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
>
> "We all want progress, but if you're on the wrong road, progress means
> doing an about-turn and walking back to the right road; in that case,
> the man who turns back soonest is the most progressive."
> -- C.S. Lewis
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Raj Jamadagni
> Sent: Tuesday, August 03, 2004 5:58 AM
> To: oracle-l_at_freelists.org
> Subject: RE: oracle 9i LogMiner
>
>
> No true,
>
> I do this on a regular basis ...
>
> Step 1. Create dictionary
> Step 2. scp archive files from both nodes on RAC to a development box.
> Step 3. Fireup logminer script to load all archive files needed
> Step 4. Create physical table as select * from v$logmnr_contents [with
> optional where_clause]
>
> Never fails. But if you don't have the exported dictionary, yes you'll see
> hex data.
>
> Raj
>
> --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
>
> > Greg
> > DON'T try to read log files on a different instance (read production
> > files on a test instance) even if the one is a clone of the other. To
> > Logminer they are different databases and so it shows you everything in
> > hexadecimal, which can be amusing and challenging for awhile but the
> > enchantment quickly wears thin.
> >
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
>
>
> =====
> Best Regards
> Raj
> ---------------------------------------------------------
> select mandatory_disclaimer from company_requirements;
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
> http://promotions.yahoo.com/new_mail
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>

Best Regards
Raj

select mandatory_disclaimer from company_requirements;

Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail

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
-----------------------------------------------------------------

Received on Tue Aug 03 2004 - 09:08:11 CDT