RE: oracle 9i LogMiner
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 3 Aug 2004 08:32:59 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Raj Jamadagni
Sent: Tuesday, August 03, 2004 5:58 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
