11gr2RAC环境删除实例

11gr2RAC环境删除实例

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

作者: yangtingkun(http://yangtingkun.itpub.net)
发表于: 2011.04.14 23:59
分类: ORACLE
出处: http://yangtingkun.itpub.net/post/468/516552
---------------------------------------------------------------

简单介绍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/196700/viewspace-702399/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/196700/viewspace-702399/