Oracle 11g Release 2

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

with t(id, day, status) as (
    select 'E0000000000054245349', date '2016-02-27', 24 from dual union all
    select 'E0000000000054245349', date '2016-02-28', 24 from dual union all
    select 'E0000000000054245349', date '2016-02-29', 24 from dual union all
    select 'E0000000000054245349', date '2016-03-01', 24 from dual union all
    select 'E0000000000054245349', date '2016-03-03', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-04', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-05', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-06', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-07', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-08', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-09', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-10', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-11', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-12', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-13', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-14', 21 from dual union all
    select 'E0000000000054245349', date '2016-03-15', 40 from dual union all
    select 'E0000000000054245349', date '2016-03-16', 40 from dual union all
    select 'E0000000000054245349', date '2016-03-18', 40 from dual union all
    select 'E0000000000054245349', date '2016-03-19', 40 from dual union all
    select 'E0000000000054245349', date '2017-01-01', 21 from dual union all
    select 'E0000000000054245349', date '2017-01-02', 21 from dual union all
    select 'E0000000000054245349', date '2017-01-03', 21 from dual union all
    select 'E0000000000054245349', date '2017-01-05', 25 from dual )
select id, min(day) mnd, max(day) mxd, status
  from (
    select day - row_number() over (partition by id order by day) grp,
           id, day, status
      from t)
  group by id, grp, status
  order by id, grp;

ID	MND	MXD	STATUS
E0000000000054245349	27-FEB-16	01-MAR-16	24
E0000000000054245349	03-MAR-16	14-MAR-16	21
E0000000000054245349	15-MAR-16	16-MAR-16	40
E0000000000054245349	18-MAR-16	19-MAR-16	40
E0000000000054245349	01-JAN-17	03-JAN-17	21
E0000000000054245349	05-JAN-17	05-JAN-17	25