RE: oracle 9i LogMiner
- From: Raj Jamadagni <rjamya@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 3 Aug 2004 03:58:27 -0700 (PDT)
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
-----------------------------------------------------------------
Other related posts:
