Load Ingest Data
Results 1 to 1 of 1

Thread: CDC for Oracle causing errors in LogMiner.

  1. #1
    ven03203 is offline Junior Member
    Join Date
    Apr 2013
    Posts
    1
    Rep Power
    0

    Question CDC for Oracle causing errors in LogMiner.

    We have CDC for Oracle running successfully, however, there is a major side effect.
    On the Oracle server, the logminer has over a million entries like this:

    "there are one million rows in the alert file which start with “LOGMINER”. Of those, about 37,000 rows say “** LOGMINER WARNING - Invalidated 1 LCRs **".
    SERVER:/u01/app/oracle/db/tech_st/11.2.0.3/admin/SERVER_rsdev4/diag/rdbms/SERVER/trace>egrep WARNING alert_SERVER.log |wc
    36964 295709 1626416
    SERVER:/u01/app/oracle/db/tech_st/11.2.0.3/admin/SERVER_rsdev4/diag/rdbms/SERVER/trace>egrep LOGMINER alert_SERVER.log |wc
    984137 5688340 51952268"

    How can I configure either Oracle or Attunity to ensure these messages are not being recorded in the Oracle Logminer?

    Oracle's response has been:
    "Unfortunately these messages can not be suppressed from alert.log
    These messages are expected behavior for LogMiner implementation."

    These entries make managing real errors a serious problem, and unless we find a solution, we may not be able to implement CDC for Oracle in production.
    Last edited by ven03203; 05-13-2013 at 04:26 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •