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

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-00254 Error in Archive Control String

Error Code
ORA-00254

Description
Error in archive control string 'string'.

Cause
Possible cause of this error is, the specified archive log location is invalid in the archive command or the LOG_ARCHIVE_DEST initialization parameter.

Action
To fix this issue, check the archive string used to make sure it refers to a valid online device.

reference

ORA-00253 Character Limit String Exceeded by Archive Destination

Error Code
ORA-00253

Description
Character limit string exceeded by archive destination string string.

Cause
Possible cause of this error is, the destination specified by an ALTER SYSTEM ARCHIVE LOG START TO command was too long.

Action
To fix this issue, retry the ALTER SYSTEM command using a string shorter than the limit specified in the error message.

reference

ORA-00252 Log String of Thread String is Empty

Error Code
ORA-00252

Description
Log string of thread string is empty, cannot archive.

Cause
Possible cause of this error is, a log must be used for redo generation before it can be archived. The specified redo log was not been used since it was introduced to the database. However it is possible that instance death during a log switch left the log empty.

Action
To fix this issue, empty logs do not need to be archived. Do not attempt to archive the redo log file.

reference

ORA-00251 LOG_ARCHIVE_DUPLEX_DEST cannot be the Same Destination

Error Code
ORA-00251

Description
LOG_ARCHIVE_DUPLEX_DEST cannot be the same destination as string string.

Cause
Possible cause of this error is, the destination specified by the LOG_ARCHIVE_DUPLEX_DEST parameter is the same as the destination specified by an ALTER SYSTEM ARCHIVE LOG START TO command.

Action
To fix this issue, specify a different destination for parameter LOG_ARCHIVE_DUPLEX_DEST, or specify a different destination with the ALTER SYSTEM command.

reference

ORA-00250 Archiver not Started

Error Code
ORA-00250

Description
Archiver not started.

Cause
Possible cause of this error is, an attempt was made to stop automatic archiving, but the archiver process was not running.

Action
No action required.

reference

ORA-00238 Operation would Reuse a Filename that is Part of the Database

Error Code
ORA-00238

Description
Operation would reuse a filename that is part of the database.

Cause
Possible cause of this error is, the filename supplied as a parameter to the ALTER DATABASE BACKUP CONTROLFILE command or to cfileSetSnapshotName matches the name of a file that is currently part of the database.

Action
To fix this issue, retry the operation with a different filename.

reference

ORA-00237 Snapshot Operation Disallowed Control File Newly Created

Error Code
ORA-00237

Description
Snapshot operation disallowed, control file newly created.

Cause
Possible cause of this error is, an attempt to invoke cfileMakeAndUseSnapshot with a currently mounted control file that was newly created with CREATE CONTROLFILE was made.

Action
To fix this issue, mount a current control file and retry the operation.

reference

ORA-00236 Snapshot Operation Disallowed Mounted Control File is a Backup

Error Code
ORA-00236

Description
Snapshot operation disallowed, mounted control file is a backup.

Cause
Possible cause of this error is, attempting to invoke cfileSetSnapshotName, cfileMakeAndUseSnapshot, or cfileUseSnapshot when the currently mounted control file is a backup control file.

Action
To fix this issue, mount a current control file and retry the operation.

reference

ORA-00235 Control File Fixed Table Inconsistent due to Concurrent Update

Error Code
ORA-00235

Description
Control file fixed table inconsistent due to concurrent update.

Cause
Possible cause of this error is, concurrent update activity on a control file caused a query on a control file fixed table to read inconsistent information.

Action
To fix this issue, retry the operation.

reference

ORA-00234 Error in Identifying or Opening Snapshot or Copy Control File

Error Code
ORA-00234

Description
Error in identifying or opening snapshot or copy control file

Cause
Possible cause of this error is, a snapshot or copy control file of the specified name could not be found or opened during an invocation of cfileUseSnapshot, cfileMakeAndUseSnapshot, or cfileUseCopy.

Action
To fix this issue, re-create the snapshot or copy control file using cfileMakeAndUseSnapshot or ALTER DATABASE BACKUP CONTROLFILE, respectively.

reference

ORA-00233 Copy Control File is Corrupt or Unreadable

Error Code
ORA-00233

Description
Copy control file is corrupt or unreadable.

Cause
Possible cause of this error is, the specified copy control file was found to be corrupt or unreadable during an invocation of cfileUseCopy.

Action
To fix this issue, before retrying cfileUseCopy, use the ALTER DATABASE BACKUP CONTROLFILE command and specify the same filename that was specified for cfileUseCopy.

reference

ORA-00232 Snapshot Control File is Nonexistent Corrupt or Unreadable

Error Code
ORA-00232

Description
Snapshot control file is nonexistent, corrupt, or unreadable.

Cause
Possible cause of this error is, the snapshot control file was found to be nonexistent, corrupt, or unreadable during an invocation of cfileUseSnapshot.

Action
To fix this issue, call cfileMakeAndUseSnapshot again or for the first time.

reference

ORA-00231 Snapshot Control File has not been Named

ErrorCode
ORA-00231

Description
Snapshot control file has not been named.

Cause
Possible cause of this error is, during an invocation of cfileMakeAndUseSnapshot or cfileUseSnapshot it was detected that no filename for the snapshot control file had previously been specified.

Action
To fix this issue, specify a name for the snapshot control file by calling cfileSetSnapshotName.

reference

ORA-00230 Operation Disallowed Snapshot Control File Enqueue Unavailable

Error Code
ORA-00230

Description
Operation disallowed, snapshot control file enqueue unavailable.

Cause
Possible cause of this error is, the attempted operation cannot be executed at this time because another process currently holds the snapshot control file enqueue.

Action
To fix this issue, retry the operation after the concurrent operation that is holding the snapshot control file enqueue terminates.

reference

ORA-00229 Operation Disallowed Already Hold Snapshot Control File Enqueue

Error Code
ORA-00229

Description
Operation disallowed already hold snapshot control file enqueue.

Cause
Possible cause of this error is, the attempted operation cannot be executed at this time because this process currently holds the snapshot control file enqueue.

Action
To fix this issue, retry the operation after calling cfileUseCurrent to release the snapshot control file enqueue.

reference