Tuesday Feb 26, 2013

Oracle LogMiner: Seven Steps to Mine Redo data

Log_minerWhilst on a client site it was requested to investigate a data issue where data had been deleted by an unknown source to the application team within an Oracle database table.  After attempting to use Oracle flashback techniques it could be seen this was insufficient due to the changes occurring a few days previous.  Therefore Oracle log miner was used to locate the required information, analyzing the Oracle redo logs and archive logs.  It was clear that the usage of this tool is widely unknown to a lot of administrators therefore this paper gives a simple seven step process on how to safely implement an Oracle log mining session to look at database redo data. Although this can be implemented through Oracle enterprise manager (OEM), the techniques shown here are using Oracle SQL and PL/SQL.

Please Note these scripts were written only for demonstration purposes. They are not optimized and they have almost no error checking, so be careful!

Download The Full PDF here: Oracle_Log_Mining_Data.pdf
About

About Me Image
Andy Baker, Senior Principal Consultant for Oracle Consulting Services (@Bakers_byte), shares his news, views and ideas about the Oracle Database with a focus on innovation and emerging technologies.

Search

Archives
« February 2013 »
SunMonTueWedThuFriSat
     
2
3
4
5
6
8
9
10
11
13
14
15
16
17
18
19
20
21
22
23
24
25
27
28
  
       
Today