Oracle 18c

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

CREATE TABLE test_tab (
    col_name  VARCHAR2(20),
    log_time  TIMESTAMP(6),
    status    VARCHAR2(20)
);
BEGIN
INSERT INTO test_tab VALUES('Engineering', TIMESTAMP '2022-06-08 20:09:16.366000000','UP');
INSERT INTO test_tab VALUES('Engineering', TIMESTAMP '2022-06-09 20:13:16.366000000','DOWN');
INSERT INTO test_tab VALUES('Engineering', TIMESTAMP '2022-06-09 20:28:16.366000000','UP');
INSERT INTO test_tab VALUES('Commerce',    TIMESTAMP '2022-06-01 14:15:16.366000000','UP');
INSERT INTO test_tab VALUES('Commerce',    TIMESTAMP '2022-06-07 16:59:16.366000000','DOWN');
INSERT INTO test_tab VALUES('Commerce',    TIMESTAMP '2022-06-07 18:34:16.366000000','UP');
INSERT INTO test_tab VALUES('Commerce',    TIMESTAMP '2022-06-07 18:49:16.366000000','DOWN');
INSERT INTO test_tab VALUES('Commerce',    TIMESTAMP '2022-06-07 19:04:16.366000000','UP');
END;
/
1 rows affected

ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD HH24:MI:SS.FF';
SELECT *
FROM   test_tab
MATCH_RECOGNIZE(
  PARTITION BY col_name
  ORDER BY log_time
  MEASURES
    FIRST(down.log_time) AS start_time,
    FIRST(up.log_time) AS end_time
  PATTERN (down up)
  DEFINE
    down AS status = 'DOWN',
    up   AS status = 'UP'
)


COL_NAME
START_TIME
END_TIME


Commerce
2022-06-07 16:59:16.366000
2022-06-07 18:34:16.366000

Commerce
2022-06-07 18:49:16.366000
2022-06-07 19:04:16.366000

Engineering
2022-06-09 20:13:16.366000
2022-06-09 20:28:16.366000


SELECT *
FROM   test_tab
MATCH_RECOGNIZE(
  PARTITION BY col_name
  ORDER BY log_time
  MEASURES
    FIRST(down.log_time) AS start_time,
    FIRST(up.log_time) AS end_time
  AFTER MATCH SKIP TO NEXT ROW
  PATTERN (down other*? up)
  DEFINE
    down AS status = 'DOWN',
    up   AS status = 'UP'
)


COL_NAME
START_TIME
END_TIME


Commerce
2022-06-07 16:59:16.366000
2022-06-07 18:34:16.366000

Commerce
2022-06-07 18:49:16.366000
2022-06-07 19:04:16.366000

Engineering
2022-06-09 20:13:16.366000
2022-06-09 20:28:16.366000


SELECT col_name,
       log_time AS start_time,
       end_time
FROM   (
  SELECT t.*,
         MIN(CASE status WHEN 'UP' THEN log_time END) OVER (
           PARTITION BY col_name
           ORDER BY log_time
           ROWS BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING
         ) AS end_time
  FROM   test_tab t
)
WHERE  status = 'DOWN'


COL_NAME
START_TIME
END_TIME


Commerce
2022-06-07 16:59:16.366000
2022-06-07 18:34:16.366000

Commerce
2022-06-07 18:49:16.366000
2022-06-07 19:04:16.366000

Engineering
2022-06-09 20:13:16.366000
2022-06-09 20:28:16.366000

COL_NAME	START_TIME	END_TIME
Commerce	2022-06-07 16:59:16.366000	2022-06-07 18:34:16.366000
Commerce	2022-06-07 18:49:16.366000	2022-06-07 19:04:16.366000
Engineering	2022-06-09 20:13:16.366000	2022-06-09 20:28:16.366000