OBSERVE THE STATE OF YOUR ONLINE LOGS WITH THE FOLLOWING QUERY

2. - 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

2. Observe the state of your online logs with the following query:

SQL> select group#,status,member from v$logfile order by 1,3; GROUP# STATUS MEMBER--- --- ---