By AndyBaker on Feb 26, 2013
Whilst 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