aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-19577: file string is MISSING

ORA-19577: file string is MISSING
Cause: A COPYDATAFILECOPY, RESTOREDATAFILETO or PROXYRESTOREDATAFILE function specified a file number but no 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 command to enter a valid name for this file in the control file.

请先 登录 后评论

1 个回答

小智
ORA-19577:文件字符串是MISSING,
.原因: COPYDATAFILECOPY,RESTOREDATAFILETO或PROXYRESTOREDATAFILE函数指定文件编号,但没有指定输出文件名,表示输出文件名应从控制文件中获取。但是,此文件的控制文件条目表示它是为存在于数据字典中但在上一个CREATE CONTROLFILE语句中未命名的文件创建的,因此控制文件中的名称不能用于还原。,
.操作:指定输出文件名或发出SQL RENAME命令以在控制文件中为此文件输入有效的名称。,
.
请先 登录 后评论