ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled

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

原创 Linux操作系统 作者:liu_qingwei2008 时间:2011-04-26 20:39:12 0 删除 编辑


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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-05-12

  • 博文量
    37
  • 访问量
    86408