ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 11gr2RAC环境删除实例

11gr2RAC环境删除实例

原创 Linux操作系统 作者:shilei1 时间:2011-07-17 08:08:06 0 删除 编辑
11gr2RAC环境删除实例
===========================================================

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

上一篇: ASM工具asmcmd
请登录后发表评论 登录
全部评论

注册时间:2018-10-10

  • 博文量
    548
  • 访问量
    32386