Monday, November 10, 2014

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