RE: LogMiner
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 10 Jun 2004 13:02:47 -0400
-- assumes that dict is available already ...
-- make sure you have tablespace big enough to handle the data you want,
ours is 24GB.
-- rock on
set timing on
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC1_0000016519.arc',d
bms_logmnr.new);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC2_0000016520.arc',d
bms_logmnr.addfile);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC1_0000011763.arc',d
bms_logmnr.addfile);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC1_0000016521.arc',d
bms_logmnr.addfile);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC2_0000011764.arc',d
bms_logmnr.addfile);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC1_0000016522.arc',d
bms_logmnr.addfile);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC1_0000016523.arc',d
bms_logmnr.addfile);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC2_0000011765.arc',d
bms_logmnr.addfile);
exec
dbms_logmnr.add_logfile('/oracle/export/log_miner/ABC1_0000016524.arc',d
bms_logmnr.addfile);
EXEC DBMS_LOGMNR.START_LOGMNR( STARTTIME => to_date('26-SEP-2003
13:00:00', 'DD-MON-YYYY HH24:MI:SS'),-
ENDTIME => to_date('26-SEP-2003 16:00:00', 'DD-MON-YYYY
HH24:MI:SS'),-
DICTFILENAME => '/oracle/export/log_miner/abc_dict.txt');
select count(*) from v$logmnr_contents
/
drop table tom2_logmnr
/
create table tom2_logmnr
tablespace logmnr_data
as
select *
from v$logmnr_contents
/
Commit
/
Now you are free to use tom2_logmnr table from any tool of your choice
(tom is our new dba that's why we name most things after him).
Raj
------------------------------------------------------------------------
--------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
select standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Boyd
Sent: Thursday, June 10, 2004 12:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: LogMiner
Hi List,
We are trying to find out lost transactions from redo logs. Could any
one please share LogMiner scripts with me? We are in Oracle 8.1.7.4 and
Sun Solaris. Thanks.
David
_________________________________________________________________
Stop worrying about overloading your inbox - get MSN Hotmail Extra
Storage!
http://join.msn.click-url.com/go/onm00200362ave/direct/01/
----------------------------------------------------------------
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:
