Home » RDBMS Server » Server Administration » Log Miner error
Log Miner error [message #297570] Fri, 01 February 2008 07:04 Go to next message
user82
Messages: 49
Registered: June 2006
Location: Romania
Member
Oracle 10.2.0.1.0
Hi all, I'm facing a strange problem; when i try to gather some data using log miner technology i suddenly get disconnected from oracle
here are the steps i did:
SQL> alter database add supplemental log data;
 
Database altered

SQL> BEGIN
      dbms_logmnr.add_logfile('/oracle/winmdb2/redo01.log');
      dbms_logmnr.add_logfile('/oracle/winmdb2/redo02.log');
      dbms_logmnr.add_logfile('/oracle/winmdb2/redo03.log');
     END;
    /
 
PL/SQL procedure successfully completed

SQL> BEGIN
      DBMS_LOGMNR.START_LOGMNR (
options =>dbms_logmnr.dict_from_online_catalog+dbms_logmnr.print_pretty_sql+dbms_logmnr.no_sql_delimiter);
    END;
   /
 
PL/SQL procedure successfully completed

SQL> select sql_undo, sql_redo
  2    from v$logmnr_contents
  3    where seg_owner = 'WMGABI'
  4  ORDER BY timestamp
  5  /
 
select sql_undo, sql_redo
  from v$logmnr_contents
  where seg_owner = 'WMGABI'
ORDER BY timestamp
 
ORA-03113: end-of-file on communication channel

I tried the above code while connected with system

can anyone give me any suggestion regarding the error I'm facing with ?
Thaks

[Updated on: Fri, 01 February 2008 07:46] by Moderator

Report message to a moderator

Re: Log Miner error [message #297576 is a reply to message #297570] Fri, 01 February 2008 07:46 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Regards
Michel
Previous Topic: Undo tbsp taking more space than the table size
Next Topic: How to properly size the SGA?
Goto Forum:
  


Current Time: Sun Dec 04 19:08:56 CST 2016

Total time taken to generate the page: 0.11629 seconds