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
Programming Tutorials on XHTML, CSS, JavaScript, JQuery, JSON, Python, Django, Amazon Web Services, ASP.NET, Web Forms, and SQL
Monday, October 27, 2014
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-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
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
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
Subscribe to:
Posts (Atom)