10g Convert a Single-Instance to RAC

最新推荐文章于 2024-11-09 21:51:58 发布

cmg7893

最新推荐文章于 2024-11-09 21:51:58 发布

阅读量89

点赞数

文章标签：数据库

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1
Information in this document applies to any platform.

Goal

This document describes the procedures for converting from Oracle ASM 10g single-instance to Oracle Real Application Clusters (RAC).

Solution

To convert a single-instance node using ASM to a RAC node using ASM:
#卸载 CSS ，停止原库，监听
1) Shut down the database instance, the ASM instance, and the listener.

Remove the CSS auto-start line from the /etc/inittab file to enable you to shut down and uninstall CSS.

该进程使ASM可以与数据库实例通信

#ps -ef|grep ocssd.bin
#配置RAC安装环境
2) Follow the instructions in Chapter 2 and Chapter 3 (Oracle® Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide ) to configure each node that you want to have as a cluster member.

http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-ORA

#如果之前安装过RAC 需要删除ocr.loc文件
3) If any cluster member node has had previous versions of Oracle clusterware (Cluster Ready Services or Oracle Clusterware) installed, then ensure that you remove the file ocr.loc on any node that has been labeled previously as a cluster node. The file ocr.loc is in /etc/oracle.

#卸载ASM
4) Log in as the oracle user, and run DBCA in silent mode to deconfigure ASM. To run DBCA in silent mode, navigate to the directory $ORACLE_HOME/bin and use the following command syntax on the local node:

dbca -silent -deleteASM

You can de-install the single-instance ASM without losing data.

该命令删除dbca所在目录数据库的ASM，可以用dbca配置

ASM到其他实例（数据库数据不会丢失）

#安装RAC
5) Install Oracle Clusterware on all nodes you intend to have as cluster members, following the directions in Chapter 4 (Oracle® Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide ).

http://www.oracle.com/pls/db102/portal.portal_db?selected=3#index-ORA

#安装ASM
6) Install Cluster ASM using DBCA. At the Node Selection page, select all the cluster member nodes for which you intend to use ASM to manage storage. When the ASM Disk Groups page prompts you to select disk groups, select the existing disk groups you used with the single-instance ASM instance that you deleted in step 4.
#需要修改init+ASM1.ora的参数

*.asm_diskgroup='DATA','RECOVERY' --- 这里定义需要加载哪些磁盘组
7) Start up the one node instance Oracle Database.

1：拷贝原来的pfile到新安装目录

增加RAC参数

==================

*.cluster_database = TRUE
*.cluster_database_instances = 2
*.undo_management=AUTO
.undo_tablespace=undotbs (undo tablespace which already exists)
.instance_number=1
.thread=1

==================

2：创建SPFILE文件

create spfile='+DATA/SUN/spfilesun.ora' from pfile

3：指向SPFILE

vi initsun.ora

~spfile='+DATA/SUN/spfilesun.ora'

4:启动数据库

8）更新RAC配置信息

oracle用户在任意一个NODE上执行：

srvctl add database -d sun -o $ORALCE_HOME2 -p '+DATA/SUN/spfilesun.ora'

srvctl add instance -d sun -i sun1 -n rac1

#in case ASM is used, add the rdbms instance / asm dependency, e.g.

srvctl modify instance -d sun -i sun1 -s +ASM1