1. 先对数据库作备份
2. 原始字符集是什么? 准备用的字符集又是什么? 它们之间有没有
从属关系,比如原来的是US7ASCII, 你准备改成UTF8或者AL32UTF8,
就没有太大必要去重建库了.
3.下面是针对单实例数据库的操作:
shutdown immediate;
startup mount;
alter system enable restricted session;
alter system set job_queue_processes=0 scope=memory;
alter system set aq_tm_processes=0 scope=memory;
alter database open;
alter system enable restricted session;
alter database character set internal_use internal_convert AL32UTF8;
-- The following operation can be skipped if the national character set is already al16utf16;
-- alter database national character set internal_use internal_convert AL16UTF16;
shutdown immediate;
startup;
col parameter form a30
col value form a30
select parameter,value from nls_database_parameters;
exit;
如果是RAC 数据库, 修改初始化参数
cluster_database=false[/COLOR]
然后分别启动不同的实例, 照着上面的方法做一遍. 最后将
cluster_database再改成true,重新启动整个数据库.
|