oracle 单机转集群,把oracle rac 转化为单机数据库

把oracle rac 转化为单机数据库

时间：2017-09-01 来源：

1. Stop database and CRS on both node

$ srvctl stop database -d mydb

# crsctl stop crs

2. Turn Off RAC

SQL startup

ORA-29702 error occurred in Cluster Group Service operation

Relink with the RAC OFF.

$ cd $ORACLE_HOMErdbmslib

$ usrccsbinmake -f ins_rdbms.mk rac_off

Relinking oracle

$ make -f ins_rdbms.mk ioracle

## OR , both working fine

$ cd $ORACLE_HOMEbin

$ relink oracle

If ASM Instance Exist, run below command as root

# oracleproduct10.2.0dbbinlocalconfig delete

# oracleproduct10.2.0dbbinlocalconfig add

3. Parameter(Pfilespfile) & database changes

SQL startup

SQL alter database disable thread 2;

SQL alter system set remote_listener='';

3a. Remove unwanted logfile

SQL select thread#, group# from v$log;

SQL alter database drop logfile group 3;

SQL alter database drop logfile group 4;

3b. Remove unwanted tablespace

SQL drop tablespace UNDOTBS2 including contents and datafiles;

3c. Rename instance name.

SQL alter system set instance_name=new_name scope=spfile;

SQL shutdown immediate

SQL startup

- Change your ORACLE_SID environment

4. Run $ORA_CRS_HOMEinstallrootdelete.sh on both node

- This will stop and remove all CRS startup related file

5. Remove $ORA_CRS_HOME binary using Clusterware OUI installer

- Ignore any error if 2nd node already down

- rm -rf $ORA_CRS_HOME

6. Modify listener file

$ vi $ORACLE_HOMEnetworkadminlistener.ora

6a. Modify tnsname file

$ vi $ORACLE_HOMEnetworkadmintnsnames.ora

应该还要把初始化参数中的cluster_database改成false

(文章来自网络，如有侵权请来信告知，本站将在第一时间删除。)