简单介绍RAC环境删除节点的操作。
首先检查一下当前数据库的配置情况:
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 23 16:40:57 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> set pages 100 lines 120
SQL> select name from v$database;
NAME
---------
TESTRAC
SQL> select instance_number, instance_name, host_name, version, status
2 from gv$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STATUS
--------------- ---------------- ------------ ---------------- ------------
3 testrac3 racnode3 11.2.0.1.0 OPEN
2 testrac2 racnode2 11.2.0.1.0 OPEN
1 testrac1 racnode1 11.2.0.1.0 OPEN
这是一个3节点RAC数据库,这里删除节点3。
删除节点的顺序和安装相反,因此第一个步骤是通过DBCA来删除实例:
启动DBCA后,首先选择RAC数据库;
选择实例管理;
选择删除实例;
Oracle列出RAC数据库信息,输入拥有SYSDBA权限的用户和密码;
Oracle列出所有实例,这里选择实例3进行删除;
点击完成后,Oracle弹出窗口,要求用户确认删除节点3上的实例3。
操作完成后,登陆数据库再次进行检查:
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Dec 23 18:29:40 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> set pages 100 lines 120
SQL> select name from v$database;
NAME
---------
TESTRAC
SQL> col host_name format a30
SQL> select instance_number, instance_name, host_name, version, status
2 from gv$instance;
INSTANCE_NUMBER INSTANCE_NAME HOST_NAME VERSION STATUS
--------------- ---------------- -------------- ----------------- ------------
2 testrac2 racnode2 11.2.0.1.0 OPEN
1 testrac1 racnode1 11.2.0.1.0 OPEN
检查表空间和日志信息:
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
UNDOTBS2
USERS
YANGTK
7 rows selected.
SQL> select group#, thread#, sequence#, bytes, status
2 from v$log;
GROUP# THREAD# SEQUENCE# BYTES STATUS
---------- ---------- ---------- ---------- ----------------
1 1 11 524288000 INACTIVE
2 1 12 524288000 CURRENT
3 2 5 524288000 CURRENT
4 2 4 524288000 INACTIVE
数据库实例删除完成。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-692553/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/4227/viewspace-692553/