CHECK THE STATE OF YOUR LOG FILE MEMBERS

6. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P74 PPS
OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P74 PPS

6. Check the state of your log file members:

P AR T III

SQL> select group#,status,member from v$logfile order by 1,3; GROUP# STATUS MEMBER--- --- --- 1 INVALID /u01/app/oracle/oradata/orcl/redo01a.log