USING SQL*PLUS, CONNECT AS USER SYSTEM AND ISSUE THESE QUERIES TO CONFIRM PART IIITHE CREATION OF THE NEW MEMBERS

10. Using SQL*Plus, connect as user SYSTEM and issue these queries to confirm PART IIIthe creation of the new members:

SQL> select group#,sequence#,members,status from v$log;

SQL> select group#,status,member from v$logfile;

The result will show the new members with status INVALID. This is not a problem; it happens merely because they have never been used.