Oracle Error ORA-19573: cannot obtain string enqueue for datafile string

Oracle Error Message

ORA-19573: cannot obtain string enqueue for datafile string

Reason for the Error

The file access enqueue could not be obtained for a file specified in a backup, copy or restore operation. If the enqueue type shown is ‘shared’, then the file is the input file for a backup or copy. If the type is ‘exclusive’, then the file is the output file for a datafile copy or restore which is attempting to overwrite the currently active version of that file – in this case, the file must be offline or the database must be closed. If the type is ‘read-only’, then you are attempting to back up or copy this file while the database is in NOARCHIVELOG mode.

Solution

Wait until the conflicting operation is complete, then retry the copy or backup. If the database is in NOARCHIVELOG mode, then all files being backed up must be closed cleanly.

Share:

Leave A Reply

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

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...