Release 8.0.4
A58312-01
 Library |
 Product |
 Contents |
 Index |
| Oracle8 Error Messages Release 8.0.4 A58312-01 |
|
This section lists messages generated when the Redo Log Files are accessed.
Cause: The specified block size of the redo log file is greater than the maximum block size for the operating system.
Action: Create the redo log on a device with a smaller block size.
Cause: The creation of the redo log file failed.
Action: Check that there is enough storage space on the device, that the name of the file is valid, and that the device is online; then try again. Also, it is possible REUSE was specified on the command line and a file of the incorrect size exists. Either do not specify REUSE or use a file of the correct size.
Cause: The maximum number of redo log files has been exceeded. There is a limit, set at database creation, on the number of redo log files (typically 16).
Action: Use the CREATE CONTROLFILE command with a larger value for MAXLOGFILES.
Cause: An instance tried to start by using a value of the initialization parameter INSTANCE_NUMBER that is already in use.
Action: Specify another value for INSTANCE_NUMBER in the initialization parameter file or wait for recovery to finish for that instance number. Then restart the instance.
Cause: The database ID in the redo log file does not match the database ID in the control file. This redo log file is not from the current database.
Action: Specify the correct redo log file, then retry the operation.
Cause: Starting this instance would exceed the maximum number of instances allowed for this database. This message occurs only when attempting to start another instance in Parallel Server mode.
Action: It is not possible to start more than the given number of instances. The maximum is the lower of the operating system-specific maximum or the MAXINSTANCES option specified in the CREATE DATABASE statement. See also your operating system-specific Oracle documentation.
Cause: The initialization parameter INSTANCE_NUMBER specified a number that was out of range.
Action: Change INSTANCE_NUMBER to a valid range and restart the instance. The minimum value is one and the maximum value is the lower of the operating system-specific maximum or the MAXINSTANCES option specified in the CREATE DATABASE statement. See also your operating system-specific Oracle documentation.
Cause: The system cannot access a required archived redo log file.
Action: Check that the off line log exists, the storage device is online, and the archived file is in the correct location. Then attempt to continue recovery or restart the recovery session.
Cause: The system cannot access the archived redo log because it belongs to another database.
Action: Specify the correct redo log file, then retry the operation.
Cause: The archived log is out of sequence, probably because it is corrupted or the wrong redo log filename was specified during recovery.
Action: Specify the correct redo log file; then retry the operation.
Cause: An error occurred when attempting to read the file header from the archived redo log file.
Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
Cause: This message reports the filename for details of another message.
Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
Cause: The online log cannot be opened. The file may not be in the expected location.
Action: Specify the correct redo log file or make log available, if necessary. Also, see the following messages, if any.
Cause: The online log is out of sequence, probably because it is corrupted or an old version.
Action: For more information on recovery procedures, see the Oracle8 Server Administrator's Guide.
Cause: The online redo log file is corrupted or is an old version.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: The online redo log file is corrupted or is an old version.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: This is not an archived redo log file.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: The file size indicated in the control file did not match the file size contained in the redo log file.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: An online redo log file has log reset data that is different from the log reset data listed in the control file. The redo log file is probably an incorrectly restored backup.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: The system is unable to read the redo log file header because the file is not available or the file is corrupted.
Action: Specify the correct redo log file, then retry the operation.
Cause: The system cannot write to the redo log file.
Action: Restore access to the redo log file; then retry the operation.
Cause: An online redo log file appears to be an incorrectly restored backup, according to a check of the redo log file header.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: An attempt to open a thread failed because it is necessary to switch to another online log, but all the other online redo logs need to be archived before they can be used.
Action: Archive the online redo logs for the thread, then retry the operation.
Cause: The translated name for a redo log file is too long.
Action: Respecify a redo log filename that produces a shorter filename on translation.
Cause: The archived redo log file is corrupted, or it belongs to another thread. This redo log file cannot be used.
Action: Find and use the correct archived redo log file, then retry the operation.
Cause: The archived redo log file supplied for recovery was generated after the redo log file that is needed. Cannot use the log for applying redo information at this time.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: A redo log file has shrunk in size. This is usually caused by a computer operator's mistake or an operating system error.
Action: Restore the redo log file from backup. If the database was shut down cleanly, no further action should be required. Otherwise, manual recovery may be necessary.
Cause: The archived redo log file supplied for recovery was generated before the log that is needed. Cannot use the log for applying redo information at this time.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: The archived redo log file supplied for recovery is not the correct log. An earlier redo log file is needed.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: The archived redo log file supplied for recovery is not the correct log. A later redo log file is needed.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: The log was created under an older, incompatible version of Oracle, or an attempt was made to use the wrong log.
Action: Specify the correct redo log file or recover the database with the old software. Then shut down and restart Oracle with the new software.
Cause: The log occupies less space than is allocated to it. This may result from a shutdown abort while the archiver was writing it.
Action: Get a complete version of the file, either the online version or one that was successfully archived, and use that for recovery.
Cause: An error occurred while reading the redo log file. Other messages will accompany this message and will give the name of the file.
Action: Restore access to the file or get another copy of the file.
Cause: This message reports the filename involved with other errors.
Action: See the associated messages for a description of the problem.
Cause: This message reports the filename involved with other messages.
Action: Correct the underlying problems mentioned in the other messages.
Cause: The redo log file size specified in the CREATE DATABASE statement is too small.
Action: Increase the redo log file size and re-enter the statement.
Cause: The system could not add a redo log file because it could not find an existing file or a size for creating the file.
Action: Specify a size for the redo log file, then retry the operation.
Cause: The control file change sequence number in the redo log file is greater than the number in the control file. This implies that the wrong control file is being used. Note that repeatedly causing this error to happen by reopening the database may cause the error to stop happening without correcting the problem. Every attempt to open the database advances the control file change sequence number.
Action: Use the correct control file or perform recovery using a backup of the control file.
Cause: The archived log being applied is not the correct log. The log being applied is possibly a copy of a log or was an online log being prepared to be used as the current log.
Action: Restore the correct redo log file.
Cause: An I/O error occurred on the named online redo log file, probably because the file was not accessible or because it was corrupted.
Action: Restore access to the file or restore the file from a backup.
Cause: The internal information in an online redo log file does not match the control file information.
Action: Refer to the Oracle8 Server Administrator's Guide for recovery procedures.
Cause: Recovery was given a log that was created before the last ALTER DATABASE OPEN RESETLOGS command. There should be another log created since then that contains the correct redo.
Action: Find and install the correct archived redo log file, then retry the operation.
Cause: The maximum number of errors on this log member has been exceeded. Other messages will accompany this message.
Action: Correct the underlying problems mentioned in the other messages.
Cause: An I/O failure occurred when attempting to recreate an online log as part of either an ALTER DATABASE OPEN RESETLOGS or ALTER DATABASE CLEAR log file command.
Action: Check the accompanying messages. Check that the file is accessible.
Cause: An I/O error has occurred while writing the log, probably because the file was not accessible, or a device failed.
Action: Make the file accessible or restore the device, then restart the system. If the log is lost, apply media or incomplete recovery.
Cause: A redo log file member is no longer complete. Other messages will accompany this message.
Action: Correct the underlying problem mentioned in the other messages.
Cause: During online recovery, the block size specified in the control file did not match the block size indicated in the redo log file.
Action: Restore the correct redo log file from a backup or reset the online redo log files.
Cause: A failure occurred during a single-process redo log operation. This error does not occur during normal multi-process operations.
Action: Shut down and restart the database.
Cause: The operating system was unable to determine the block size for the named file.
Action: Check the accompanying messages, then restore the device or specify another file.
Cause: Media recovery is enabled and the specified log was not archived.
Action: Archive the redo log file or disable media recovery. If the command supports the UNARCHIVED option, then it can be used. However, this may result in making backups unusable and forcing some offline files to be dropped.
Cause: The time specified in a RECOVER DATABASE... UNTIL is before January 1, 1988.
Action: Specify a time after January 1, 1988.
Cause: An attempt was made to enable a thread when all of the online redo log files in the thread needed to be archived, and media recovery has been enabled. There is no online redo log file that can be made the new current log for the thread.
Action: Archive a redo log file for the thread.
Cause: Some type of redo log file corruption has been discovered. This message describes the location of the corruption. Other messages will accompany this message and describe the type of corruption.
Action: Perform recovery with a good version of the redo log file or perform incomplete recovery up to the indicated change or time. For more information about recovery and incomplete recovery, see the index entries on "recovery, incomplete" and on "redo log files" in Oracle8 Server Concepts.
Cause: The block header on the block in the redo log file is not valid. The block number and time-stamp are given in an accompanying message.
Action: Perform recovery with a good version of the redo log file or perform cancel-based recovery up to, but not including, the corrupted redo log file.
Cause: A change number found in the redo log file is lower than a previously encountered change number. The redo log file is corrupted in some way. The corruption may be at the earlier change number or at this one. The block number and time-stamp are given in an accompanying message.
Action: Perform recovery with a good version of the redo log file or perform time-based recovery up to the indicated time.
Cause: A change record in the redo log file contains lengths that do not add up to a consistent value. The redo log file is corrupted in some way.
Action: Perform recovery with a good version of the redo log file or perform time-based recovery up to the indicated time.
Cause: An attempt was made to add a redo log group or add a redo log group member that would result in a set of online redo logs with too many members. The maximum number of members is set when the database is created.
Action: Use fewer redo log group members or use the CREATE CONTROLFILE command and set the parameter MAXLOGMEMBERS to a larger value.
Cause: A CREATE or ALTER statement specified too many members in the file list.
Action: Specify a number of files that is within the given limit or use the CREATE CONTROLFILE command and set the parameter MAXLOGMEMBERS to a larger value.
Cause: An attempt to add or drop a redo log group member specified a redo log file group number that does not exist.
Action: Check the configuration of the redo log files and retry the command with a valid group number.
Cause: An invalid filename was given to drop a redo log group member. Either the file is not a part of the database, or it is a datafile.
Action: Specify a valid member name and retry the command.
Cause: An attempt was made to remove the last member of a redo log group.
Action: If desired, delete the entire log by using the DROP log file command.
Cause: A request to drop a redo log group member was denied because it would remove data required to form a complete online redo log group.
Action: If desired, delete the entire log after archiving, if required, using the DROP log file command.
Cause: The log given for recovery is a backup of the online version from the time it was the current log. The archived version of the log would not be marked as the end of the thread. This message can also be caused by failing to list the current log of an enabled thread in a CREATE CONTROLFILE command.
Action: Find the archived version of the log and specify its name. If this is media recovery immediately following a CREATE CONTROLFILE, be sure the current log for this thread was included.
Cause: An I/O error occurred when attempting to write the header to a redo log group member that is being added to an existing group.
Action: See accompanying messages. Fix the problem or use another file.
Cause: The specified log failed to pass checks to ensure it corresponds to the log that was generated against a cold backup image of the database.
Action: Find the log that was generated by this copy of the database and give that filename to recover.
Cause: The file header for the redo log contains a checksum that does not match the value calculated from the file header as read from disk. This means the file header is corrupted
Action: Find and install correct version of log or reset logs.
Cause: The file header for the redo log contains a checksum that does not match the value calculated from the file header as read from disk. This means the file header is corrupted
Action: Find the correct file and try again.
Cause: The redo block indicated by the accompanying error, is not valid. It has a checksum that does not match the block contents.
Action: Do recovery with a good version of the log or do time based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be skipped by clearing the log with the UNARCHIVED option. This must be followed by a backup of every datafile to insure recoverability of the database.
Cause: Attempt to open thread failed because it is necessary to switch redo generation to another online log, but all the other logs are being cleared or need to be archived before they can be used.
Action: If the ALTER DATABASE CLEAR log file command is still active then wait for it to complete. Otherwise, re-enter the CLEAR command. If there are other online logs for the thread that are not being cleared, then archive the logs.
