Monday, October 27, 2014

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

ORA-00260 Cannot find online log sequence string for thread string

Error Code
ORA-00260

Description
Cannot find online log sequence string for thread string.

Cause
Possible cause of this error is, the log sequence number supplied to the archival command does not match any of the online logs for the thread. The log might have been reused for another sequence number, it might have been dropped, the sequence number might be greater than the current log sequence number, or the thread might not have any logs.

Action
To fix this issue, check the ARCHIVE statement, then specify a valid log sequence number. Specify a valid log sequence number.

reference

ORA-00259 Log string of open instance string is the current log, cannot archive

Error Code
ORA-00259

Description
Log string of open instance string (thread string) is the current log, cannot archive.

Cause
Possible cause of this error is, an attempt was made to archive the current log of an open thread. This is not allowed because the redo log file may still be in use for the generation of redo entries.

Action
To fix this issue, force a log switch in the instance where the thread is open. If no instances are open, open the database so that instance recovery can recover the thread.

reference