Oracle Database Errors or Warnings from Error ORA-01671 to ORA-01680



ORA-01671: control file is a backup, cannot make a standby control file
Cause: The currently mounted control file is a backup control file, and attempting to create a control file for a standby database.
Action: Complete any needed recovery and open the database with the resetlogs option.
ORA-01672: control file may be missing files or have extra ones
Cause: Attempting to create a standby control file, but the control file was either recently created via CREATE CONTROLFILE or an incomplete recovery has been done. Thus the datafiles in the control file and the ones in the data dictionary may not match.
Action: Open the database, then retry the operation.
ORA-01673: data file string has not been identified
Cause: This data file was not in the control file after an incomplete recovery or CREATE CONTROLFILE. Since information from its header is needed for standby database recovery, we can not create a standby control file.
Action: Find the file and bring it online. If desired it may be taken offline again. If you intend to drop this file, then taking it offline with the DROP option will avoid this error.

ORA-01674: data file string is an old incarnation rather than current file
Cause: Recovery encountered redo that indicates this file was dropped from the database and another file was added using the same file number. This implies that a CREATE CONTROLFILE command was given the old file which was dropped rather than the latest file.
Action: Rebuild the control file using CREATE CONTROLFILE, and give the correct file.
ORA-01675: max_commit_propagation_delay inconsistent with other instances
Cause: The max_commit_propagation_delay INIT.ORA parameter is inconsistent with those in other instances.
Action: Make sure all instances have the same max_commit_propagation_delay.
ORA-01676: standby file name convert of ‘string’ exceeds maximum length of string
Cause: When the given file name is converted to the name used for the standby database, the converted name is bigger than the maximum allowed file name.
Action: Change initialization parameter DB_FILE_STANDBY_NAME_CONVERT or LOG_FILE_STANDBY_NAME_CONVERT to convert to a valid file name.

ORA-01677: standby file name convert parameters differ from other instance
Cause: The DB_FILE_STANDBY_NAME_CONVERT or LOG_FILE_STANDBY_NAME_CONVERT initialization parameters are not the same as in other instances that already have the database mounted.
Action: Change initialization parameters DB_FILE_STANDBY_NAME_CONVERT and LOG_FILE_STANDBY_NAME_CONVERT to match other instances.
ORA-01678: parameter string must be pairs of pattern and replacement strings
Cause: The initialization parameter does not have even number of strings for its value. The odd numbered strings are patterns to be found in file names. The even numbered strings are used to replace the corresponding patterns when found in file names.
Action: Specify even number of strings for the parameter, or omit the parameter.
ORA-01679: database is being opened
Cause: An attempt was made to activate a standby database when the database was in the middle of being opened.
Action: Wait for database open to finish and retry the ACTIVATE command.
ORA-01680: unable to extend LOB segment by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for a LOB segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Above are list of Oracle Database Errors or Warnings from Error ORA-01671 to ORA-01680 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *