ITPub博客

首页 > 数据库 > Oracle > 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

原创 Oracle 作者:tolilong 时间:2015-09-12 21:58:07 0 删除 编辑

从rac asm恢复到filesystem的时候,出现如上错误。

baidu结果  http://blog.itpub.net/23135684/viewspace-626372/

***************************************************************************************

加上thread 2的日志文件:
SQL> ALTER DATABASE ADD LOGFILE THREAD 2
  2    GROUP 5 '/u01/app/oradata/rac/redo_t2_log3.log' SIZE 10M REUSE,
  3    GROUP 6 '/u01/app/oradata/rac/redo_t2_log4.log' SIZE 10M REUSE;
Database altered.

SQL> alter database open resetlogs;

Database altered.

SQL>alter database disable  thread 2;

Database altered.

SQL> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
         1          1          0   10485760          1 YES UNUSED

         2          1          0   10485760          1 YES UNUSED

         3          1          0   10485760          1 YES UNUSED

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
         4          1          1   10485760          1 NO  CURRENT

         5          2          1   10485760          1 NO  INACTIVE

         6          2          0   10485760          1 YES UNUSED


6 rows selected.
SQL> alter database drop logfile group 5;
alter database drop logfile group 5
*
ERROR at line 1:
ORA-00350: log 5 of instance UNNAMED_INSTANCE_2 (thread 2) needs to be archived
ORA-00312: online log 5 thread 2: '/u01/app/oradata/rac/redo_t2_log3.log'


SQL> alter system archive log current;

System altered.

SQL> /

System altered.

SQL> alter database drop logfile group 5;

Database altered.

SQL> alter database drop logfile group 6;   

Database altered.

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
/u01/app/oradata/rac/redo_log4.log
/u01/app/oradata/rac/redo_log3.log
/u01/app/oradata/rac/redo_log2.log
/u01/app/oradata/rac/redo_log1.log

处理方法来源:ITPUB论坛



***************************************************************************************

或者使用如下方法:

http://blog.csdn.net/xuefuhe/article/details/6533128


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

下一篇: alter system dump
请登录后发表评论 登录
全部评论

注册时间:2010-07-13

  • 博文量
    406
  • 访问量
    1208701