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
Programming Tutorials on XHTML, CSS, JavaScript, JQuery, JSON, Python, Django, Amazon Web Services, ASP.NET, Web Forms, and SQL
Sunday, November 9, 2014
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-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-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-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-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
Subscribe to:
Posts (Atom)