ORA-01167: two files are the same file | ORA-01503: CREATE CONTROLFILE failed

I got ” ORA-01167: two files are the same file | ORA-01503: CREATE CONTROLFILE failed ” error in Oracle database during controlfile creation.

 

ORA-01167: two files are the same file | ORA-01503: CREATE CONTROLFILE failed

 

Details of error are as follows.

CREATE CONTROLFILE REUSE SET DATABASE MSDB RESETLOGS ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01167: two files are the same file/group number or the same file
ORA-01110: data file 89:
'/zfssa/MSDB/MSDB_full01_c04/data_D-MSDB_I-2054866743_TS_TBS_FNO-89_v8uuij3e'
ORA-01110: data file 89:
'/zfssa/MSDB/MSDB_full01_c03/data_D-MSDB_I-2054866743_TS-SYSAUX_FNO-89_3ovh
dg35'

 

The ORA-01167 error is related with the duplicate datafiles or datafilecopy in the controlfile.

To solve this error, remove the duplicate datafiles in the controlfile or datafilecopy entry in the controlfile.

 

 

 

Do you want to learn Oracle Database for Beginners, then Click and read the following articles.

Oracle Database Tutorials for Beginners ( Junior Oracle DBA )