linux下： oracle 11g 更改实例名

 库实例rmsm改为hkhxqz；

1 备份源实例文件

SQL> create pfile='/home/oracle/p.ora' from spfile;

File created.

                   

SQL> alter database backup controlfile to trace as '/home/oracle/rmsm.ctl';

Database altered.

shutdown immieadte;

2 生成新spfile

vi /home/oracle/p.ora ---> /%s/rmsm/hkhxqz/g  #更改路径

rmsm.__data_transfer_cache_size=0

rmsm.__db_cache_size=1241513984

rmsm.__inmemory_ext_roarea=0

rmsm.__inmemory_ext_rwarea=0

rmsm.__java_pool_size=16777216

rmsm.__large_pool_size=16777216

rmsm.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

rmsm.__pga_aggregate_target=620756992

rmsm.__sga_target=1828716544

rmsm.__shared_io_pool_size=100663296

rmsm.__shared_pool_size=402653184

rmsm.__streams_pool_size=33554432

*.audit_file_dest='/opt/oracle/oracle_112040/admin/rmsm/adump'

*.control_files='/opt/oracle/oracle_112040/oradata/control01.ctl'

*.db_name='rmsm'

*.db_securefile='PREFERRED'

*.open_cursors=500

*.pga_aggregate_target=579m

*.processes=200

*.sga_target=1736m

:%s/rmsm/hkhxqz/g

[oracle@T0RMSMDB1333 ~]$ mkdir -p /opt/oracle/oracle_112040/admin/hkhxqz/adump

[oracle@T0RMSMDB1333 ~]$ mkdir -p /opt/oracle/oracle_112040/oradata/hkhxqz/

2 移动源实例文件

/opt/oracle/oracle_112040/oradata

[oracle@T0RMSMDB1333 oradata]$ cd rmsm  

[oracle@T0RMSMDB1333 rmsm]$ ls

control01.ctl  control02.ctl  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf

[oracle@T0RMSMDB1333 rmsm]$ cp * ../hkhxqz/

[oracle@T0RMSMDB1333 rmsm]$ cd ../hkhxqz/

[oracle@T0RMSMDB1333 hkhxqz]$ ls

control01.ctl  control02.ctl  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf

[oracle@T0RMSMDB1333 hkhxqz]$ mkdir bakctl

[oracle@T0RMSMDB1333 hkhxqz]$ mv *.ctl bakctl/

[oracle@T0RMSMDB1333 hkhxqz]$ ls

bakctl  redo01.log  redo02.log  redo03.log  sysaux01.dbf  system01.dbf  temp01.dbf  undotbs01.dbf  users01.dbf

[oracle@T0RMSMDB1333 hkhxqz]$ pwd

/opt/oracle/oracle_112040/oradata/hkhxqz

vi /tmp/p.ora

3 升成新ctl文件及开库

>startup nomount pfile='/home/oracle/p.ora';

cp /home/oracle/rmsm.ctl /opt/oracle/oracle_112040/oradata/control01.ctl

vi control01.ctl  #---> case 2 :---change hkhxqz && path 更改后的结果见语句，如下：

用之前的备份的控制文件，执行如下语句：开库

CREATE CONTROLFILE SET DATABASE "HKHXQZ" RESETLOGS  NOARCHIVELOG    ---是用set 代替reuse  

   MAXLOGFILES 16

   MAXLOGMEMBERS 3

   MAXDATAFILES 100

   MAXINSTANCES 8

   MAXLOGHISTORY 292

LOGFILE

 GROUP 1 '/opt/oracle/oracle_112040/oradata/hkhxqz/redo01.log'  SIZE 50M BLOCKSIZE 512,

 GROUP 2 '/opt/oracle/oracle_112040/oradata/hkhxqz/redo02.log'  SIZE 50M BLOCKSIZE 512,

 GROUP 3 '/opt/oracle/oracle_112040/oradata/hkhxqz/redo03.log'  SIZE 50M BLOCKSIZE 512

-- STANDBY LOGFILE

DATAFILE

 '/opt/oracle/oracle_112040/oradata/hkhxqz/system01.dbf',

 '/opt/oracle/oracle_112040/oradata/hkhxqz/sysaux01.dbf',

 '/opt/oracle/oracle_112040/oradata/hkhxqz/undotbs01.dbf',

 '/opt/oracle/oracle_112040/oradata/hkhxqz/users01.dbf',

 '/home/oracle/rmsmindex.dbf',

 '/home/oracle/rmsmdata.dbf',

 '/home/oracle/HKRM_DATA_1.dbf',

 '/home/oracle/HKRM_INDEX_1.dbf',

 '/home/oracle/HKRM_DATA.dbf'

CHARACTER SET AL32UTF8

;

alter database open resetlogs;

ALTER TABLESPACE TEMP ADD TEMPFILE '/opt/oracle/oracle_112040/oradata/hkhxqz/temp01.dbf'

    SIZE 30408704  REUSE AUTOEXTEND ON NEXT 655360  MAXSIZE 32767M;

4 开库后，使用spfile文件：

create spfile from pfile='/home/oralce/p.ora';

shutdown immediate;

startup