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

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