Oracle Solution for Error ora-01516

ORA-01516: nonexistent log file, datafile, or tempfile "string"

What triggered the Error:

An attempt was made to use ALTER DATABASE to rename a log file, datafile, or tempfile; or to change attributes of a datafile or tempfile (e.g., resize, autoextend, online/offline, etc.); or to re-create a datafile. The attempt failed because the specified file is not known to the database's control file or is not of a type supported by the request.

What should we do to fix it:

Specify the name or number of an existing file of the correct type, as appropriate. Check the relevant V$ table for a list of possible files.