Monday, November 10, 2014

ORA-00299 Must use file level media recovery on data file string

Error Code
ORA-00299

Description
Must use file-level media recovery on data file string.

Cause
Possible cause of this error is, the control file does not contain an entry for this file, so block media recovery cannot be done.

Action
To fix this issue, restore the data file and perform file-level media recovery.

reference

ORA-00298 Missing or invalid attribute value

Error Code
ORA-00298

Description
Missing or invalid attribute value.

Cause
Possible cause of this error is, a non-zero integer value is required when the following keyword attributes are specified: TIMEOUT, EXPIRE, DELAY, NEXT

Action
To fix this issue, correct the syntax and retry the command.

reference

ORA-00297 Must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START

Error Code
ORA-00297

Description
Must specify RECOVER DATAFILE LIST before RECOVER DATAFILE START.

Cause
Possible cause of this error is, the RECOVER DATAFILE START command was issued, but no RECOVER DATAFILE LIST commands had been issued. This only happens when doing recovery with Recovery Manager, and is an internal error in Recovery Manager, because Recovery Manager should always issue RECOVER DATAFILE LIST before RECOVER DATAFILE START.

Action
To fix this issue, contact customer support

reference

ORA-00296 Maximum number of files exceeded for RECOVER DATAFILE LIST

Error Code
ORA-00296

Description
Maximum number of files (string) exceeded for RECOVER DATAFILE LIST.

Cause
Possible cause of this error is, 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
To fix this issue, re-start the instance with a higher value for DB_FILES.

reference

ORA-00295 Datafile number string is invalid

Error Code

ORA-00295

Description

Datafile/tempfile number string is invalid, must be between 1 and string.

Cause
Possible cause of this error is, an invalid file number was specified.

Action
To fix this issue, specify a valid datafile or tempfile number and retry the operation.

reference

Sunday, November 9, 2014

ORA-00294 Invalid archivelog format specifier string

Error Code

ORA-00294


Description

Invalid archivelog format specifier 'string'.


Cause
Possible cause of this error is, 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
To fix this issue, correct the initialization file and re-start the instance.

reference

ORA-00293 Control file out of sync with redo log

Error Code
ORA-00293

Description
Control file out of sync with redo log.

Cause
Possible cause of this error is, 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
To fix this issue, retry the RECOVER command using the current control file, or retry the RECOVER command using the USING BACKUP CONTROLFILE clause.

reference

ORA-00292 Parallel recovery feature not installed

Error Code
ORA-00292

Description
Parallel recovery feature not installed.

Cause
Possible cause of this error is, a parallel recovery was requested when the parallel recovery option is not installed.

Action
To fix this issue, delete the PARALLEL clause from the RECOVER command. Also, delete the RECOVERY_PARALLELISM parameter in the initialization file.

reference

ORA-00291 Numeric value required for PARALLEL option

Error Code
ORA-00291

Description
Numeric value required for PARALLEL option.

Cause
Possible cause of this error is, a recovery command was specified incorrectly. The PARALLEL option must be followed by a numeric argument that specifies the degree of parallelism.

Action
To fix this issue, re-enter the command with a numeric argument specifying the degree of parallelism desired.

reference

ORA-00290 Operating system archival error occurred

Error Code
ORA-00290

Description
Operating system archival error occurred. See error below.

Cause
Possible cause of this error is, while attempting to archive to a redo log file, the server encountered an unexpected operating system error.

Action
To fix this issue, correct the operating system error given in the messages and retry the operation. See also your operating system-specific Oracle documentation.

reference

ORA-00289 Suggestion string

Error Code
ORA-00289

Description
Suggestion : string

Cause
Possible cause of this error is, 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
To fix this issue, consider using this filename for the next log needed for recovery.

reference

ORA-00288 To continue recovery type ALTER DATABASE RECOVER CONTINUE

Error Code
ORA-00288

Description
To continue recovery type ALTER DATABASE RECOVER CONTINUE.

Cause
Possible cause of this error is, during media recovery, a new log is not required but the continuation command is necessary to do a checkpoint and report errors.

Action
To fix this issue, type ALTER DATABASE RECOVER CONTINUE and recovery will resume.

reference

ORA-00287 Specified change number string not found in thread string

Error Code
ORA-00287

Description
Specified change number string not found in thread string.

Cause
Possible cause of this error is, the given change number does not appear in any of the online redo logs for the given thread.

