Sunday, August 1, 2021

Supplemental Logging impact on Oracle Logmnr Redo SQL Output

LogMiner SettingsOriginal StatementsLogmnr 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 Loggingalter 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 Loggingalter 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