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
--非當(dāng)前聯(lián)機(jī)日志
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;
--當(dāng)前聯(lián)機(jī)日志
--4.SQL>alter database clear unarchived logfile '/oracle/app/oracle/oradata/dbblack1/redo02.log';--無(wú)法使用
4.SQL>recover database until cancel;
5.SQL>alter database open resetlogs;
6. SQL>select status from v$instance;