ORA-00346: log member marked as STALE
Cause: A log file member no longer is complete.
Action: Correct the underlying problem by referring to the other error messages found with this one.
Category Archives: ORA Database Error Messages
ORA-00345: redo log write error block string count string
ORA-00345: redo log write error block string count string
Cause: An IO error has occurred while writing the log
Action: Correct the cause of the error, and then restart the system. If the log is lost, apply media/incomplete recovery.
ORA-00344: unable to re-create online log ‘string’
ORA-00344: unable to re-create online log ‘string’
Cause: An I/O failure occurred when attempting to re-create an online as part of either ALTER DATABASE OPEN RESETLOGS or ALTER DATABASE CLEAR LOGFILE command.
Action: Correct the file/device as indicated by accompanying errors
ORA-00343: too many errors, log member closed
ORA-00343: too many errors, log member closed
Cause: The maximum number of errors on this log member has been exceeded.
Action: Correct the underlying problem by referring to the other error messages found with this one.
ORA-00342: archived log does not have expected resetlogs SCN string
ORA-00342: archived log does not have expected resetlogs SCN string
Cause: Recovery was given a log that does not belong to current incarnation or one of the parent incarnation. There should be another log that contains the correct redo.
Action: Supply the correct log file.
ORA-00341: log string of thread string, wrong log # string in header
ORA-00341: log string of thread string, wrong log # string in header
Cause: The internal information in an online log file does not match the control file.
Action: Restore correct file or reset logs.
ORA-00340: IO error processing online log string of thread string
ORA-00340: IO error processing online log string of thread string
Cause: An IO error occurred on the named online log.
Action: Restore accessibility to file, or restore file from backup.
ORA-00339: archived log does not contain any redo
ORA-00339: archived log does not contain any redo
Cause: The archived log is not the correct log. It is a copy of a log file that has never been used for redo generation, or was an online log being prepared to be the current log.
Action: Restore the correct log file.
ORA-00338: log string of thread string is more recent than control file
ORA-00338: log string of thread string is more recent than control file
Cause: The control file change sequence number in the log file is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error can make it stop happening without correcting the real problem. Every attempt to open the database will advance the control file change sequence number until it is great enough.
Action: Use the current control file or do backup control file recovery to make the control file current. Be sure to follow all restrictions on doing a backup control file recovery.
ORA-00337: log file ‘string’ does not exist and no size specified
ORA-00337: log file ‘string’ does not exist and no size specified
Cause: An attempt to add a log found neither an existing file nor a size for creating the file
Action: Specify a size for the log file