Extracting transnational entry from an archivelog file

Getting the general information

First we have to location the information for our report:

Extract the ROW ID

Once we have the retail file and the position number, we can use the logdump utility, located in the folder as the ggsci utility:

Extract the archivelog Using LogMiner

Once we have the row ID and the archivelog file, both described up, we can extract the records from the archivelog file, using the LogMiner from the source database, as described below:

You can also use the following select to see the exact archivelog when the change happened. Remember that the archivelogs are keeping data for ALREADY Done changes, therefore, if the redo logs was created at 16:30, then this redo log holds the changes prior 16:30

The output will be something similar: