查询ORACLE 归档日志最近备份时间的SQL语句

select thread#, sequence#, next_change#, next_time
from ( select thread#, sequence#, next_change#, next_time,
              row_number() over
           ( partition by thread#
                  order by sequence# desc
                ) rn
       from v$backup_redolog
     )
where rn = 1

THREAD#	SEQUENCE#	NEXT_CHANGE#	NEXT_TIME
1	15	1,199,807	2019-07-13 08:53:00