Ora-01167 two files are the same

Do you have a recent control file backup e. Is there a problem with the E: disk - have you verified the media itself? Also in this backup, the controlfile exist. Can I use this controlfile in the place of the corrupted?

Did you already solve your problem? Add a comment. Active Oldest Votes. You can check to ensure the contents are the same using the DOS command comp Generally, you will see that the file listed in the error message has different contents from the other 2; you can then just copy one of the other control files over the "bad" control file, and try restarting.

Improve this answer. Mark Stewart Mark Stewart 1, 1 1 gold badge 10 10 silver badges 28 28 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.

Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related 1. Como asegurar el archivo htaccess en Wordpress. Joomla 4. Update Windows Vista KB Windows 10 Pro 64 bits. Windows 10 Pro 32 bits. Manual PostgreSQL Manuales smartphone Huawei P Smart What is the cause of ORA from Oracle 11g? 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. If this happens, check for additional error messages. 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 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.

Author : Kevin Loney. Author : Jason Price.