ORA-01516: nonexistent log file, data file, or temporary file "string"

ORA-01516: nonexistent log file, data file, or temporary file "string"
Cause: An attempt was made to use ALTER DATABASE to rename a log file, data file, or temporary file; or to change attributes of a data file or temporary file (for example, resize, autoextend, online or offline); or to re-create or move a data file. 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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01516：不存在的日志文件，数据文件或临时文件“ string ”,
.原因：试图使用ALTER DATABASE重命名日志文件，数据文件或临时文件; 或更改数据文件或临时文件的属性（例如，调整大小，自动扩展，联机或脱机）; 或重新创建或移动数据文件。尝试失败，因为指定的文件对于数据库的控制文件不为已知，或者不是请求所支持的类型。,
.操作：根据需要指定正确类型的现有文件的名称或编号。检查相关的V $表以查找可能的文件列表。,
.

aiaiDBA

13718043309

010-86462881

ORA-01516: nonexistent log file, data file, or temporary file "string"

1 个回答

相似问题