Groovy DBA

set linesize 200 col MEMBER format a60 select group#, status, member from v$logfile order by group#; ALTER DATABASE DROP LOGFILE GROUP 22; alter database drop logfile  '/usr/opt/app/oracle/admin/hrprod/redo01/redo01g22.log'; alter database drop logfile '/usr/opt/app/oracle/admin/hrprod/redo02/redo02g22.log';

 select group#,sequence#,bytes,archived,status from v$log; ALTER DATABASE DROP LOGFILE GROUP 15; alter database add logfile group 15 ('/usr/opt/app/oracle/admin/hrprod/redo01/redo01g15.log', '/usr/opt/app/oracle/admin/hrprod/redo02/redo02g15.log') size 1032M reuse; SQL>  alter system switch logfile; Based on the current redo log state and need make the old groups inactive  SQL>   alter system archive log group 1;

 select * from syscat.indexes where tabname='CATENTREL' and tabschema='WCS';