Microsoft SQL Server Default Trace and its Benefits

SQLServerF1

Default Trace was introduced starting with SQL Server 2005, and is one of the very useful feature in some situations. It was not very popular or was not much talked feature initially, but as years progressed it came in to light during various situations where DBAs and management were desperate of finding certain information on who could have performed a certain critical operation against the SQL Server Database.

Default Trace is almost similar to server side trace, but this comes by default meaning this is enabled by default with the installation of the SQL Server instance and since then will start collecting some important pieces of information. As per BOL “Default trace provides troubleshooting assistance to database administrators by ensuring that they have the log data necessary to diagnose problems the first time they occur.

The default Trace becomes very helpful in various cases while troubleshooting because it collects various events which are worth looking into when there is some unexpected event that occurs like a particular object was dropped, which should have not been or in cases were auto-growth or shrink operation caused some performance problems during business hours and we need to find who performed that task. It would be interesting and important to know what all events are captured by the default trace and we can find this information easily by browsing to the log folder where all SQL errorlogs are present and in same location the default trace files are also located. Open one of the default trace file and go to its properties and we can find all the events captured by the default trace.

If you are looking for options to add additional events to be captured by the default trace, then it is not possible as it is not supported, so you will need to setup a different server side trace or look for other alternatives. If you have implemented other alternatives and the default trace is not required any more, it can be disabled too using sp_configure. Default trace is very light waited, so you can just leave it running as you never know when it may become important and only source where you can get the information you are looking for.

Also from SQL Server Management Studio (SSMS) we can see various reports like schema change history, and few other information. We can open the default trace files using the SQL Server Profiler utility or we can read the contents of the default trace using T-SQL queries as well and it will be helpful in querying for a particular event or at a particular date and time. SQL Server maintains 5 default trace files in the log folder and overwrites once all the 5 files are used. Each file is can be a maximum of 20 MB after which it will create a new trace file and once it reaches 5 trace files, it will start removing the oldest trace file, thus ensuring there are 5 trace files at any given point in time. If the server has lot of activity then it may be possible that the old data which you may be looking for may already been lost.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Oracle Database Errors or Warnings from Error ORA-00391 to ORA-00400

SQLServerF1

ORA-00391: All threads must switch to new log format at the same time
Cause: An attempt to switch the current log of a single thread is not allowed because the compatiblity requirements force a new log format version number. When changing log formats, all threads must switch to the new format at the same time.
Action: Open the database to cause the coordinated log switch. If that is not possible then return to the same software version and compatibility setting last used to open the database.
ORA-00392: log string of thread string is being cleared, operation not allowed
Cause: An operation encountered this online log in the middle of being cleared. The command that began the clearing may have terminated without completing the clearing.
Action: If the clear command is still executing then wait for its completion. If it terminated then reissue the clear command, or drop the log.

ORA-00393: log string of thread string is needed for recovery of offline datafiles
Cause: Log cannot be cleared because the redo in it is needed to recover offline datafiles. It has not been archived so there is no other copy available. If the log is cleared the tablespaces containing the files will have to be dropped.
Action: Archive the log then repeat the clear command. If archiving is not possible, and dropping the tablespaces is acceptible, then add the clause UNRECOVERABLE DATAFILE at the end of the clear command.
ORA-00394: online log reused while attempting to archive it
Cause: It has been detected that an online log that is being archived has been reused
Action: Cannot archive the logfile anymore since it has been overwritten
ORA-00395: online logs for the clone database must be renamed
Cause: A clone database open forces logfile renaming to avoid overwriting the primary logfiles
Action: Rename the logfiles manually or using the log_file_name_convert initialization parameter

ORA-00396: error string required fallback to single-pass recovery
Cause: The indicated error caused two-pass instance or crash recovery to fail. Recovery was retried with an alternate (slower) method to avoid the error.
Action: Correct the cause of the indicated error (also recorded) so that future instance or crash recovery can succeed with the two-pass algorithm. This usually requires making more main memory available to the recovery process.
ORA-00397: instance recovery process terminated with error
Cause: The foreground process doing instance recovery died.
Action: Check the foreground trace file for the cause of recovery failure.
ORA-00398: abort thread recovery due to reconfiguration
Cause: Global enqueue service reconfiguration occurred during instance/crash recovery.
Action: This is used internally, no action is required.
ORA-00399: corrupt change description in redo log
Cause: A change vector in the redo log failed validation checks.
Action: Do recovery with a good version of the log or do time based recovery up to the indicated time.
ORA-00400: invalid release value string for parameter string
Cause: The release level given for the specified init parameter is invalid.
Action: Correct the parameter value in the parameter file and retry.

Above are list of Oracle Database Errors or Warnings from Error ORA-00391 to ORA-00400 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00381 to ORA-00390

SQLServerF1

ORA-00381: cannot use both new and old parameters for buffer cache size specification
Cause: User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32), db_cache_advice } AND one or more of { db_block_buffers, buffer_pool_keep , buffer_pool_recycle }. This is illegal.
Action: Use EITHER the old (pre-Oracle_8.2) parameters OR the new ones. Don’t specify both. If old size parameters are specified in the parameter file, you may want to replace them with new parameters since the new parameters can be modified dynamically and allow you to configure additional caches for additional block sizes. Cache advisory can only be enabled with the new cache parameters.
ORA-00382: string not a valid block size, valid range [string..string]
Cause: User specified a value for db_nk_cache_size where n is one of {2, 4, 8, 16, 32}, but nk is not a valid block size for this platform.
Action: Remove corresponding parameter from the “init.ora” file and restart the instance.

ORA-00383: DEFAULT cache for blocksize string cannot be reduced to zero
Cause: User attempted to reduce db_cache_size to zero, or attempted to to reduce db_<n>K_cache_size to zero while there were still online tablespaces with blocksize <n>K. Note that since the SYSTEM tablespace cannot be taken offline, it is always illegal to set db_cache_size to zero.
Action: Offline any tablespaces with the corresponding blocksize and then perform the operation again.
ORA-00384: Insufficient memory to grow cache
Cause: The system could not allocate sufficient memory to grow the cache to the specified size.
Action: Attempt a smaller increase in the value of the parameter.

ORA-00385: cannot enable Very Large Memory with new buffer cache parameters
Cause: User specified one or more of { db_cache_size , db_recycle_cache_size, db_keep_cache_size, db_nk_cache_size (where n is one of 2,4,8,16,32) } AND use_indirect_data_buffers is set to TRUE. This is illegal.
Action: Very Large Memory can only be enabled with the old (pre-Oracle_8.2) parameters.
ORA-00386: use_indirect_data_buffers not supported
Cause: The system could not allocate sufficient memory to grow the cache to the specified size.
Action: Attempt a smaller increase in the value of the parameter.
ORA-00390: log string of thread string is being cleared, cannot become current log
Cause: An attempt to switch to a new online log for the redo thread failed because no reusable log could be found. This log is being cleared and will be useable when the clearing completes. The command that began the clearing may have terminated without completing the clearing.
Action: If the clear command is still executing then wait for its completion. If it terminated then reissue the clear command, or drop the log.

Above are list of Oracle Database Errors or Warnings from Error ORA-00381 to ORA-00390 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00371 to ORA-00380

SQLServerF1

ORA-00371: not enough shared pool memory, should be atleast string bytes
Cause: Init.ora parameter shared_pool_size is too small
Action: Increase the parameter value
ORA-00372: file string cannot be modified at this time
Cause: attempting to modify the contents of a file that cannot be modified. The file is most likely part of a read only tablespace but may be in the process of going offline, or the database may be in the process of closing.
Action: check the status of the file and its tablespace

ORA-00373: online log version string incompatible with ORACLE version string
Cause: The online log was written by incompatible version of Oracle. Can occur when the log file was created by either a new or older version of Oracle.
Action: Recover the database with the compatible software, shut it down cleanly, then restart with current software.
ORA-00374: parameter db_block_size = string invalid ; must be a multiple of string in the range [string..string]
Cause: invalid value for db_block_size parameter
Action: adjust parameter and restart
ORA-00376: file string cannot be read at this time
Cause: attempting to read from a file that is not readable. Most likely the file is offline.
Action: Check the state of the file. Bring it online

ORA-00377: Frequent backups of file string causing write operation to stall
Cause: Backups are occurring too frequently on this file. Each time a new backup is started for a file, any writes which have been previously issued (but not completed) have to be re-issued. If hot backups are started very, very frequently, it is possible that some writes will be re-issued repeatedly and never complete.
Action: Increase the interval between begin hot-backup commands for this file.
ORA-00378: buffer pools cannot be created as specified
Cause: Either the number of buffers or the number of lru latches is too small to satisfy the specified buffer pool configuration.
Action: Either increase the number of buffers and/or number of lru latches or configure smaller buffer pools.
ORA-00379: no free buffers available in buffer pool string for block size stringK
Cause: All buffers in the specified buffer pool for the specified block size are in use and no free buffers are available.
Action: Increase the number of buffers in the specified pool for the specified block size
ORA-00380: cannot specify db_stringk_cache_size since stringK is the standard block size
Cause: User specified the parameter db_nk_cache_size (where n is one of 2,4,8,16,32), while the standard block size for this database is equal to n Kbytes. This is illegal.
Action: Specify the standard block size cache using db_cache_size (DEFAULT pool) (and db_recycle_cache_size, db_keep_cache_size if additional buffer pools are required). Do NOT use the corresponding db_nk_cache_size parameter for the standard block size.

Above are list of Oracle Database Errors or Warnings from Error ORA-00371 to ORA-00380 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00361 to ORA-00370

SQLServerF1

ORA-00361: cannot remove last log member string for group string
Cause: An attempt has been made to remove the last member of a log file group.
Action: If desired, delete the entire log, by using DROP LOGFILE.
ORA-00362: member is required to form a valid logfile in group string
Cause: A request to drop a logfile member was denied because it would remove data required to form a complete logfile.
Action: If desired, delete the entire log (after archiving if required), by using DROP LOGFILE;

ORA-00363: log is not the archived version
Cause: d 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 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
Cause: An i/o error occurred when attempting to write the header to a log member that is being added to an existing group.
Action: See accompanying errors. Fix problem or use another file.
ORA-00365: the specified log is not the correct next log
Cause: 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.
Action: Find the log that was generated by this copy of the database and give that filename to recovery.

ORA-00366: log string of thread string, checksum error in the file header
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.
ORA-00367: checksum error in log file header
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.
ORA-00368: checksum error in redo log block
Cause: The redo block indicated by the accompanying error, is not vaild. It has a checksum that does not match the block contents.
Action: Restore correct file or reset logs.
ORA-00369: Current log of thread string not useable and other log being cleared
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 LOGFILE command is still active then wait for it to complete. Otherwise reissue the CLEAR command. If there are other online logs for the thread, that are not being cleared, then archive the logs.
ORA-00370: potential deadlock during kcbchange operation
Cause: Error code used internally by software. Should never be reported
Action: Treat as internal error. See error 600.

Above are list of Oracle Database Errors or Warnings from Error ORA-00361 to ORA-00370 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00351 to ORA-00360

SQLServerF1

ORA-00351: recover-to time invalid
Cause: The time specified in a recover-until statement must be after January 1st 1988.
Action: Specify a time after January 1st 1988.
ORA-00352: all logs for thread string need to be archived – cannot enable
Cause: 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.
Action: Archive a log for the thread or disable media recovery.

ORA-00353: log corruption near block string change string time string
Cause: Some type of redo log corruption has been discovered. This error describes the location of the corruption. Accompanying errors describe the type of corruption.
Action: 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
Cause: The block header on the redo block indicated by the accompanying error, is not reasonable.
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.
ORA-00355: change numbers out of order
Cause: 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.
Action: 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
Cause: 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.
Action: 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
Cause: 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.
Action: Use fewer log file members.
ORA-00358: Too many file members specified, the maximum is string
Cause: A create or alter statement specified too many members in a parenthesised file list.
Action: Specify a number of file members that is within the port-defined limit.
ORA-00359: logfile group string does not exist
Cause: An add logfile member or drop logfile request specified a logfile group number that does not exist.
Action: Check the configuration of the log files and reissue the command.
ORA-00360: not a logfile member: string
Cause: A filename was given to drop logfile member that is not a part of the database, or which is a data file.
Action: Supply a valid logfile member name.

Above are list of Oracle Database Errors or Warnings from Error ORA-00351 to ORA-00360 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00341 to ORA-00350

SQLServerF1

ORA-00341: log string of thread string, wrong log # string in header
Cause: The internal information in an online log file does not match the control file.
Action: Restore correct file or reset logs.
ORA-00342: archived log does not have expected resetlogs SCN string
Cause: 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.
Action: Supply the correct log file.
ORA-00344: unable to re-create online log ‘string’
Cause: 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.
Action: Correct the file/device as indicated by accompanying errors.

ORA-00345: redo log write error block string count string
Cause: An IO error has occurred while writing the log
Action: Correct the cause of the error, and then restart the system. If the log is lost, apply media/incomplete recovery.
ORA-00346: log member marked as STALE and closed
Cause: A log file member was no longer complete.
Action: 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’t match string
Cause: On header read the blocksize indicated in the control file did not match the blocksize contained in the log file.
Action: Restore correct file or reset logs.

ORA-00348: single-process redo failure. Must abort instance
Cause: 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.
Action: Shutdown abort and warmstart the database.
ORA-00349: failure obtaining block size for ‘string’
Cause: The operating system was unable to determine the blocksize for the given filename.
Action: 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
Cause: The command cannot be done because the log has not been archived, and media recovery has been enabled.
Action: 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.

