ORA-01161: db name A in file header does not match given name of B

Symptom

During the control file creation, you are facing below error,

Errors in file /oracle/XYZ/saptrace/diag/rdbms/xyz/XYZ/trace/XYZ_ora_6009.trc:
ORA-01161: database name ABC in file header does not match given name of XYZ
ORA-01110: data file 19: '/oracle/XYZ/sapdata10/sr3_20/sr3.data20'
ORA-1503 signalled during: 
CREATE CONTROLFILE SET DATABASE "XYZ" RESETLOGS ARCHIVELOG

Solution

Below solution did solved my colleague issue. Maybe, you can try to refer to below link
http://dbakevin.blogspot.de/2011/02/simulate-one-ora-01161-solving-for-ora.html

You May Also Like

Leave a Reply?