Sunday, November 9, 2014

ORA-00288 To continue recovery type ALTER DATABASE RECOVER CONTINUE

Error Code
ORA-00288

Description
To continue recovery type ALTER DATABASE RECOVER CONTINUE.

Cause
Possible cause of this error is, during media recovery, a new log is not required but the continuation command is necessary to do a checkpoint and report errors.

Action
To fix this issue, type ALTER DATABASE RECOVER CONTINUE and recovery will resume.

reference

ORA-00287 Specified change number string not found in thread string

Error Code
ORA-00287

Description
Specified change number string not found in thread string.

Cause
Possible cause of this error is, the given change number does not appear in any of the online redo logs for the given thread.

Action
To fix this issue, check the statement to make certain a valid change number is given. Perhaps try to use the NEXT option for archiving logs.

reference

ORA-00286 No members available, or no member contains valid data

Error Code
ORA-00286

Description
No members available, or no member contains valid data.

Cause
Possible cause of this error is, none of the members of a redo log file group are available, or the available members do not contain complete data.

Action
To fix this issue, if a member is temporarily offline, attempt to make it available. Make sure that the correct filenames are being used, especially if the redo log file is being accessed from a remote location.

reference

ORA-00285 TIME not given as a string constant

Error Code
ORA-00285

Description
TIME not given as a string constant.

Cause
Possible cause of this error is, UNTIL TIME was not followed by a string constant for the time.

Action
To fix this issue, enter the time enclosed in single quotation marks.

reference

ORA-00284 Recovery session still in progress

Error Code
ORA-00284

Description
Recovery session still in progress.

Cause
Possible cause of this error is, an error during recovery was determined to be minor enough to allow the current recovery session to continue.

Action
To fix this issue, more specific messages will accompany this message. Refer to the other messages for the appropriate action.

reference