Monday, October 27, 2014

ORA-00265 Instance recovery required, cannot set ARCHIVELOG mode

Error Code
ORA-00265

Description
Instance recovery required, cannot set ARCHIVELOG mode.

Cause
Possible cause of this error is, the database either crashed or was shutdown with the ABORT option. Media recovery cannot be enabled because the online logs may not be sufficient to recover the current datafiles.

Action
To fix this issue, open the database and then enter the SHUTDOWN command with the NORMAL or IMMEDIATE option.

reference

ORA-00264 No recovery required

Error Code
ORA-00264

Description
No recovery required.

Cause
Possible cause of this error is, an attempt was made to perform media recovery on files that do not // need any type of recovery.

Action
To fix this issue, do not attempt to perform media recovery on the selected files. Check to see that the filenames were entered properly. If not, retry the command with the proper filenames.

reference

ORA-00263 there are no logs that need archiving for thread string

Error Code
ORA-00263

Description
There are no logs that need archiving for thread string.

Cause
Possible cause of this error is, an attempt was made to manually archive the unarchived logs in this thread but no logs needed archiving.

Action
No action required.

reference

ORA-00262 Current log string of closed thread string cannot switch

Error Code
ORA-00262

Description
Current log string of closed thread string cannot switch.

Cause
Possible cause of this error is, the log cannot be cleared or manually archived because it is the current log of a closed thread, and it is not possible to switch logs so another log is current. All other logs for the thread need to be archived, or cleared, and cannot be reused.

Action
To fix this issue, archive another log in the same thread first, or complete the clearing. See attached errors for the reason the switch cannot be completed.

reference

ORA-00261 Log string of thread string is being archived or modified

Error Code
ORA-00261

Description
Log string of thread string is being archived or modified.

Cause
Possible cause of this error is, the log is either being archived by another process or an administrative command is modifying the log. Operations that modify the log include clearing, adding a member, dropping a member, renaming a member, and dropping the log.

Action
To fix this issue, wait for the current operation to complete and try again.

reference