Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE access_log(
TIME_STAMP DATE,
CLIENT_APP VARCHAR2(25),
INSTANCE_ID VARCHAR2(200),
SERVICE_NAME VARCHAR2(25),
DATE_HOUR_EXECUTION VARCHAR2(25),
STATE_COD DATE,
ERROR_DESC INTEGER,
LOG_ID VARCHAR2(100));
INSERT INTO access_log 
SELECT TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),'WEB','bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8','service','SERVICE',TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),0, 'REQUEST-aaaaaaaaaaaaaaaaaaaaaaa' FROM DUAL UNION ALL
SELECT TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),'WEB','bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8','service','SERVICE',TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),0, 'REQUEST-bbbbbbbbbbbbbbbbbbbbbbb' FROM DUAL UNION ALL
SELECT TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),'WEB','bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8','service','SERVICE',TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),0, 'REQUEST-ccccccccccccccccccccccc' FROM DUAL UNION ALL
SELECT TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),'WEB','bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8','service','SERVICE',TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),0, 'REQUEST-aaaaaaaaaaaaaaaaaaaaaaa' FROM DUAL UNION ALL
SELECT TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),'WEB','bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8','service','SERVICE',TO_DATE('2020-04-12 18:46:48', 'YYYY-MM-DD HH24:MI:SS'),0, 'REQUEST-ddddddddddddddddddddddd' FROM DUAL;
5 rows affected

SELECT sub.time_stamp, sub.client_app, sub.instance_id, 
       sub.service_name, sub.date_hour_execution, 
       sub.state_cod, sub.error_desc, sub.log_id
FROM (SELECT al.*, ROW_NUMBER() OVER (PARTITION BY al.log_id ORDER BY al.time_stamp) AS ROW_N
      FROM access_log al
      WHERE TRUNC(SYSDATE-al.time_stamp) = 2) sub
WHERE sub.row_n = 1;


TIME_STAMP
CLIENT_APP
INSTANCE_ID
SERVICE_NAME
DATE_HOUR_EXECUTION
STATE_COD
ERROR_DESC
LOG_ID


12-APR-20
WEB
bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8
service
SERVICE
12-APR-20
0
REQUEST-aaaaaaaaaaaaaaaaaaaaaaa

12-APR-20
WEB
bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8
service
SERVICE
12-APR-20
0
REQUEST-bbbbbbbbbbbbbbbbbbbbbbb

12-APR-20
WEB
bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8
service
SERVICE
12-APR-20
0
REQUEST-ccccccccccccccccccccccc

12-APR-20
WEB
bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8
service
SERVICE
12-APR-20
0
REQUEST-ddddddddddddddddddddddd

TIME_STAMP	CLIENT_APP	INSTANCE_ID	SERVICE_NAME	DATE_HOUR_EXECUTION	STATE_COD	LOG_ID
12-APR-20	WEB	bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8	service	SERVICE	12-APR-20	REQUEST-aaaaaaaaaaaaaaaaaaaaaaa
12-APR-20	WEB	bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8	service	SERVICE	12-APR-20	REQUEST-bbbbbbbbbbbbbbbbbbbbbbb
12-APR-20	WEB	bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8	service	SERVICE	12-APR-20	REQUEST-ccccccccccccccccccccccc
12-APR-20	WEB	bck83kuf5ddpgc2thr4anf3d6jpvgm2sk5e4pcke8jncijmm3s052tv07imnr92cj5obqm4dejagkjh8	service	SERVICE	12-APR-20	REQUEST-ddddddddddddddddddddddd