Some DDL statements that you issue cause Oracle to internally execute one or more other DDL statements. Reapplying DDL Statements Returned to V$LOGMNR_CONTENTS.Learn how to use V$LOGMNR_CONTENTS view filtering and formatting features to manage what data appears, how it is displayed, and control the speed at which it is returned. Filtering and Formatting Data Returned to V$LOGMNR_CONTENTS.You access the redo data of interest by querying the V$LOGMNR_CONTENTS view. Querying V$LOGMNR_CONTENTS for Redo Data of Interest.To obtain accurate log mining results, learn how LogMiner works with the LogMiner dictionary.Ĭall the DBMS_LOGMNR.START_LOGMNR procedure to start LogMiner. LogMiner Dictionary Files and Redo Log Files.Starting with Oracle Database 21c, Oracle Database provides support to enable logical replication and supplemental logging of individual tables. How to Configure Supplemental Logging for Oracle GoldenGate. Learn about the views you use to review LogMiner sessions, and about the syntax you use for mining logs. All changes made to user data or to the database dictionary are recorded in the Oracle redo log files so that database recovery operations can be performed.Īs a DBA, Oracle's LogMiner tool helps you to find changed records in redo log files by using a set of PL/SQL procedures and functions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |