Oracle错误代码超级大全(5)

2019-08-30 19:49

filename was specified

解决: Specify the correct redo log file; then retry the operation. ORA-00311: cannot read header from archived log

原因: An I/O error occurred when attempting to read the log file header from the specified archived redo log file.

解决: Other messages will accompany this message. See the associated messages for the appropriate action to take.

ORA-00312: online log string thread string: \

原因: This message reports the filename for details of another message.

解决: Other messages will accompany this message. See the associated messages for the appropriate action to take.

ORA-00313: open failed for members of log group string of thread string 原因: The online log cannot be opened. May not be able to find file. 解决: See accompanying errors and make log available.

ORA-00314: log string of thread string, expected sequence# string doesn\ 原因: The online log is corrupted or is an old version. 解决: Find and install correct version of log or reset logs.

ORA-00315: log string of thread string, wrong thread # string in header 原因: The online log is corrupted or is an old version. 解决: Find and install correct version of log or reset logs.

ORA-00316: log string of thread string, type string in header is not log file 原因: The online log is corrupted or is an old version. 解决: Find and install correct version of log or reset logs. ORA-00317: file type string in header is not log file 原因: This is not an archived log file. 解决: Find the correct file and try again.

ORA-00318: log string of thread string, expected file size string doesn\

原因: On header read the file size indicated in the control file did not match the file size contained in the log file.

解决: Restore correct file or reset logs.

ORA-00319: log string of thread string has incorrect log reset status

原因: Check of log file header at database open found that an online log has log reset data that is different from the control file. The log is probably an incorrectly restored backup. 解决: Restore correct file or reset logs.

ORA-00320: cannot read file header from log string of thread string 原因: The file is not available. 解决: Restore the log file.

ORA-00321: log string of thread string, cannot update log file header 原因: Cannot write to the log file. 解决: Restore the access to the file.

ORA-00322: log string of thread string is not current copy

原因: Check of log file header at database open found that an online log appears to be an incorrectly restored backup.

解决: Restore correct file or reset logs.

第21页

ORA-00323: Current log of thread string not useable and all others need archiving

原因: Attempt to open thread failed because it is necessary to switch redo generation to another online log, but all the other logs need to be archived before they can be used. 解决: Archive the logs for the thread then retry open.

ORA-00324: log file \too long, string characters exceeds string limit

原因: the translated name for a log file is too long.

解决: Choose a untranslated name that yields a shorter translated name. ORA-00325: archived log for thread string, wrong thread # string in header

原因: The archived log is corrupted or for another thread. Can not use the log for applying redo. 解决: Find correct archived log.

ORA-00326: log begins at change string, need earlier change string

原因: The archived log supplied for recovery was generated after the log that is needed. Can not yet use the log for applying redo. 解决: Find correct archived log.

ORA-00327: log string of thread string, physical size string less than needed string

原因: A log file has shrunk in size. This is likely to have been caused by operator or operating system error.

解决: Restore the log file from backup. If backup is not available, drop this log and re-create. If the database was shut down cleanly, no further action should be required; otherwise incomplete recovery may be required.

ORA-00328: archived log ends at change string, need later change string

原因: The archived log supplied for recovery was generated before the log that is needed. Can not use the log for applying redo. 解决: Find correct archived log.

ORA-00329: archived log begins at change string, need change string 原因: The archived log is not the correct log. An earlier log is needed. 解决: Restore the correct log file.

ORA-00330: archived log ends at change string, need change string 原因: The archived log is not the correct log. A later log is needed. 解决: Restore the correct log file.

ORA-00331: log version string incompatible with ORACLE version string 原因: The log was written by incompatible version of Oracle.

解决: Recover the database with the compatible software, shut it down cleanly, then restart with current software.

ORA-00332: archived log is too small - may be incompletely archived

原因: The log is smaller than the space allocated in it. May be the result of a shutdown abort while it was being written by the archiver.

解决: Get a complete version of this log and use it for recovery. There should either be an online version of it or a copy that was successfully archived. ORA-00333: redo log read error block string count string

原因: An IO error occurred while reading the log described in the accompanying error. 解决: Restore accessibility to file, or get another copy of the file. ORA-00334: archived log: \

第22页

原因: Reporting filename for details of another error 解决: See associated error messages

ORA-00335: online log string: No log with this number, log does not exist 原因: Reporting filename for details of another error 解决: See associated error messages

ORA-00336: log file size string blocks is less than minimum string blocks 原因: The log file size as specified in create database is too small. 解决: Increase the log file size.

ORA-00337: log file \

原因: An attempt to add a log found neither an existing file nor a size for creating the file. 解决: Specify a size for the log file.

ORA-00338: log string of thread string is more recent than control file

原因: The control file change sequence number in the 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 can make it stop happening without correcting the real problem. Every attempt to open the database will advance the control file change sequence number until it is great enough.

解决: Use the current control file or do backup control file recovery to make the control file current. Be sure to follow all restrictions on doing a backup control file recovery. ORA-00339: archived log does not contain any redo 原因: The archived log is not the correct log. It is a copy of a log file that has never been used for redo generation, or was an online log being prepared to be the current log. 解决: Restore the correct log file.

ORA-00340: IO error processing online log string of thread string 原因: An IO error occurred on the named online log.

解决: Restore accessibility to file, or restore file from backup.

ORA-00341: log string of thread string, wrong log # string in header

