RE: oracle 9i LogMiner

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 3 Aug 2004 08:32:59 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D60E9AE65E@EXCHMN3>

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:

Has creating a LogMiner dictionary ever caused anyone a database problem?
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
-----------------------------------------------------------------

Received on Tue Aug 03 2004 - 08:32:55 CDT