Back up the database whose control file character set is being changed. The backup should preferably be a cold backup Log onto RMAN and backup the existing control file to trace by using the command, ALTER DATABASE BACKUP CONTROLFILE TO TRACE
Edit the syntax extracted from the trace file for changes within the character set
Shut down the database
Start up the instance, but do not mount or open the database
Start up the instance, but do not mount or open the database
Start up the instance, but do not mount or open the database
Start up the instance, but do not mount or open the database Start up the instance, but do not mount or open the database
Start up the instance, but do not mount or open the database
Create a new control file for the database by using the CREATE CONTROLFILE statement.
Store a backup of the new control file on an offline storage device