Stack Overflow
Stack Overflow

Questions tagged [logminer]

The Oracle database utility LogMiner is used to query redo log files via SQL to get information about activity in the database. Include tags for oracle and tag for specific version of oracle.

The LogMiner utility is slowly being deprecated. Its functionality is being replaced with the Oracle GoldenGate product.

Use this tag for questions regarding usage of the LogMiner utility. Be sure to include the tag and appropriate Oracle database version tag such as .

Documentation

Using LogMiner to Analyze Redo Log Files

15 questions
9
votes
3 answers

In Oracle 12c R2 does LogMiner support Table/Column names longer than 30 characters?

So far, any table that has a column name longer than 30 characters gives an UNSUPPORTED Operation when querying V$LOGMNR_CONTENTS If I drop the column or adjust the size to be <=30 then all the CRUD operations are reported fine. In Oracle 12.2 128…
Brandon Billingham
  • 163
  • 7
2
votes
0 answers

Log Miner unable to capture data

I am using virtual machine in which I have pre-installed Oracle 12c with pluggable database orcl. I need to enable log miner on that oracle in order to capture changed data. I have written a Java utility which reads redo logs of oracle and creates a…
Varun Karambelkar
  • 21
  • 1
2
votes
1 answer

Getting the writable operation error while using oracle cdc

I am getting the following error while connecting through oracle cdc client and my origin database is read only database but the error is database required for writable operation. please help Caused by: java.sql.SQLException: ORA-01300: writable…
Kum
  • 31
  • 5
1
vote
1 answer

Replacement of the obsolete commande UTL_FILE_DIR

Am a beginner, and i want to use LogMiner in Oracle DB 21c, and in one of the steps was to : to set UTL_FILE_DIR to use /oracle/database as the directory where the dictionary file is placed I tried this commande : alter system set UTL_FILE_DIR =…
Marwane
  • 333
  • 3
  • 13
1
vote
1 answer

Oracle LogMiner Results Inconsistent

I'm working on a LogMiner-based solution for capturing changes and I've uncovered what appears to either an unusual set of expectations when attempting to mine redo events that pertain to CLOB or BLOB operations. In my use case, I've inserted record…
Naros
  • 19,928
  • 3
  • 41
  • 71
1
vote
0 answers

ORA-01292: Can't access log file with log miner while using online catalog

I'm currently trying to add logminer to my Oracle database. The goal is to use le online catalog but when i use : EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); to start the log miner i get this error : ORA-01292:…
V.Jauneau
  • 21
  • 5
1
vote
2 answers

Timezone for COMMIT_TIMESTAMP in V$LOGMNR_CONTENTS

In V$LOGMNR_CONTENTS dictionary view the TIMESTAMP and COMMIT_TIMESTAMP columns are of DATE data type - without any timezone information. So which timezone are they in - database timezone, host timezone, or UTC? Is there a database parameter to…
Raihan
  • 10,095
  • 5
  • 27
  • 45
0
votes
0 answers

Debezium Connector: Capture changes starting from specific SCN

I wonder whether I can start capturing changes from specific Oracle SCN using Debezium Connector (LogMiner enabled), the official spec states only two properties that I can tune: log.mining.scn.gap.detection.gap.size.min - Specifies the minimum gap…
Rower33
  • 11
  • 1
  • 3
0
votes
0 answers

LOGMINER logging in alert log

I have a business process that uses Oracle LogMiner periodically and I notice that every time the LogMiner API is invoked by this process, the database writes a number of entries to the alert log. Is there any way to customize or reduce the…
Naros
  • 19,928
  • 3
  • 41
  • 71
0
votes
1 answer

Oracle RDS Logminer ORA-01291 Missing Log File?

I have an Oracle RDS database I manage, and I need to be able to pull changes from the database for replication to another system. Once connect to the database, below is the commands I run. EXEC…
js1983
  • 310
  • 2
  • 12
0
votes
1 answer

Debezium Connector tries to open old log file

I have a debezium connector that works fine, for a limited time. These errors occur in log file: Caused by: java.sql.SQLException: ORA-00308: cannot open archived log…
Bünyamin Şentürk
  • 620
  • 5
  • 20
0
votes
1 answer

How to join DBA_HIST_* tables with V$LOGMNR_CONTENTS table - Oracle DB

I have to collect some info in a both of redo log and dba_hist_* table (e.g DBA_HIST_SQLTEXT, DBA_HIST_SQL_PLAN, DBA_SQLSET_PLANS). Because some info i needed not exists in redo log but exists in dba table. I tried join via transaction id (binary…
qxk71551
  • 95
  • 9
0
votes
2 answers

Oracle's V$LOGMNR_CONTENTS for a table with a UDT - connecting UPDATE and INTERNAL operations

I'm updating an oracle table with a UDT (user defined type), and then querying the V$LOGMNR_CONTENTS view. I'm seeing that for each row updated there are 2 records - UPDATE and INTERNAL. I need to figure out how to link between them as the UPDATE…
ihadanny
  • 4,377
  • 7
  • 45
  • 76
0
votes
1 answer

Trouble with Oracle 11.2.0.3 redo logs

I have a table in oracle 11.2.0.3 that I want to capture in the redo logs. The issue is that it has an sdo_geometry field. This is a legacy table that I can not change. But the good news is I do not need that sdo_geometry field. So I have created a…
Patrick O'Brien
  • 3
  • 2
0
votes
1 answer

Stored Procedure starts logminer in same session every run

I've created an oracle stored procedure to fetch data from logminer based on transaction rowid and timestamp. the procedure should try to select from logminer and if it fails as logminer is started on this session it should start it and select the…
Omar Moghazi
  • 23
  • 6