Get standby redo log details

select sl.group#
, sl.sequence#
, ceil(sl.bytes / 1048576) mb
, l.member
from v$standby_log sl
, v$logfile l
where sl.group# = l.group#
;