Friday, November 7, 2014

ORA-00277 Illegal option to the UNTIL recovery flag string

Error Code
ORA-00277

Description
Illegal option to the UNTIL recovery flag string.

Cause
Possible cause of this error is, only CANCEL, CHANGE and TIME can be used with the UNTIL keyword.

Action
To fix this issue, correct the syntax.

reference

ORA-00276 CHANGE keyword specified but no change number given

Error Code
ORA-00276

Description
CHANGE keyword specified but no change number given.

Cause
Possible cause of this error is, the CHANGE keyword was specified on the command line, but no change number was given.

Action
To fix this issue, retry the command using a valid change number after the CHANGE keyword.

reference

ORA-00275 Media recovery has already been started

Error Code
ORA-00275

Description
Media recovery has already been started.

Cause
Possible cause of this error is, an attempt was made to start a second media recovery operation in the same session.

Action
To fix this issue, complete or cancel the first media recovery session or start another session to perform media recovery.

reference

ORA-00274 Illegal recovery option string

Error Code
ORA-00274

Description
Illegal recovery option string.

Cause
Possible cause of this error is, an illegal option was specified for a recovery command.

Action
To fix this issue, correct the syntax and retry the command.

reference

Wednesday, October 29, 2014

ORA-00273 Media recovery of direct load data that was not logged

Error Code
ORA-00273

Description
Media recovery of direct load data that was not logged.

Cause
Possible cause of this error is, a media recovery session encountered a table that was loaded by the direct loader without logging any redo information. Some or all of the blocks in this table are now marked as corrupt.

Action
To fix this issue, the table must be dropped or truncated so that the corrupted blocks can be reused. If a more recent backup of the file is available, try to recover this file to eliminate this error.

reference