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

tolilong發表於2015-09-12

從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部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-1798210/,如需轉載,請註明出處,否則將追究法律責任。

相關文章