Solutions to Oracle ORA-01103 errors

Because the project needs to change Oracle_sid (tested) to nid, the result is half lost and the database is suspended. Finally, you cannot reinstall the database.

When I started the database today, the error was: ORA-01103 Database Control File and
D: \ oracle \ product \ 10.2.0 \ admin \ testjfdb \ pfile, which is caused by inconsistent db_name in init. ora.

Error reported: ORA-01103 ????? Testjfdb ?????? Orcl
 
Recreate the control file:
Create controlfile set database "testjfdb" RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
# MAXLOGHISTORY 292
LOGFILE
GROUP 1 'd: \ oracle \ product \ 10.2.0 \ oradata \ testjfdb \ REDO01.LOG 'size 50 M,
GROUP 2 'd: \ oracle \ product \ 10.2.0 \ oradata \ testjfdb \ REDO02.LOG 'size 50 M,
GROUP 3 'd: \ oracle \ product \ 10.2.0 \ oradata \ testjfdb \ REDO03.LOG 'size 50 M
DATAFILE
'D: \ oracle \ product \ 10.2.0 \ oradata \ testjfdb \ SYSTEM01.DBF ',
'D: \ oracle \ product \ 10.2.0 \ oradata \ testjfdb \ UNDOTBS01.DBF ',
'D: \ oracle \ product \ 10.2.0 \ oradata \ testjfdb \ SYSAUX01.DBF ',
'D: \ oracle \ product \ 10.2.0 \ oradata \ testjfdb \ USERS01.DBF'
Character set ZHS16GBK
;
 
This error is reported when startup is used.
ORA-01589: to open the database, you must use the RESETLOGS or NORESETLOGS Option

The resetlogs option must be used when the alter database open resetlogs is started.
 

Connect uf_cust/uf_cust
Succeeded.