ORA-01167: two files are the same file/group number or the same file

ORA-01167: two files are the same file/group number or the same file
Cause: There is an overlap of file numbers in the files specified on the command line or the same file is specified twice. If they are not the exact same file then one is likely to be a backup of the other. If they are two members of the same log they must be specified together in a group file spec. This message will also appear if the same control file appears more than once in the control_files parameter in the init.ora file. If this happens, check for additional error messages.
Action: Confirm that the file mentioned is not a repeat of a file already mentioned in the command. If they are different files then omit the earlier backup. If they are members of the same log, insure they are in the same group file specification. If this message appears because of a duplicate control file, check the control_files parameter in the init.ora file and see if a file is specified more than once. If all files names appear to be unique, check to make sure that the actual control files themselves are unique. For example, in UNIX check for a symbolic or a hard link to another control file in the list.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:36

ORA-01167：两个文件是相同的文件/组号或同一个文件,
.原因：在命令行中指定的文件中存在文件编号重叠或指定了两次相同的文件。如果它们不是完全相同的文件，那么一个可能是另一个的备份。如果它们是同一日志的两个成员，则必须在组文件规范中一起指定它们。如果相同的控制文件在init.ora文件的control_files参数中多次出现，则也会显示此消息。如果发生这种情况，请检查其他错误消息。,
.操作：确认所提及的文件不是命令中已提及的文件的重复。如果它们是不同的文件，则忽略较早的备份。如果它们是同一日志的成员，请确保它们在同一组文件规范中。如果由于重复的控制文件而出现此消息，请检查init.ora文件中的control_files参数，并查看是否多次指定了文件。如果所有文件名称看起来是唯一的，请检查以确保实际的控制文件本身是唯一的。例如，在UNIX中检查符号或硬链接到列表中的另一个控制文件。,
.

aiaiDBA

13718043309

010-86462881

ORA-01167: two files are the same file/group number or the same file

1 个回答

相似问题