大龙的博客

常用链接

统计

最新评论

ORA-00312: online log 2 thread 1

ORA-00322: log 2 of thread 1 is not current copy

ORA-00312: online log 2 thread 1:

'/oracle/app/oracle/oradata/dbblack1/redo02.log'

解决办法如下:

1.SQL>shutdown immediate;

2.SQL> startup mount;

3.SQL> select group#,sequence#,archived,status from v$log;

    GROUP# SEQUENCE# ARC STATUS

---------- ---------- --- ----------------

         1        254 YES INACTIVE

         2        255 YES INACTIVE

         6        253 YES INACTIVE

         4        251 YES INACTIVE

         5        252 YES INACTIVE

         3        256 NO CURRENT

--非当前联机日志

4. SQL>alter database clear logfile '/oracle/app/oracle/oradata/dbblack1/redo02.log';

5. SQL>alter database open;

6. SQL>select status from v$instance;

--当前联机日志

--4.SQL>alter database clear unarchived logfile '/oracle/app/oracle/oradata/dbblack1/redo02.log';--无法使用

4.SQL>recover database until cancel;

5.SQL>alter database open resetlogs;

6. SQL>select status from v$instance;

posted on 2012-03-01 11:06 大龙 阅读(912) 评论(0)  编辑 收藏 引用


只有注册用户登录后才能发表评论。
【推荐】超50万行VC++源码: 大型组态工控、电力仿真CAD与GIS源码库
网站导航: 博客园   IT新闻   BlogJava   知识库   博问   管理