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