Category Archives: ORA Database Error Messages

ORA-00296: maximum number of files (string) exceeded for RECOVER DATAFILE LIST

ORA-00296: maximum number of files (string) exceeded for RECOVER DATAFILE LIST

ORA-00296: maximum number of files (string) exceeded for RECOVER DATAFILE LIST
Cause: The RECOVER DATAFILE LIST command specified more datafiles than are allowed by the DB_FILES initialization parameter. This error occurs when doing recovery with Recovery Manager, and the instance has been started with a DB_FILES parameter specifying fewer datafiles than recovery manager needs to recover to satisfy the user’s RECOVER command.
Action: Re-start the instance with a higher value for DB_FILES.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string

ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string

ORA-00295: datafile/tempfile number string is invalid, must be between 1 and string
Cause: An invalid file number was specified.
Action: Specify a valid datafile or tempfile number and retry the operation

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00294: invalid archivelog format specifier ‘string’

ORA-00294: invalid archivelog format specifier ‘string’

ORA-00294: invalid archivelog format specifier ‘string’
Cause: An invalid format specifier was found in the LOG_ARCHIVE_FORMAT initialization parameter. The only characters permitted following the % symbol are s, S, t, and T.
Action: Correct the initialization file and re-start the instance.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00293: control file out of sync with redo log

ORA-00293: control file out of sync with redo log

ORA-00293: control file out of sync with redo log
Cause: The redo log file and control file are out of sync because a non-current controle file was specified when the instance was started.
Action: Retry the RECOVER command using the current control file, or retry the RECOVER command using the USING BACKUP CONTROLFILE clause.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00292: parallel recovery feature not installed

ORA-00292: parallel recovery feature not installed

ORA-00292: parallel recovery feature not installed
Cause: A parallel recovery was requested when the parallel recovery option is not installed.
Action: Delete the PARALLEL clause from the RECOVER command. Also, delete the RECOVERY_PARALLELISM parameter in the initialization file.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00291: numeric value required for PARALLEL option

ORA-00291: numeric value required for PARALLEL option

ORA-00291: numeric value required for PARALLEL option
Cause: A recovery command was specified incorrectly. The PARALLEL option must be followed by a numeric argument that specifies the degree of parallelism.
Action: Re-enter the command with a numeric argument specifying the degree of parallelism desired.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00290: operating system archival error occurred. See error below

ORA-00290: operating system archival error occurred. See error below

ORA-00290: operating system archival error occurred. See error below
Cause: While attempting to archive to a redo log file, the server encountered an unexpected operating system error.
Action: Correct the operating system error given in the messages and retry the operation. See also your operating system-specific Oracle documentation.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00289: suggestion : string

ORA-00289: suggestion : string

ORA-00289: suggestion : string
Cause: This message reports the next redo log filename that is needed, according to the initialization parameters LOG_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT. This message assumes that LOG_ARCHIVE_DEST and LOG_ARCHIVE_FORMAT are the same now as when the required redo log file was archived.
Action: Consider using this filename for the next log needed for recovery.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE

ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE

ORA-00288: to continue recovery type ALTER DATABASE RECOVER CONTINUE
Cause: During media recovery, a new log is not required but the continuation command is necessary to do a checkpoint and report errors.
Action: Type ALTER DATABASE RECOVER CONTINUE and recovery will resume

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00287: specified change number string not found in thread string

ORA-00287: specified change number string not found in thread string

ORA-00287: specified change number string not found in thread string
Cause: The given change number does not appear in any of the online redo logs for the given thread.
Action: Check the statement to make certain a valid change number is given. Perhaps try to use the NEXT option for archiving logs.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/