RelationalDBDesign RelationalDBDesign


Backup Recovery   «Prev 

Changing character sets

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

  1. Start up the instance, but do not mount or open the database
  2. Create a new control file for the database by using the CREATE CONTROLFILE statement.
  3. Store a backup of the new control file on an offline storage device
  4. Edit the parameter files of the database
  5. Recover the database if necessary
  6. Open the database