Delete redo log group or member

Delete redo log group or member 1. before deleting log groups, determine 3 points: 1. the instance must have at least two groups instances, regardless of the number of member for each groups; 2. you can delete a group only when its status is inactive. If you must delete the current group, you must first alter system switch logfile; 3. If archiving is enabled, you must wait until the group is archived before killing it. Select group #, ARCHIVED, status from v $ LOG; GROUP # arc status --------- --- ---------------- 1 yes active 2 no current 3 yes inactive 4 yes inactive killed a group: alter database drop logfile group 3; 2. delete a group's memberALTER database drop logfile member '/oracle/dbs/log3c. rdo '; -------- when the redolog member is deleted, its OS file is not deleted from the disk. To drop a member of an active group, you must first force a log switch./* alter system switch logfile ;*/