ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

oracle11g rac在重新创建控制文件后，以open resetlogs打开库时报了此错ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

错误原因是在rac节点1上生成的创建控制文件的脚本造成的。

解决过程如下：

SQL> ALTER DATABASE ADD LOGFILE THREAD 2
  2  GROUP 5 '/dev/rora_redo13' size 1000m REUSE,
  3  GROUP 6 '/dev/rora_redo23' size 1000m REUSE;

Database altered.

SQL> select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                   IS_
---------- ------- ------- ---------------------------------------- ---
         4 STALE   ONLINE  /dev/rora_redo22                       NO
         3 STALE   ONLINE  /dev/rora_redo21                       NO
         2 STALE   ONLINE  /dev/rora_redo12                       NO
         1 STALE   ONLINE  /dev/rora_redo11                       NO
         5         ONLINE  /dev/rora_redo13                       NO
         6         ONLINE  /dev/rora_redo23                       NO

6 rows selected.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
         1          1          9 1048576000          1 NO  CURRENT               33192889 2011-04-25 18:39:13
         2          1          8 1048576000          1 YES ACTIVE                33181933 2011-04-25 17:00:55
         3          1          0 1048576000          1 YES UNUSED                       0
         4          1          0 1048576000          1 YES UNUSED                       0
         5          2          0 1048576000          1 YES UNUSED                       0
         6          2          0 1048576000          1 YES UNUSED                       0

6 rows selected.

SQL> alter database open RESETLOGS;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
         1          1          5 1048576000          1 YES INACTIVE              33203132 2011-04-25 19:12:38
         2          1          6 1048576000          1 YES INACTIVE              33203134 2011-04-25 19:12:38
         3          1          7 1048576000          1 NO  CURRENT               33203136 2011-04-25 19:12:39
         4          1          4 1048576000          1 YES INACTIVE              33203110 2011-04-25 19:12:35
         5          2          3 1048576000          1 YES INACTIVE              33200162 2011-04-25 19:11:01
         6          2          4 1048576000          1 NO  CURRENT               33203113 2011-04-25 19:13:01

6 rows selected.

SQL> alter database drop logfile group 1 ;

Database altered.

SQL> alter database drop logfile group 2;

Database altered.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- -------------------
         3          1          7 1048576000          1 NO  CURRENT               33203136 2011-04-25 19:12:39
         4          1          4 1048576000          1 YES INACTIVE              33203110 2011-04-25 19:12:35
         5          2          5 1048576000          1 NO  CURRENT               33203139 2011-04-25 19:13:07
         6          2          4 1048576000          1 YES INACTIVE              33203113 2011-04-25 19:13:01

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/23898243/viewspace-693819/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/23898243/viewspace-693819/