ORA-00392 Solution


ORA-00392 log 1 of thread 1 is being cleared, operation not allowed, this ora error comes after restoration when we trying to open the database in resetlogs mode. Cause: ORA-00392 The first command “alter database open resetlogs” is abnormally abrupted leaving the redo log status as CLEARING/CLEARING_CURRENT in controlfile : ORA-00392 SOLUTION: First you try … Read more