Showing posts with label Flashback. Show all posts
Showing posts with label Flashback. Show all posts

Wednesday, 19 October 2011

Transaction Management with LogMiner and Flashback Data Archive


LogMiner is an often dismissed yet very strong implement in the Oracle Database. It is employed to extract DML assertions from the redo log files—the primary SQL that produced the transaction and even the SQL that can change back the transactions. (For an introduction to LogMiner and how it works, cite to my Oracle Magazine portion "Mining for Clues.") Until now, this strong implement was ordinarily under-appreciated due to the deficiency of a more simple interface. In Oracle Database 11g, even so, Oracle Enterprise Manager has a graphical interface to extract transaction from the redo logs employing LogMiner,

Blog Loud Easy Steps to Implement Oracle Procedures and Dataguard