Category Archives: ORA Database Error Messages

ORA-00356: inconsistent lengths in change description

ORA-00356: inconsistent lengths in change description

ORA-00356: inconsistent lengths in change description
Cause: A change record in the redo log contains lengths that do not add up to a consistent value. The log is corrupted in some way.
Action: Do recovery with a good version of the log or do time based recovery up to the indicated time.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00355: change numbers out of order

ORA-00355: change numbers out of order

ORA-00355: change numbers out of order
Cause: A change number found in the redo log is lower than a previously encountered change number. The log is corrupted in some way. The corruption may be at the earlier change or at this one.
Action: Do recovery with a good version of the log or do time based recovery up to the indicated time.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00354: corrupt redo log block header

ORA-00354: corrupt redo log block header

ORA-00354: corrupt redo log block header
Cause: The block header on the redo block indicated by the accompanying error, is not reasonable.
Action: Do recovery with a good version of the log or do time based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00353: log corruption near block string change string time string

ORA-00353: log corruption near block string change string time string

ORA-00353: log corruption near block string change string time string
Cause: Some type of redo log corruption has been discovered. This error describes the location of the corruption. Accompanying errors describe the type of corruption.
Action: Do recovery with a good version of the log or do incomplete recovery up to the indicated change or time.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00352: all logs for thread string need to be archived – cannot enable

ORA-00352: all logs for thread string need to be archived – cannot enable

ORA-00352: all logs for thread string need to be archived – cannot enable
Cause: Attempting to enable a thread with all logs needing to be archived, and media recovery has been enabled. There is no log that can be made the new current log for the thread.
Action: Archive a log for the thread or disable media recovery.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00351: recover-to time invalid

ORA-00351: recover-to time invalid

ORA-00351: recover-to time invalid
Cause: The time specified in a recover-until statement must be after January 1st 1988.
Action: Specify a time after January 1st 1988.

 

Cause: The time specified in a recover-until statement must be after January 1st 1988.

Action: Specify a time after January 1st 1988.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00350: log string of instance string (thread string) needs to be archived

ORA-00350: log string of instance string (thread string) needs to be archived

ORA-00350: log string of instance string (thread string) needs to be archived
Cause: The command cannot be done because the log has not been archived, and media recovery has been enabled.
Action: Archive the log or disable media recovery. If the command supports an UNARCHIVED option then it can be used. However this may result in making backups unuseable, and forcing the drop of some offline files.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00349: failure obtaining block size for ‘string’

ORA-00349: failure obtaining block size for ‘string’

ORA-00349: failure obtaining block size for ‘string’
Cause: The operating system was unable to determine the blocksize for the given filename.
Action: Consult the accompanying error message, and correct the device or specify another filename.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00348: single-process redo failure. Must abort instance

ORA-00348: single-process redo failure. Must abort instance

ORA-00348: single-process redo failure. Must abort instance
Cause: A failure occurred during a critical portion of the log code during single process operation. This error does not occur during normal multi-process operation.
Action: Shutdown abort and warmstart the database.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00347: log string of thread string, expected block size string doesn’t match string

ORA-00347: log string of thread string, expected block size string doesn’t match string

ORA-00347: log string of thread string, expected block size string doesn’t match string
Cause: On header read the blocksize indicated in the control file did not match the blocksize contained in the log file.
Action: Restore correct file or reset logs.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/