What is LogMiner in Oracle 11g?
Oracle LogMiner, which is part of Oracle Database, enables you to query online and archived redo log files through a SQL interface. Redo log files contain information about the history of activity on a database.
What is database log mining server?
LogMiner enables the analysis of the contents of archived redo logs. It can be used to provide a historical view of the database without the need for point-in-time recovery. It can also be used to undo operations, allowing repair of logical corruption.
What is LogMiner in Oracle GoldenGate?
STREAM_POOL_SIZE [4] is a database initialization parameter and is part of Oracle Database SGA (System Global Area). It is the memory used by logminer server. As an Oracle GoldenGate best practice, it is recommended to keep an additional 25% of memory for other processing.
Is Logminer free?
Logminer was the cost-free API provided by Oracle to achieve what some thought was the answer to capturing up to the second changes in their Oracle database.
What is the purpose of the Oracle LogMiner?
Oracle LogMiner, which is part of Oracle Database, enables you to query online and archived redo log files through a SQL interface. Redo log files contain information about the history of activity on a database. This chapter contains the following sections:
How can I use LogMiner from a command line?
You can use LogMiner from a command line or you can access it through the Oracle LogMiner Viewer graphical user interface. Oracle LogMiner Viewer is a part of Oracle Enterprise Manager.
What is the 11g OEM interface for LogMiner?
This new feature of 11g OEM provides an integrated interface for the DBA to use for LogMiner. The graphical interface allows the DBA to extract transactions from the redo logs to examine and flashback a transaction if desired. The LogMiner interface in OEM provides DBAs with an intuitive, easy to use tool for several purposes:
Where can I use LogMiner to analyze redo log files?
The mining database, where LogMiner actually analyzes the redo log files, is in San Francisco. The Boston database is running Oracle Database 12g and the San Francisco database is running Oracle Database 19c. This example shows just one valid LogMiner configuration.