Action
To fix this issue, check the statement to make certain a valid change number is given. Perhaps try to use the NEXT option for archiving logs.

reference

ORA-00286 No members available, or no member contains valid data

Error Code
ORA-00286

Description
No members available, or no member contains valid data.

Cause
Possible cause of this error is, none of the members of a redo log file group are available, or the available members do not contain complete data.

Action
To fix this issue, if a member is temporarily offline, attempt to make it available. Make sure that the correct filenames are being used, especially if the redo log file is being accessed from a remote location.

reference

ORA-00285 TIME not given as a string constant

Error Code
ORA-00285

Description
TIME not given as a string constant.

Cause
Possible cause of this error is, UNTIL TIME was not followed by a string constant for the time.

Action
To fix this issue, enter the time enclosed in single quotation marks.

reference

ORA-00284 Recovery session still in progress

Error Code
ORA-00284

Description
Recovery session still in progress.

Cause
Possible cause of this error is, an error during recovery was determined to be minor enough to allow the current recovery session to continue.

Action
To fix this issue, more specific messages will accompany this message. Refer to the other messages for the appropriate action.

reference

ORA-00283 Recovery session canceled due to errors

Error Code
ORA-00283

Description
Recovery session canceled due to errors.

Cause
Possible cause of this error is, an error during recovery was determined to be fatal enough to end the current recovery session.

Action
To fix this issue, more specific messages will accompany this message. Refer to the other messages for the appropriate action.

reference

ORA-00282 UPI string call not supported, use ALTER DATABASE RECOVER

Error Code
ORA-00282

Description
UPI string call not supported, use ALTER DATABASE RECOVER.

Cause
Possible cause of this error is, the given UPI call is no longer supported.

Action
To fix this issue, use the ALTER DATABASE RECOVER command for all recovery actions.

reference

ORA-00281 Media recovery may not be performed using dispatcher

Error Code
ORA-00281

Description
Media recovery may not be performed using dispatcher.

Cause
Possible cause of this error is, an attempt was made to use a dispatcher process for media recovery. Memory requirements disallow this recovery method.

Action
To fix this issue, connect to the instance via a dedicated server process to perform media recovery.

reference

ORA-00280 Change string for thread string is in sequence string

Error Code
ORA-00280

Description
Change string for thread string is in sequence #string.

Cause
Possible cause of this error is, this message helps to locate the redo log file with the specified change number requested by other messages.

Action
To fix this issue, use the information provided in this message to specify the required archived redo log files for other errors.

reference

ORA-00279 Change string generated at string needed for thread string

Error Code
ORA-00279

Description
Change string generated at string needed for thread string.

Cause
Possible cause of this error is, the requested log is required to proceed with recovery.

Action
To fix this issue, please supply the requested log with "ALTER DATABASE RECOVER LOGFILE <file_name>" or cancel recovery with "ALTER DATABASE RECOVER CANCEL".

reference

Friday, November 7, 2014

ORA-00278 Log file string no longer needed for this recovery

Error Code
ORA-00278

Description
Log file string no longer needed for this recovery.

Cause
Possible cause of this error is, the specified redo log file is no longer needed for the current recovery.

Action
No action required. The archived redo log file may be removed from its current location to conserve disk space, if needed. However, the redo log file may still be required for another recovery session in the future.

reference

ORA-00277 Illegal option to the UNTIL recovery flag string

Error Code
ORA-00277

Description
Illegal option to the UNTIL recovery flag string.

Cause
Possible cause of this error is, only CANCEL, CHANGE and TIME can be used with the UNTIL keyword.

Action
To fix this issue, correct the syntax.

reference

ORA-00276 CHANGE keyword specified but no change number given

Error Code
ORA-00276

Description
CHANGE keyword specified but no change number given.

Cause
Possible cause of this error is, the CHANGE keyword was specified on the command line, but no change number was given.

Action
To fix this issue, retry the command using a valid change number after the CHANGE keyword.

reference

ORA-00275 Media recovery has already been started

Error Code
ORA-00275

Description
Media recovery has already been started.

Cause
Possible cause of this error is, an attempt was made to start a second media recovery operation in the same session.

Action
To fix this issue, complete or cancel the first media recovery session or start another session to perform media recovery.

reference

ORA-00274 Illegal recovery option string

Error Code
ORA-00274

Description
Illegal recovery option string.

Cause
Possible cause of this error is, an illegal option was specified for a recovery command.

Action
To fix this issue, correct the syntax and retry the command.

reference