Above are list of Oracle Database Errors or Warnings from Error ORA-00341 to ORA-00350 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00331 to ORA-00340

SQLServerF1

ORA-00331: log version string incompatible with ORACLE version string
Cause: The log was written by incompatible version of Oracle.
Action: 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
Cause: 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.
Action: 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
Cause: An IO error occurred while reading the log described in the accompanying error.
Action: Restore accessibility to file, or get another copy of the file.
ORA-00334: archived log: ‘string’
Cause: Reporting filename for details of another error
Action: See associated error messages
ORA-00335: online log string: No log with this number, log does not exist
Cause: Reporting filename for details of another error
Action: See associated error messages

ORA-00336: log file size string blocks is less than minimum string blocks
Cause: The log file size as specified in create database is too small.
Action: Increase the log file size.
ORA-00337: log file ‘string’ does not exist and no size specified
Cause: An attempt to add a log found neither an existing file nor a size for creating the file.
Action: Specify a size for the log file.
ORA-00338: log string of thread string is more recent than control file
Cause: 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.
Action: 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
Cause: 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.
Action: Restore the correct log file.
ORA-00340: IO error processing online log string of thread string
Cause: An IO error occurred on the named online log.
Action: Restore accessibility to file, or restore file from backup.

Above are list of Oracle Database Errors or Warnings from Error ORA-00331 to ORA-00340 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00321 to ORA-00330

SQLServerF1

ORA-00321: log string of thread string, cannot update log file header
Cause: Cannot write to the log file.
Action: Restore the access to the file.
ORA-00322: log string of thread string is not current copy
Cause: Check of log file header at database open found that an online log appears to be an incorrectly restored backup.
Action: Restore correct file or reset logs.

ORA-00323: Current log of thread string not useable and all others need archiving
Cause: 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.
Action: Archive the logs for the thread then retry open.
ORA-00324: log file ‘string’ translated name ‘string’ too long, string characters exceeds string limit
Cause: the translated name for a log file is too long.
Action: Choose a untranslated name that yields a shorter translated name.
ORA-00325: archived log for thread string, wrong thread # string in header
Cause: The archived log is corrupted or for another thread. Can not use the log for applying redo.
Action: Find correct archived log.

ORA-00326: log begins at change string, need earlier change string
Cause: The archived log supplied for recovery was generated after the log that is needed. Can not yet use the log for applying redo.
Action: Find correct archived log.
ORA-00327: log string of thread string, physical size string less than needed string
Cause: A log file has shrunk in size. This is likely to have been caused by operator or operating system error.
Action: 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
Cause: The archived log supplied for recovery was generated before the log that is needed. Can not use the log for applying redo.
Action: Find correct archived log.
ORA-00329: archived log begins at change string, need change string
Cause: The archived log is not the correct log. An earlier log is needed.
Action: Restore the correct log file.
ORA-00330: archived log ends at change string, need change string
Cause: The archived log is not the correct log. A later log is needed.
Action: Restore the correct log file.

Above are list of Oracle Database Errors or Warnings from Error ORA-00321 to ORA-00330 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.

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

 

Oracle Database Errors or Warnings from Error ORA-00311 to ORA-00320

SQLServerF1

 

ORA-00311: cannot read header from archived log
Cause: An I/O error occurred when attempting to read the log file header from the specified archived redo log file.
Action: Other messages will accompany this message. See the associated messages for the appropriate action to take.
ORA-00312: online log string thread string: ‘string’
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.
ORA-00313: open failed for members of log group string of thread string
Cause: The online log cannot be opened. May not be able to find file.
Action: See accompanying errors and make log available.

ORA-00314: log string of thread string, expected sequence# string doesn’t match string
Cause: The online log is corrupted or is an old version.
Action: Find and install correct version of log or reset logs.
ORA-00315: log string of thread string, wrong thread # string in header
Cause: The online log is corrupted or is an old version.
Action: 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
Cause: The online log is corrupted or is an old version.
Action: Find and install correct version of log or reset logs.

ORA-00317: file type string in header is not log file
Cause: This is not an archived log file.
Action: Find the correct file and try again.
ORA-00318: log string of thread string, expected file size string doesn’t match string
Cause: On header read the file size indicated in the control file did not match the file size contained in the log file.
Action: Restore correct file or reset logs.
ORA-00319: log string of thread string has incorrect log reset status
Cause: 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.
Action: Restore correct file or reset logs.
ORA-00320: cannot read file header from log string of thread string
Cause: The file is not available.
Action: Restore the log file.

Above are list of Oracle Database Errors or Warnings from Error ORA-00311 to ORA-00320 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.

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

 
1 2