Oracle Solution for Error ora-01223

Solution for Oracle Error ORA-01223

ORA-01223: RESETLOGS must be specified to set a new database name

What triggered the Error:

The SET database name option was specified to CREATE CONTROLFILE, but RESETLOGS was not specified. The database name can only be changed when opening the database with RESETLOGS.

What should we do to fix it:

Either add the RESETLOGS option or drop the SET option to CREATE CONTROLFILE.