Monday, October 27, 2014

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

ORA-00258 Manual archiving in NOARCHIVELOG mode must identify log

Error Code
ORA-00258

Description
Manual archiving in NOARCHIVELOG mode must identify log.

Cause
Possible cause of this error is, the database is in NOARCHIVELOG mode and a command to manually archive a log did not specify the log explicitly by sequence number, group number or filename.

Action
To fix this issue, Specify log by filename, by group number or by thread and sequence number.

reference

ORA-00257 Archiver error. Connect internal only, until freed.

Error Code
ORA-00257

Description
Archiver error. Connect internal only, until freed.

Cause
Possible cause of this error is, the archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.

Action
To fix this issue, check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.

reference

ORA-00256 cannot translate archive destination string

Error Code
ORA-00256

Description
cannot translate archive destination string string.

Cause
Possible cause of this error is, the destination specified by an ALTER SYSTEM ARCHIVE LOG START TO command could not be translated.

Action
To fix this issue, check the accompanying message stack for more detailed information. Then, retry the ALTER SYSTEM command using a different string.

reference