Category Archives: ORA Database Error Messages

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

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

ORA-00286: no members available, or no member contains valid data
Cause: None of the members of a redo log file group are available, or the available members do not contain complete data.
Action: 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.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00285: TIME not given as a string constant

ORA-00285: TIME not given as a string constant

ORA-00285: TIME not given as a string constant
Cause: UNTIL TIME was not followed by a string constant for the time.
Action: Enter the time enclosed in single quotation marks.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00284: recovery session still in progress

ORA-00284: recovery session still in progress

ORA-00284: recovery session still in progress
Cause: An error during recovery was determined to be minor enough to allow the current recovery session to continue.
Action: More specific messages will accompany this message. Refer to the other messages for the appropriate action.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00283: recovery session canceled due to errors

ORA-00283: recovery session canceled due to errors

ORA-00283: recovery session canceled due to errors
Cause: An error during recovery was determined to be fatal enough to end the current recovery session.
Action: More specific messages will accompany this message. Refer to the other messages for the appropriate action.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER

ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER

ORA-00282: UPI string call not supported, use ALTER DATABASE RECOVER
Cause: The given UPI call is no longer supported.
Action: Use the ALTER DATABASE RECOVER command for all recovery actions.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00281: media recovery may not be performed using dispatcher

ORA-00281: media recovery may not be performed using dispatcher

ORA-00281: media recovery may not be performed using dispatcher
Cause: An attempt was made to use a dispatcher process for media recovery. Memory requirements disallow this recovery method.
Action: Connect to the instance via a dedicated server process to perform media recovery.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00280: change string for thread string is in sequence #string

ORA-00280: change string for thread string is in sequence #string

ORA-00280: change string for thread string is in sequence #string
Cause: This message helps to locate the redo log file with the specified change number requested by other messages.
Action: Use the information provided in this message to specify the required archived redo log files for other errors.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00279: change string generated at string needed for thread string

ORA-00279: change string generated at string needed for thread string

ORA-00279: change string generated at string needed for thread string
Cause: The requested log is required to proceed with recovery.
Action: Please supply the requested log with “ALTER DATABASE RECOVER LOGFILE <file_name>” or cancel recovery with “ALTER DATABASE RECOVER CANCEL”.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00278: log file ‘string’ no longer needed for this recovery

ORA-00278: log file ‘string’ no longer needed for this recovery

ORA-00278: log file ‘string’ no longer needed for this recovery
Cause: The specified redo log file is no longer needed for the current recovery.
Action: No action required. The archived redo log file may be removed from its current location to conserve disk space, if needed. However, the redo log file may still be required for another recovery session in the future.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-00277: illegal option to the UNTIL recovery flag string

ORA-00277: illegal option to the UNTIL recovery flag string

ORA-00277: illegal option to the UNTIL recovery flag string
Cause: Only CANCEL, CHANGE and TIME can be used with the UNTIL keyword.
Action: Correct the syntax.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/