Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-19577

File file_name is missing.
  • file_name: The file to create during the COPYDATAFILECOPY, RESTOREDATAFILETO or PROXYRESTOREDATAFILE operation.

Cause

A COPYDATAFILECOPY, RESTOREDATAFILETO or PROXYRESTOREDATAFILE function specified a file number but did not specify an output file name, indicating that the output file name should be taken from the control file. However, the control file entry for this file indicates that it was created for a file that was present in the data dictionary but not named during the last CREATE CONTROLFILE statement, so the name in the control file cannot be used for restoration.


Action

Either specify an output file name or issue a SQL RENAME statement to enter a valid name for this file in the control file.