SQL> select name from v$archived_log ;
NAME——————————————————————————–
+DATA/orcl/archivelog/2015_06_06/thread_1_seq_73.288.881698907+DATA/orcl/archivelog/2015_06_06/thread_1_seq_74.272.881699115+DATA/orcl/archivelog/2015_06_06/thread_1_seq_75.274.881699583+DATA/orcl/archivelog/2015_06_06/thread_1_seq_76.275.881699635+DATA/orcl/archivelog/2015_06_06/thread_1_seq_77.269.881699637+DATA/orcl/archivelog/2015_06_06/thread_1_seq_78.268.881699639
Determine the SCN for the truncate statement using logminer
exec dbms_logmnr.add_logfile(logfilename=>'+DATA/orcl/archivelog/2015_06_06/thread_1_seq_73.288.881698907',options=>dbms_logmnr.addfile);exec dbms_logmnr.add_logfile(logfilename=>'+DATA/orcl/archivelog/2015_06_06/thread_1_seq_74.272.881699115',options=>dbms_logmnr.addfile);exec dbms_logmnr.add_logfile(logfilename=>'+DATA/orcl/archivelog/2015_06_06/thread_1_seq_75.274.881699583',options=>dbms_logmnr.addfile);exec dbms_logmnr.add_logfile(logfilename=>'+DATA/orcl/archivelog/2015_06_06/thread_1_seq_76.275.881699635',options=>dbms_logmnr.addfile);exec dbms_logmnr.add_logfile(logfilename=>'+DATA/orcl/archivelog/2015_06_06/thread_1_seq_77.269.881699637',options=>dbms_logmnr.addfile);exec dbms_logmnr.add_logfile(logfilename=>'+DATA/orcl/archivelog/2015_06_06/thread_1_seq_78.268.881699639',options=>dbms_logmnr.addfile);
SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
COLUMN username FORMAT A8COLUMN operation FORMAT A9COLUMN sql_redo FORMAT A50 WORD_WRAPPEDCOLUMN sql_undo FORMAT A50 WORD_WRAPPEDCOLUMN timestamp FORMAT A20
SELECT username , operation, sql_redo, sql_undo, TO_CHAR(timestamp, 'DD-MON-YYYY HH24:MI:SS') timestamp, scn FROM v$logmnr_contents WHERE table_name='TAB'