| LOGMINER -- ORA-06512: at "SYS.DBMS_LOGMNR", [message #219955] |
Fri, 16 February 2007 23:51  |
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
|
Member |
|
|
Dear All,
I want to take the sql statements run between two SCN. For that I used LOG-MINER, but unfortunately i stuck in one place, below is the procedure which i run to get the desired information. Can any body help me out.
sql> select * from v$loghist;
THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIME SWITCH_CHANGE#
---------- ---------- ------------- ------------------- --------------
1 3926 152474038 2007-02-15:16:09:46 152477773
1 3927 152477773 2007-02-15:16:46:31 152480335
1927 rows selected.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- -------------------
1 1 3927 10485760 2 YES ACTIVE
152477773 2007-02-15:16:46:31
2 1 3926 10485760 2 YES INACTIVE
152474038 2007-02-15:16:09:46
3 1 3928 10485760 2 NO CURRENT
152480335 2007-02-15:17:17:27
SQL> begin
2 DBMS_LOGMNR_D.build (
3 dictionary_filename => 'vtbmig1502.ora',
4 dictionary_location => '/tmp');
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> begin
2 DBMS_LOGMNR.add_logfile (
3 options => DBMS_LOGMNR.new,
4 logfilename => '/oradata/vtbmig/dbs/vtbmig1log1.log');
5 end;
6 /
PL/SQL procedure successfully completed.
SQL> begin
2 DBMS_LOGMNR.add_logfile (
3 options =>
4 DBMS_LOGMNR.addfile,
5 logfilename => '/oradata/vtbmig/dbs/vtbmig2log1.log');
6 end;
7 /
PL/SQL procedure successfully completed.
SQL> begin
2 DBMS_LOGMNR.add_logfile (
3 options => DBMS_LOGMNR.addfile,
4 logfilename => '/oradata/vtbmig/dbs/vtbmig3log1.log');
6 end;
7 /
PL/SQL procedure successfully completed.
SQL> begin
2 DBMS_LOGMNR.start_logmnr (
3 dictfilename => '/tmp/vtbmig1502.ora',
4 startscn => 3926,
5 endscn => 3927);
6 end;
7 /
begin
*
ERROR at line 1:
ORA-01291: missing logfile
ORA-06512: at "SYS.DBMS_LOGMNR", line 53
ORA-06512: at line 2
Thanx
Amit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
