Wednesday Apr 17, 2013

11gR2 Flashback Guaranteed Restore Point without enabling Flashback logging

Flashback PicturePlenty has been documented and published regarding flashback database since the first implementation in Oracle 10g. However little is documented regarding using flashback restore points in Oracle when the flashback logging (flashback off) is not enabled.

At a client site flashback logging was turned off as a feature due to performance implications, in 11gR2 it is a dynamic online feature that you can now turn flashback on and off without a database bounce. A situation arose and questions were asked regarding the use of guaranteed restore points and flashback logging for  testing purposes.

For reference this paper gives a short summary and example of the Oracle documentation:

Download The Full PDF here: 11gR2_Flashback_Guaranteed_Restore_Point_without_enabling_Flashback_logging.pdf

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
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today