- 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Boyd
Sent: Thursday, June 10, 2004 12:38 PM
To: oracle-l_at_freelists.org
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_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 Thu Jun 10 2004 - 12:00:22 CDT
