LogMiner Functionality Without Supplemental Logging in Oracle 11g
Contrary to common assumptions, Oracle LogMiner can operate—even without supplemental logging—under certain conditions in Oracle 11g. This behavior was verified on Oracle Database 11g Enterprise Edition 11.2.0.1.0 (64-bit), where V$DATABASE.SUPPLEMENTAL_LOG_DATA_MIN reported 'NO', yet LogMiner successfully reconstructed DML statements for newly ...
Posted on Fri, 15 May 2026 03:19:10 +0000 by sgs-techie
Understanding Oracle System Change Numbers and Their Role in Database Recovery
System Change Number (SCN) Fundamentals
The SCN (System Change Number) serves as Oracle's internal timestamp mechanism for tracking data base modifications. It represents a logical ordering point at which database changes occur, enabling the database to query and track modifications with precision.
Each transaction within Oracle follows a seque ...
Posted on Tue, 12 May 2026 23:03:21 +0000 by jumpfroggy