RE: oracle 9i LogMiner

From: Raj Jamadagni <rjamya_at_yahoo.com>
Date: Tue, 3 Aug 2004 03:58:27 -0700 (PDT)
Message-ID: <20040803105827.72551.qmail@web50006.mail.yahoo.com>

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

Received on Tue Aug 03 2004 - 05:54:09 CDT