To get the LOGFILES INFORMATION from the database

select
lf.MEMBER,l.GROUP#,THREAD#,SEQUENCE#,MEMBERS,bytes/1024/1024 “BYTES IN
MB”,ARCHIVED,l.status from v$log l,v$logfile lf where l.GROUP#=lf.GROUP#