The Above error Appear In My Alert Log , I have Single Test DB , Sometimes the same error appear In Standby Database you don’t follow the same Produce , i didn’t find any document related to this error for single database so hope this will be useful
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1 :
‘/u01/app/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_3_79fz3gx8_.log’
ORA-00322: log 3 of thread 1 is not current copy
ORA-00312: online log 3 thread 1 :
‘/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_3_79fz3g1v_.log’
Solution
Step-One :
conn / as sysdba
shutdown immediate ;
startup mount ;
Step-Two :
Recover database using backup controlfile;
Note :
Provide path where your redo log file locate , in My case “/u01/app/oracle/oradata/ORCL/”
Step-three:
alter database open resetlogs;
shutdown immediate;
startup;
Thank you
Osama Mustafa