原因: The internal information in an online log file does not match the control file. 解决: Restore correct file or reset logs.

ORA-00342: archived log does not have expected resetlogs SCN string

原因: Recovery was given a log that does not belong to current incarnation or one of the parent incarnation. There should be another log that contains the correct redo. 解决: Supply the correct log file.

ORA-00343: too many errors, log member closed

原因: The maximum number of errors on this log member has been exceeded.

解决: Correct the underlying problem by referring to the other error messages found with this one.

ORA-00344: unable to re-create online log \

原因: An I/O failure occurred when attempting to re-create an online as part of either ALTER DATABASE OPEN RESETLOGS or ALTER DATABASE CLEAR LOGFILE command. 解决: Correct the file/device as indicated by accompanying errors. ORA-00345: redo log write error block string count string 原因: An IO error has occurred while writing the log

解决: Correct the cause of the error, and then restart the system. If the log is lost, apply media/incomplete recovery.

第23页

ORA-00346: log member marked as STALE 原因: A log file member no longer is complete.

解决: Correct the underlying problem by referring to the other error messages found with this one.

ORA-00347: log string of thread string, expected block size string doesn\

原因: On header read the blocksize indicated in the control file did not match the blocksize contained in the log file.

解决: Restore correct file or reset logs.

ORA-00348: single-process redo failure. Must abort instance

原因: A failure occurred during a critical portion of the log code during single process operation. This error does not occur during normal multi-process operation. 解决: Shutdown abort and warmstart the database. ORA-00349: failure obtaining block size for \

原因: The operating system was unable to determine the blocksize for the given filename.

解决: Consult the accompanying error message, and correct the device or specify another filename.

ORA-00350: log string of instance string (thread string) needs to be archived

原因: The command cannot be done because the log has not been archived, and media recovery has been enabled.

解决: Archive the log or disable media recovery. If the command supports an UNARCHIVED option then it can be used. However this may result in making backups unuseable, and forcing the drop of some offline files.

ORA-00351: recover-to time invalid

原因: The time specified in a recover-until statement must be after January 1st 1988. 解决: Specify a time after January 1st 1988.

ORA-00352: all logs for thread string need to be archived - cannot enable 原因: Attempting to enable a thread with all logs needing to be archived, and media recovery has been enabled. There is no log that can be made the new current log for the thread. 解决: Archive a log for the thread or disable media recovery.

ORA-00353: log corruption near block string change string time string

原因: Some type of redo log corruption has been discovered. This error describes the location of the corruption. Accompanying errors describe the type of corruption.

解决: Do recovery with a good version of the log or do incomplete recovery up to the indicated change or time.

ORA-00354: corrupt redo log block header 原因: The block header on the redo block indicated by the accompanying error, is not reasonable. 解决: 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.

ORA-00355: change numbers out of order

原因: A change number found in the redo log is lower than a previously encountered change number. The log is corrupted in some way. The corruption may be at the earlier change or at this one.

第24页

解决: Do recovery with a good version of the log or do time based recovery up to the indicated time.

ORA-00356: inconsistent lengths in change description

原因: A change record in the redo log contains lengths that do not add up to a consistent value. The log is corrupted in some way.

解决: Do recovery with a good version of the log or do time based recovery up to the indicated time.

ORA-00357: too many members specified for log file, the maximum is string

原因: An add logfile or add logfile member command would result in a log with too many members. The number of members is set when the database is created. 解决: Use fewer log file members.

ORA-00358: Too many file members specified, the maximum is string

原因: A create or alter statement specified too many members in a parenthesised file list. 解决: Specify a number of file members that is within the port-defined limit. ORA-00359: logfile group string does not exist

原因: An add logfile member or drop logfile request specified a logfile group number that does not exist.

解决: Check the configuration of the log files and reissue the command. ORA-00360: not a logfile member: string

原因: A filename was given to drop logfile member that is not a part of the database, or which is a data file.

解决: Supply a valid logfile member name.

ORA-00361: cannot remove last log member string for group string

原因: An attempt has been made to remove the last member of a log file group. 解决: If desired, delete the entire log, by using DROP LOGFILE. ORA-00362: member is required to form a valid logfile in group string

原因: A request to drop a logfile member was denied because it would remove data required to form a complete logfile.

解决: If desired, delete the entire log (after archiving if required), by using DROP LOGFILE; ORA-00363: log is not the archived version

原因: d by failing to list the current log of an enabled thread in a CREATE CONTROLFILE command.

解决: Find the archived version of the log and supply its name. If this is media recovery immediately following a CREATE CONTROLFILE, be sure the current log for this thread was included.

ORA-00364: cannot write header to new log member

原因: An i/o error occurred when attempting to write the header to a log member that is being added to an existing group.

解决: See accompanying errors. Fix problem or use another file. ORA-00365: the specified log is not the correct next log

原因: The specified log failed to pass checks to ensure it corresponds to the log that was just applied. This is probably the result of using a log that was generated against a cold backup image of the database.

解决: Find the log that was generated by this copy of the database and give that filename to

第25页


Oracle错误代码超级大全(5).doc 将本文的Word文档下载到电脑 下载失败或者文档不完整,请联系客服人员解决!

下一篇:溶洞地区桩基施工

相关阅读
本类排行
× 注册会员免费下载(下载后可以自由复制和排版)

马上注册会员

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信: QQ: