Oracle Database - Log Minor Examples

alter system set utl_file_dir='D:\63_archivelog\log_minor' scope=spfile;
D:\63_archivelog\log_minor
##############################################################################################################

EXECUTE DBMS_LOGMNR_D.BUILD('dictionary.ora', 'D:\63_archivelog\log_minor', DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO01.LOG');

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO02.LOG');

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO03.LOG');

SQL> execute DBMS_LOGMNR.ADD_LOGFILE ('C:\ORACLE\ORADATA\ORDB1\REDO04.LOG');
################################################################################################################


EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '/tmp/group_1.259.919359545', OPTIONS => DBMS_LOGMNR.NEW);

EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/tmp/group_2.261.919359549',OPTIONS => DBMS_LOGMNR.ADDFILE);

execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_230_1005460847.arc', OPTIONS => DBMS_LOGMNR.NEW);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_231_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_232_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_233_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_234_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_235_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_236_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);
execute DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME => 'D:\63_archivelog\1_237_1005460847.arc', OPTIONS => DBMS_LOGMNR.ADDFILE);


EXECUTE DBMS_LOGMNR.START_LOGMNR (DICTFILENAME => 'D:\63_archivelog\log_minor\DICTIONARY1.ORA');

SELECT scn, operation, sql_redo, sql_undo FROM v$logmnr_contents;