Monday, October 27, 2014

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

Wednesday, October 22, 2014

ORA-00255 Error archiving log string of thread string

Error Code
ORA-00255

Description

Error archiving log string of thread string, sequence # string

Cause

Possible cause of this error is, an error occurred during archiving.

Action

To fix this issue, check the accompanying message stack for more detailed information. If the online log is corrupted, then the log can be cleared using the UNARCHIVED option. This will make any existing backups useless for recovery to any time after the log was created, but will allow the database to generate redo.

reference

Do events have return type?