Thursday, May 2, 2013

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

Wednesday, May 1, 2013

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