Ошибка в алерт-логе:
Errors in file E:\ORACLE12C\diag\rdbms\ic\ic\trace\ic_ora_4408.trc:
ORA-00742: Log read detects lost write in thread 1 sequence 195 block 37645
ORA-00312: online log 3 thread 1: 'E:\ORACLE12C\ORADATA\IC\REDO03B.LOG'
ORA-00312: online log 3 thread 1: 'E:\ORACLE12C\ORADATA\IC\REDO03A.LOG'
Wed Mar 15 18:20:39 2017
ARCH: All Archive destinations made inactive due to error 742
Committing creation of archivelog 'D:\ORACLE\ARCHIVELOGS\ARC195_934509462_1.ARC' (error 742)
как выкрутиться:
Вариант 1
SQL код:
alter database clear unarchived logfile group 1;
alter database clear unarchived logfile group 2;
alter database clear unarchived logfile group 3;
alter system switch logfile;
Вариант 2
SQL код:
alter system switch logfile;
recover database until cancel;
alter database open resetlogs;
alter system switch logfile;