Oracle Redo log files

-- Step 1: Check how many redo log files exist.

select member from v$logfile;

-- Step 2: Check whether each group has more than 1 members.

select count(*) from V$LOG where members >1;