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



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

Answer / guest

Cause: 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.

Action: 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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-16080: invalid LogMiner session string for APPLY

1 Answers  


ORA-39105: Master process string failed during startup. Master error:

1 Answers  


RMAN-05505: auxiliary filename conversion of 'string' exceeds maximum length of string

1 Answers  


ORA-30448: internal data of the advisor repository is inconsistent

1 Answers  


KUP-03004: absolute end (number) specified with relative start (number) for field string

1 Answers  






ORA-37023: (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.

1 Answers  


ORA-09838: removeCallback: failure removing the callback port.

1 Answers  


ORA-01270: %s operation is not allowed if STANDBY_PRESERVES_NAMES is true

1 Answers  


TNS-00242: Connection Manager: Tracing is now ON

1 Answers  


TNS-12201: TNS:encountered too small a connection buffer

1 Answers  


NNL-01006: META VIOLATION responses received: number

1 Answers  


LPX-00118: undefined entity "~S"

1 Answers  


Categories