oracle 11g alter database drop logfile member 一例

本地环境，instance起不来，查看Log:

Errors in file /xxx/diag/rdbms/xx/xx/trace/xx_ora_28731.trc:
ORA-16038: log 8 sequence# 208 cannot be archived
ORA-19504: failed to create file ""
ORA-00312: online log 8 thread 2: '+DG_REDO_XXX/xx/redo08.log'
ORA-00312: online log 8 thread 2: '/dev/raw/raw18'

查看v$logfile:

    GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         1         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo01.log        NO
         2         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo02.log        NO
         3         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo03.log        NO
         4         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo04.log        NO
         5         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo05.log        NO
         6         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo06.log        NO
         7         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo07.log        NO
         8         ONLINE  +DG_REDO_XXXXXX/xxxxxx/redo08.log        NO
         1         ONLINE  /dev/raw/raw11                           NO
         2 INVALID ONLINE  /dev/raw/raw12                           NO
         3 INVALID ONLINE  /dev/raw/raw13                           NO
         4 INVALID ONLINE  /dev/raw/raw14                           NO
         5         ONLINE  /dev/raw/raw15                           NO
         6         ONLINE  /dev/raw/raw16                           NO
         7         ONLINE  /dev/raw/raw17                           NO
         8         ONLINE  /dev/raw/raw18                           NO

于是打算删掉raw。

alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;
alter database clear unarchived logfile group 4;

alter database drop logfile member '/dev/raw/raw11';
alter database drop logfile member '/dev/raw/raw12';
alter database drop logfile member '/dev/raw/raw13';
alter database drop logfile member '/dev/raw/raw14';
alter database drop logfile member '/dev/raw/raw15';
alter database drop logfile member '/dev/raw/raw16';
alter database drop logfile member '/dev/raw/raw17';
alter database drop logfile member '/dev/raw/raw18';

当前还是mount状态。

SQL> alter database open;