Oracle Database Errors or Warnings from Error ORA-01191 to ORA-01200
ORA-01191: file string is already offline – cannot do a normal offline
Cause: When attempting to do a normal tablespace offline it was discovered that one of the files in the tablespace was already offline.
Action: Either bring the datafile online first, or use another tablespace offline option.
ORA-01192: must have at least one enabled thread
Cause: You must specify at least two logfiles from at least one thread at the create contolfile command line.
Action: Find the missing logfiles and resubmit the command with the newly found logfiles included in the command line.
ORA-01193: file string is not the same file seen at start of recovery
Cause: A different copy of the file was accessed the last time media recovery looked at the file header. A backup of the file was restored or the meaning of the file name changed during recovery.
Action: Ensure the correct file is available, then retry recovery.
ORA-01194: file string needs more recovery to be consistent
Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the file consistent. The reported file was not closed cleanly when it was last opened by the database. It must be recovered to a time when it was not being updated. The most likely cause of this error is forgetting to restore the file from a backup before doing incomplete recovery.
Action: Either apply more logs until the file is consistent or restore the file from an older backup and repeat recovery.
ORA-01195: online backup of file string needs more recovery to be consistent
Cause: An incomplete recovery session was started, but an insufficient number of logs were applied to make the file consistent. The reported file is an online backup which must be recovered to the time the backup ended.
Action: Either apply more logs until the file is consistent or restore the database files from an older backup and repeat recovery.
ORA-01196: file string is inconsistent due to a failed media recovery session
Cause: The file was being recovered but the recovery did not terminate normally. This left the file in an inconsistent state. No more recovery was successfully completed on this file.
Action: Either apply more logs until the file is consistent or restore the backup again and repeat recovery.
ORA-01197: thread string only contains one log
Cause: During CREATE CONTROLFILE all threads represented in the logs must be represented by at least two logs. A “last log” and a second log. The named thread does not contain two such logs.
Action: Either find more logs from the named thread. Or use the RESETLOGS option to CREATE CONTROLFILE.
ORA-01198: must specify size for log file if RESETLOGS
Cause: File sizes must be given for all logfiles if doing a CREATE CONTROLFILE with the RESETLOGS option.
Action: Resubmit the command with the appropriate logfile size.
ORA-01199: file string is not in online backup mode
Cause: Attempting to end an online backup for a file that is not in online backup.
Action: Do not enter command since it is not needed.
ORA-01200: actual file size of string is smaller than correct size of string blocks
Cause: The size of the file as returned by the operating system is smaller than the size of the file as indicated in the file header and the control file. Somehow the file has been truncated. Maybe it is the result of a half completed copy.
Action: Restore a good copy of the data file and do recovery as needed.
Above are list of Oracle Database Errors or Warnings from Error ORA-01191 to ORA-01200 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.
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.