| LogMiner Settings | Original Statements | Logmnr Redo Statements |
| Minimal Suplemental Logging on the database level only | | CREATE UNIQUE INDEX "DONGHUA"."SYS_C007769" on "DONGHUA"."P1"("ID") NOPARALLEL; |
| create table p1 (id number primary key, name varchar2(10)); | create table p1 (id number primary key, name varchar2(10)); |
| | CREATE UNIQUE INDEX "DONGHUA"."SYS_C007770" on "DONGHUA"."C1"("ID") NOPARALLEL; |
| create table c1 (id number primary key, name varchar2(10),pid number, | create table c1 (id number primary key, name varchar2(10),pid number, |
| constraint fk1 foreign key (pid) references p1(id)); | constraint fk1 foreign key (pid) references p1(id)); |
| insert into p1 values (1,'v1'); | insert into "DONGHUA"."P1"("ID","NAME") values ('1','v1'); |
| insert into p1 values (2,'v1'); | insert into "DONGHUA"."P1"("ID","NAME") values ('2','v1'); |
| insert into p1 values (3,'v3'); | insert into "DONGHUA"."P1"("ID","NAME") values ('3','v3'); |
| commit; | |
| insert into c1 values (1,'v1',1); | insert into "DONGHUA"."C1"("ID","NAME","PID") values ('1','v1','1'); |
| insert into c1 values (2,'v1',2); | insert into "DONGHUA"."C1"("ID","NAME","PID") values ('2','v1','2'); |
| insert into c1 values (3,'v3',3); | insert into "DONGHUA"."C1"("ID","NAME","PID") values ('3','v3','3'); |
| commit; | |
| update c1 set name='v1a' where id=1; | update "DONGHUA"."C1" set "NAME" = 'v1a' where "NAME" = 'v1'; |
| commit; | |
| update c1 set name='v1b' where name='v1a'; | update "DONGHUA"."C1" set "NAME" = 'v1b' where "NAME" = 'v1a'; |
| commit; | |
| update c1 set name ='v1c' where id=1; | update "DONGHUA"."C1" set "NAME" = 'v1c' where "NAME" = 'v1b'; |
| rollback; | |
| | update "DONGHUA"."C1" set "NAME" = 'v1b'; |
| update c1 set name ='v1d' where id=1; | update "DONGHUA"."C1" set "NAME" = 'v1d' where "NAME" = 'v1b'; |
| commit; | |
| Add PK Supplemental Logging | alter table p1 add supplemental log data (primary key) columns; | alter table p1 add supplemental log data (primary key) columns; |
| Omited the step to update name value from v1d to v1e on-purpose |
| alter table c1 add supplemental log data (primary key) columns; | alter table c1 add supplemental log data (primary key) columns; |
| update c1 set name='v1f' where id=1; | update "DONGHUA"."C1" set "NAME" = 'v1f' where "ID" = '1' and "NAME" = 'v1e'; |
| commit; | |
| insert into c1 values (4,'d',1); | insert into "DONGHUA"."C1"("ID","NAME","PID") values ('4','d','1'); |
| commit; | |
| delete from c1 where id=4; | delete from "DONGHUA"."C1" where "ID" = '4' and "NAME" = 'd' and "PID" = '1'; |
| commit; | |
| Add ALL columns Suplemental Logging | alter table p1 add supplemental log data (all) columns; | alter table p1 add supplemental log data (all) columns; |
| alter table c1 add supplemental log data (all) columns; | alter table c1 add supplemental log data (all) columns; |
| update c1 set name='v1g' where id=1; | update "DONGHUA"."C1" set "NAME" = 'v1g' where "ID" = '1' and "NAME" = 'v1f' and "PID" = '1'; |
| commit; | |
| insert into c1 values (4,'d',1); | insert into "DONGHUA"."C1"("ID","NAME","PID") values ('4','d','1'); |
| commit; | |
| update c1 set pid=2 where name='d'; | update "DONGHUA"."C1" set "PID" = '2' where "ID" = '4' and "NAME" = 'd' and "PID" = '1'; |
| commit; | |
| delete from c1 where id=4; | delete from "DONGHUA"."C1" where "ID" = '4' and "NAME" = 'd' and "PID" = '2'; |
| commit; | |
| alter table c1 add (age number); | alter table c1 add (age number); |
| insert into c1 values (5,'e',1,20); | insert into "DONGHUA"."C1"("ID","NAME","PID","AGE") values ('5','e','1','20'); |
| commit; | |
| update c1 set age=id*2 where age is null; | update "DONGHUA"."C1" set "AGE" = '2' where "ID" = '1' and "NAME" = 'v1g' and "PID" = '1' and "AGE" IS NULL; |
| | update "DONGHUA"."C1" set "AGE" = '4' where "ID" = '2' and "NAME" = 'v1' and "PID" = '2' and "AGE" IS NULL; |
| | update "DONGHUA"."C1" set "AGE" = '6' where "ID" = '3' and "NAME" = 'v3' and "PID" = '3' and "AGE" IS NULL; |
| commit; | |
| delete from c1 where age=20; | delete from "DONGHUA"."C1" where "ID" = '5' and "NAME" = 'e' and "PID" = '1' and "AGE" = '20'; |
| commit; | |
Code snippet being used:
execute dbms_logmnr_d.build(options => dbms_logmnr_d.store_in_redo_logs);
alter session set nls_date_format='yyyy-mon-dd hh24:mi:ss';
execute dbms_logmnr.add_logfile(logfilename => '/u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_41_jjbhnmjl_.arc', options => dbms_logmnr.new);
execute dbms_logmnr.add_logfile(logfilename => '/u01/app/oracle/oradata/ORCL/redo03.log', options => dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename => '/u01/app/oracle/oradata/ORCL/redo02.log', options => dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename => '/u01/app/oracle/oradata/ORCL/redo01.log', options => dbms_logmnr.addfile);
begin
dbms_logmnr.start_logmnr(
startSCN=> 3783444,
endSCN=> 3783653,
options => dbms_logmnr.ddl_dict_tracking + dbms_logmnr.dict_from_redo_logs
+ dbms_logmnr.no_rowid_in_stmt);
end;
/
drop table system.logmnr_contents purge;
create table system.logmnr_contents tablespace users as select * from v$logmnr_contents where src_con_name='PDB1';
exec dbms_logmnr.end_logmnr();
Errors encountered and workarounds/solutions
Error1: ORA-01281: SCN range specified is invalid
SQL>
SQL> begin
2 dbms_logmnr.start_logmnr(
3 startTime=> to_date('2021-jul-31 17:25:00','yyyy-mon-dd hh24:mi:ss'),
4 endTime=> to_date('2021-jul-31 17:50:00','yyyy-mon-dd hh24:mi:ss'),
5 options => dbms_logmnr.ddl_dict_tracking + dbms_logmnr.dict_from_redo_logs
6 + dbms_logmnr.no_rowid_in_stmt);
7 end;
8 /
Error starting at line : 1 in command -
begin
dbms_logmnr.start_logmnr(
startTime=> to_date('2021-jul-31 17:25:00','yyyy-mon-dd hh24:mi:ss'),
endTime=> to_date('2021-jul-31 17:50:00','yyyy-mon-dd hh24:mi:ss'),
options => dbms_logmnr.ddl_dict_tracking + dbms_logmnr.dict_from_redo_logs
+ dbms_logmnr.no_rowid_in_stmt);
end;
Error report -
ORA-01281: SCN range specified is invalid
ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 2
01281. 00000 - "SCN range specified is invalid"
*Cause: StartSCN may be greater than EndSCN, or the SCN specified may be
invalid.
*Action: Specify a valid SCN range.
Solution for Error1: Use SCN Instead of Timestamp
select timestamp_to_scn(to_timestamp('2021-jul-31 17:25:00','yyyy-mon-dd hh24:mi:ss')) scn from dual;
select timestamp_to_scn(to_timestamp('2021-jul-31 17:50:00','yyyy-mon-dd hh24:mi:ss')) scn from dual;
begin
dbms_logmnr.start_logmnr(
startSCN=> 3619268,
endSCN=> 3619333,
options => dbms_logmnr.ddl_dict_tracking + dbms_logmnr.dict_from_redo_logs
+ dbms_logmnr.no_rowid_in_stmt);
end;
/
Error2: ORA-01371: Complete LogMiner dictionary not found
begin
dbms_logmnr.start_logmnr(
startSCN=> 3619268,
endSCN=> 3619333,
options => dbms_logmnr.ddl_dict_tracking + dbms_logmnr.dict_from_redo_logs
+ dbms_logmnr.no_rowid_in_stmt);
end;
Error report -
ORA-01371: Complete LogMiner dictionary not found
ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 2
01371. 00000 - "Complete LogMiner dictionary not found"
*Cause: One or more log files containing the LogMiner dictionary was not
found.
*Action: Add into LogMiner all log files containing the dictionary.
Solution for Error2: Find out logs contains dictionary and add them in
select * from v$archived_log where dictionary_begin='YES'
execute dbms_logmnr.add_logfile(logfilename => '/u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_31_jjb7ytl8_.arc', options => dbms_logmnr.addfile);
Error3: ORA-01291: missing log file
Error starting at line : 26 in command -
begin
dbms_logmnr.start_logmnr(
startSCN=> 3619268,
endSCN=> 3619333,
options => dbms_logmnr.ddl_dict_tracking + dbms_logmnr.dict_from_redo_logs
+ dbms_logmnr.no_rowid_in_stmt);
end;
Error report -
ORA-01291: missing log file
ORA-06512: at "SYS.DBMS_LOGMNR", line 72
ORA-06512: at line 2
01291. 00000 - "missing log file"
*Cause: Not all log files corresponding to the time or SCN range specified
had been added to the LogMiner session.
*Action: Check the system.logmnr_log$ table for Logical Standby or
Downstream Capture, or v$logmnr_logs view for adhoc query to determine the
missing SCN range, and add the relevant log files.
Solution for Error3: Find out missing logs and add them in
select * from v$logmnr_logs ;
LOG_ID FILENAME LOW_TIME HIGH_TIME DB_ID DB_NAME RESET_SCN RESET_SCN_TIME COMPATIBLE THREAD_ID THREAD_SQN LOW_SCN NEXT_SCN DIC DIC TYPE BLOCKSIZE FILESIZE INFO STATUS CON_ID
31 /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_31_jjb7ytl8_.arc 2021-jul-31 18:02:50 2021-jul-31 18:03:06 1599026414 ORCL 1920977 2021-apr-30 16:14:42 19.0.0.0.0 1 31 3481882 3482822 YES YES ARCHIVE 512 37804544 0 1
32 Missing log file(s) for thread 1, sequence(s) 32 to 35 2021-jul-31 18:03:06 2021-jul-31 19:23:41 1599026414 1920977 2021-apr-30 16:14:42 19.0.0.0.0 1 32 3482822 3612522 NO NO ARCHIVE 512 37804544 MISSING_LOGFILE 4 1
36 /u01/app/oracle/oradata/ORCL/redo03.log 2021-jul-31 19:23:41 2021-jul-31 19:27:56 1599026414 ORCL 1920977 2021-apr-30 16:14:42 19.0.0.0.0 1 36 3612522 3614716 NO NO ONLINE 512 198787072 0 1
37 /u01/app/oracle/oradata/ORCL/redo01.log 2021-jul-31 19:27:56 2021-jul-31 19:28:20 1599026414 ORCL 1920977 2021-apr-30 16:14:42 19.0.0.0.0 1 37 3614716 3614990 NO NO ONLINE 512 193117184 0 1
38 /u01/app/oracle/oradata/ORCL/redo02.log 2021-jul-31 19:28:20 1988-jan-01 00:00:00 1599026414 ORCL 1920977 2021-apr-30 16:14:42 19.0.0.0.0 1 38 3614990 1.8447E+19 NO NO ONLINE 512 0 0 1
execute dbms_logmnr.add_logfile(logfilename => '/u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_32_jjb9ck7d_.arc', options => dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename => '/u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_33_jjb9r71b_.arc', options => dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename => '/u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_34_jjbdfbj8_.arc', options => dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile(logfilename => '/u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_35_jjbdoxz7_.arc', options => dbms_logmnr.addfile);
Error4: ORA-65040: operation not allowed from within a pluggable database
SQL> execute dbms_logmnr.add_logfile(logfilename => '/u01/app/oracle/oradata/ORCL/redo03.log', options => dbms_logmnr.new);
Error starting at line : 1 in command -
BEGIN dbms_logmnr.add_logfile(logfilename => '/u01/app/oracle/oradata/ORCL/redo03.log', options => dbms_logmnr.new); END;
Error report -
ORA-65040: operation not allowed from within a pluggable database
ORA-06512: at "SYS.DBMS_LOGMNR", line 82
ORA-06512: at line 1
65040. 00000 - "operation not allowed from within a pluggable database"
*Cause: An operation was attempted that can only be performed in the root
or application root container.
*Action: Switch to the root or application root container to perform the
operation.
Solution for Error4: Perform Logmnr session in CDB
Output for proper executed logmnr session in alert log:
2021-07-31T21:18:29.376179+08:00
ARC0 (PID:2058): Archived Log entry 35 added for T-1.S-50 ID 0x5f4f08ee LAD:1
2021-07-31T21:19:53.288877+08:00
LOGMINER: summary for session# = 2147499009
LOGMINER: StartScn: 3474265 (0x0000000000350359)
LOGMINER: EndScn: 3783654 (0x000000000039bbe6)
LOGMINER: HighConsumedScn: 0
LOGMINER: PSR flags: 0x0
LOGMINER: Session Flags: 0x4000001
LOGMINER: Session Flags2: 0x0
LOGMINER: Read buffers: 4
LOGMINER: Region Queue size: 256
LOGMINER: Redo Queue size: 4096
LOGMINER: Memory Size = 15M, HWM 14M, LWM 13M, 90%
LOGMINER: Memory Release Limit: 0M
LOGMINER: Max Decomp Region Memory: 1M
LOGMINER: Transaction Queue Size: 1024
2021-07-31T21:19:53.472171+08:00
LOGMINER: Begin mining logfile during dictionary load for session -2147468287 thread 1 sequence 31, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_31_jjb7ytl8_.arc
2021-07-31T21:19:54.963988+08:00
LOGMINER: Preparing to load 2 dictionaries for session -2147468287
LOGMINER: session# -2147468287 Processing dictionary for pluggable database CDB$ROOT, pdbid 1
2021-07-31T21:20:03.891985+08:00
LOGMINER: Preparing to load next dictionary for session -2147468287
LOGMINER: session# -2147468287 Processing dictionary for pluggable database PDB1, pdbid 3
2021-07-31T21:20:12.872347+08:00
LOGMINER: Finalizing dictionary load for session -2147468287
2021-07-31T21:20:14.091220+08:00
LOGMINER: Gathering statistics on logminer dictionary. (incremental, nonparallel)
2021-07-31T21:21:09.610881+08:00
LOGMINER: Completed dictionary load for session -2147468287
2021-07-31T21:21:10.632989+08:00
LOGMINER: End mining logfiles during dictionary load for session -2147468287
2021-07-31T21:47:48.495277+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 30, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_30_jjb7yc6n_.arc
2021-07-31T21:48:41.041379+08:00
Thread 1 advanced to log sequence 100 (LGWR switch), current SCN: 4004966
Current log# 1 seq# 100 mem# 0: /u01/app/oracle/oradata/ORCL/redo01.log
2021-07-31T21:48:50.929787+08:00
ARC1 (PID:2062): Archived Log entry 84 added for T-1.S-99 ID 0x5f4f08ee LAD:1
2021-07-31T21:49:06.099787+08:00
Thread 1 advanced to log sequence 101 (LGWR switch), current SCN: 4005178
Current log# 2 seq# 101 mem# 0: /u01/app/oracle/oradata/ORCL/redo02.log
2021-07-31T21:49:11.553530+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 30, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_30_jjb7yc6n_.arc
2021-07-31T21:49:12.264516+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 31, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_31_jjb7ytl8_.arc
2021-07-31T21:49:15.433008+08:00
ARC0 (PID:2058): Archived Log entry 85 added for T-1.S-100 ID 0x5f4f08ee LAD:1
2021-07-31T21:49:38.298758+08:00
Thread 1 advanced to log sequence 102 (LGWR switch), current SCN: 4005638
Current log# 3 seq# 102 mem# 0: /u01/app/oracle/oradata/ORCL/redo03.log
2021-07-31T21:49:48.990105+08:00
ARC1 (PID:2062): Archived Log entry 86 added for T-1.S-101 ID 0x5f4f08ee LAD:1
2021-07-31T21:50:00.905228+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 31, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_31_jjb7ytl8_.arc
2021-07-31T21:50:01.019949+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 32, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_32_jjb9ck7d_.arc
2021-07-31T21:50:33.552626+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 32, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_32_jjb9ck7d_.arc
2021-07-31T21:50:33.580285+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 33, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_33_jjb9r71b_.arc
2021-07-31T21:50:53.302224+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 33, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_33_jjb9r71b_.arc
2021-07-31T21:50:53.319783+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 34, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_34_jjbdfbj8_.arc
2021-07-31T21:51:13.713593+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 34, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_34_jjbdfbj8_.arc
2021-07-31T21:51:13.759941+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 35, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_35_jjbdoxz7_.arc
2021-07-31T21:51:25.110417+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 35, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_35_jjbdoxz7_.arc
2021-07-31T21:51:25.227255+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 36, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_36_jjbdxy0v_.arc
2021-07-31T21:51:37.519020+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 36, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_36_jjbdxy0v_.arc
2021-07-31T21:51:37.553201+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 37, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_37_jjbdyoct_.arc
2021-07-31T21:51:49.470053+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 37, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_37_jjbdyoct_.arc
2021-07-31T21:51:49.520486+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 38, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_38_jjbggyoh_.arc
2021-07-31T21:52:15.617868+08:00
Thread 1 advanced to log sequence 103 (LGWR switch), current SCN: 4007973
Current log# 1 seq# 103 mem# 0: /u01/app/oracle/oradata/ORCL/redo01.log
2021-07-31T21:52:22.143097+08:00
ARC0 (PID:2058): Archived Log entry 87 added for T-1.S-102 ID 0x5f4f08ee LAD:1
2021-07-31T21:52:31.585237+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 38, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_38_jjbggyoh_.arc
2021-07-31T21:52:31.608670+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 39, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_39_jjbhd3wq_.arc
2021-07-31T21:53:15.087574+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 39, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_39_jjbhd3wq_.arc
2021-07-31T21:53:15.278357+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 40, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_40_jjbhm9k0_.arc
2021-07-31T21:53:26.842559+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 40, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_40_jjbhm9k0_.arc
2021-07-31T21:53:26.856606+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 41, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_41_jjbhnmjl_.arc
2021-07-31T21:53:47.961340+08:00
Thread 1 cannot allocate new log, sequence 104
Checkpoint not complete
Current log# 1 seq# 103 mem# 0: /u01/app/oracle/oradata/ORCL/redo01.log
2021-07-31T21:53:50.548324+08:00
Thread 1 advanced to log sequence 104 (LGWR switch), current SCN: 4012912
Current log# 2 seq# 104 mem# 0: /u01/app/oracle/oradata/ORCL/redo02.log
2021-07-31T21:54:00.877049+08:00
ARC1 (PID:2062): Archived Log entry 88 added for T-1.S-103 ID 0x5f4f08ee LAD:1
2021-07-31T21:54:18.424868+08:00
Thread 1 advanced to log sequence 105 (LGWR switch), current SCN: 4013057
Current log# 3 seq# 105 mem# 0: /u01/app/oracle/oradata/ORCL/redo03.log
2021-07-31T21:54:28.432980+08:00
ARC0 (PID:2058): Archived Log entry 89 added for T-1.S-104 ID 0x5f4f08ee LAD:1
2021-07-31T21:54:30.362990+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 41, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_41_jjbhnmjl_.arc
2021-07-31T21:54:30.636954+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 42, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_42_jjbjfnwq_.arc
2021-07-31T21:55:39.704004+08:00
LOGMINER: End mining logfile for session -2147468287 thread 1 sequence 42, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_42_jjbjfnwq_.arc
2021-07-31T21:55:39.743489+08:00
LOGMINER: Begin mining logfile for session -2147468287 thread 1 sequence 43, /u01/fra/ORCL/archivelog/2021_07_31/o1_mf_1_43_jjbk60nf_.arc
