ORA-01167: two files are the same file/group number or the same file ORACLE 报错 故障修复 远程处理

文档解释

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.

。

ORA-01167错误表明，您试图创建或更改的数据文件组号与现有数据文件中的组号相同，或者新创建的文件的组号与另一个新文件的组号相同。

官方解释

常见案例

正常处理方法及步骤

1.检查文件组号。检查该数据文件组号是否存在，以确保没有重复的组号。

2.更新文件组号。如果组号重复，请使用ALTER DATABASE RENAME FILE命令将文件重命名，并更新其文件组号以避免重复。

3.比较对象。如果发现错误的对象，可以使用DBMS_UTILITY包的COMPARE_BASE_OBJECT函数来比较现有对象，看看是否有重复的文件存在。