Thursday, May 2, 2013

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

Tuesday, April 30, 2013

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