Monday, November 10, 2014

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