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