DBA FUS‎ > ‎

Oracle Redo log files

posted Sep 13, 2010, 6:32 AM by Sachchida Ojha
Check how many redo log files exist.

select member from v$logfile;

 Check whether each group has more than 1 members.

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