Home » RDBMS Server » Server Utilities » LOGMINER -- ORA-06512: at "SYS.DBMS_LOGMNR",
LOGMINER -- ORA-06512: at "SYS.DBMS_LOGMNR", [message #219955] Fri, 16 February 2007 23:51 Go to next message
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
Re: LOGMINER -- ORA-06512: at "SYS.DBMS_LOGMNR", [message #220160 is a reply to message #219955] Mon, 19 February 2007 04:47 Go to previous message
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
Member
Hi,

Instead of SCN when i go for Time, then i got the same error, can anybody help me out!!

Amit
Previous Topic: Not Null Constraints Disappeared after import
Next Topic: NLS_LANGUAGE
Goto Forum:
  


Current Time: Sat Dec 03 09:42:16 CST 2016

Total time taken to generate the page: 0.05940 seconds