SELECT
l.GROUP#,
l.THREAD#,
l.SEQUENCE#,
l.ARCHIVED,
l.STATUS,
lf.MEMBER AS REDOLOG_FILE_NAME,
(l.BYTES/1024/1024) AS SIZE_MB
FROM v$log l
JOIN v$logfile lf ON l.Group#=lf.Group#
ORDER BY l.GROUP# ASC;
Output:
GROUP#
|
THREAD#
|
SEQUENCE#
|
ARCHIVED
|
STATUS
|
REDOLOG_FILE_NAME
|
SIZE_MB
|
1
|
1
|
18194
|
YES
|
INACTIVE
|
=+DATA/rep_db/onlinelog/group_1.282.636829083
|
400
|
1
|
1
|
18194
|
YES
|
INACTIVE
|
=+RECOVER/rep_db/onlinelog/group_1.677.636829089
|
400
|
2
|
1
|
18197
|
YES
|
INACTIVE
|
=+DATA/rep_db/onlinelog/group_2.283.636829095
|
400
|
2
|
1
|
18197
|
YES
|
INACTIVE
|
=+RECOVER/rep_db/onlinelog/group_2.678.636829101
|
400
|
3
|
1
|
18198
|
NO
|
CURRENT
|
=+RECOVER/rep_db/onlinelog/group_3.679.636829113
|
400
|
3
|
1
|
18198
|
NO
|
CURRENT
|
=+DATA/rep_db/onlinelog/group_3.274.636829107
|
400
|
4
|
1
|
18195
|
YES
|
INACTIVE
|
=+DATA/rep_db/onlinelog/group_4.295.641817961
|
400
|
4
|
1
|
18195
|
YES
|
INACTIVE
|
=+RECOVER/rep_db/onlinelog/group_4.620.641817975
|
400
|
5
|
1
|
18196
|
YES
|
INACTIVE
|
=+RECOVER/rep_db/onlinelog/group_5.619.641818021
|
400
|
5
|
1
|
18196
|
YES
|
INACTIVE
|
=+DATA/rep_db/onlinelog/group_5.304.641818009
|
400 |
|