ORA-00305 ORA-00312

1、问题现象

ORA-00305: log 2 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 2 thread 1: '/u01/app/oradata/redo021b.log'
ORA-00305: log 2 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 2 thread 1: '/u01/app/oradata/redo021a.log'
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_lgwr_58904.trc:
ORA-00305: log 2 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 2 thread 1: '/u01/app/oradata/redo021b.log'
ORA-00305: log 2 of thread 1 inconsistent; belongs to another database
ORA-00312: online log 2 thread 1: '/u01/app/oradata/redo021a.log'
Errors in file /u01/app/oracle/diag/rdbms/prod1/PROD1/trace/PROD1_ora_58938.trc:
ORA-00305: log 1 of thread  inconsistent; belongs to another database
ORA-00312: online log 2 thread 1: '/u01/app/oradata/redo021a.log'
ORA-00312: online log 2 thread 1: '/u01/app/oradata/redo021b.log'

2、原因
由于此库 在其他库异机恢复过，所有出现了redo 文件不一致问题

3、解决方法
drop redo log
add redo log

ALTER DATABASE add  logfile THREAD 1 GROUP 3 ('/u01/app/oradata/redo061.log') SIZE 100M  reuse;
alter database add logfile thread 1 group 3 ('/u01/app/oradata/redo031.log') size 100M;

对于current redo log，使用
alter database clear unarchived logfile group 3; --清除归档
然后再drop add

最后 alter database open;