http://www.oracle-dba-online.com/managing_redo_logfiles.htm Viewing Information About LogfilesTo See how many logfile groups are there and their status type the following query. SQL>SELECT...