Log Miner To get details of contents of redo log file ~ Blog for oracle RAC Goldengate Dataguard ASM database

Steps to be done :

Step 1 :

SET MARKUP HTML ON SPOOL ON HEAD "<TITLE>LOGMNR - INFO </title> -
<STYLE TYPE='TEXT/CSS'></STYLE>"
SET ECHO ON
REM Spooling to html file

Step 2 :

spool LOGMNR_Info#1.html

Step 3 :

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS';
set numformat 9999999999999999999999g
exec dbms_logmnr.add_logfile('/Testdb/redo2/redo/redo0_redo05b.log'); <-- query the v$archived_log to find the NAME of the arc log sequence 1099516 and put the complete path here
exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
select xid, username, os_username, DATA_OBJ#, rbasqn, RBABLK, rbabyte, RS_ID, row_id, rollback, seg_name, seg_owner, operation, timestamp, sql_redo, scn, cscn from v$logmnr_contents;

EXECUTE DBMS_LOGMNR.END_LOGMNR;

spool off

SET MARKUP HTML OFF