The following query returns information about the online redo log of a database used without the Parallel Server:
SELECT group#, bytes, members
FROM sys.v$log;
GROUP# BYTES MEMBERS
---------- ---------- ----------
1 81920 2
2 81920 2
To see the names of all of the member of a group, use a query similar to the following:
SELECT *
FROM sys.v$logfile
WHERE group# = 2;
GROUP# STATUS MEMBER
---------- ----------- --------------
2 LOG2A
2 STALE LOG2B
2 LOG2C
If STATUS is blank for a member, the file is in use.