Oracle Database Errors or Warnings from Error ORA-01141 to ORA-01150

SQLServerF1

 

ORA-01141: error renaming data file string – new file ‘string’ not found
Cause: An attempt to change a data file’s name in the control file failed because no file was found with the new name.
Action: Make sure that the data file has been properly renamed by the operating system and retry.
ORA-01142: cannot end online backup – none of the files are in backup
Cause: None of the files were found to be in online backup when attempting to end an online backup.
Action: None. Online backup does not need to be ended for this tablespace.
ORA-01143: cannot disable media recovery – file string needs media recovery
Cause: An attempt to disable media recovery found a file that needs media recovery, thus media recovery cannot be disabled.
Action: Recover the offending file or drop the tablespace it belongs to and retry this command.

ORA-01144: File size (string blocks) exceeds maximum of string blocks
Cause: Specified file size is larger than maximum allowable size value.
Action: Specify a smaller size.
ORA-01145: offline immediate disallowed unless media recovery enabled
Cause: ALTER TABLESPACE … OFFLINE IMMEDIATE or ALTER DATABASE DATAFILE … OFFLINE is only allowed if database is in ARCHIVELOG mode.
Action: Take tablespace offline normally or shutdown abort. Reconsider your backup strategy. You could do this if you were archiving your logs.
ORA-01146: cannot start online backup – file string is already in backup
Cause: When starting an online backup it was noticed that an online backup was already started for one of the data files.
Action: End the first backup before beginning another.

ORA-01147: SYSTEM tablespace file string is offline
Cause: A file belonging to the SYSTEM tablespace has been marked offline by the DBA. The database cannot be started until all SYSTEM tablespace files are online and openable.
Action: Bring the file online.
ORA-01148: cannot refresh file size for datafile string
Cause: An operating system or device error occurred when retrieving the file’s size. The device on which the file resides may have been offline.
Action: Restore access to the device.
ORA-01149: cannot shutdown – file string has online backup set
Cause: An attempt to shutdown normally found that an online backup is still in progress.
Action: End the backup of the offending tablespace and retry this command.
ORA-01150: cannot prevent writes – file string has online backup set
Cause: An attempt to make a tablespace read only or offline normal found that an online backup is still in progress. It will be necessary to write the file header to end the backup, but that would not be allowed if this command succeeded.
Action: End the backup of the offending tablespace and retry this command.

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

 

Leave a Reply

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