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 )