Saturday, April 25, 2009

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

Fri Apr 24 11:27:38 2009
Errors in file /software/oradcms/product/9.2.0/rdbms/log/dcmss_ora_10640.trc:
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/dcms002/oradata/DCMSS/redo01b.log'
ORA-00322: log 1 of thread 1 is not current copy
ORA-00312: online log 1 thread 1: '/dcms001/oradata/DCMSS/redo01a.log'


In my case, it is caused by forget to backup control file , hence can't use current/future control file to manager old datafiles.
-- database is running in noarchivelog mode.

[Solution]

re-create the controfile.


during recreation of controfile, I hit below error, as get size of redo log from "ls" in bytes, which is not correct, after I change to 10240K . it passed through .
Cheers!


CREATE CONTROLFILE REUSE DATABASE "DCMSS" NORESETLOGS NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01163: SIZE clause indicates 10241 (blocks), but should match header 10240
ORA-01517: log member: '/dcms001/oradata/DCMSS/redo01a.log'