Database Error Messages

ORA-19890

data file already in use

Cause

The file access enqueue could not be obtained for a file specified in restore operation. The file was an output file for a restore operation, which was attempting to overwrite the currently active version of that file. In this case, the file must be offline or the database must be closed.


Action

One of the following actions can be taken:

  • Remove the file in place and retry the operation.
  • Take the data file offline and retry the operation.
  • Open the database in mount mode and retry the operation.