描述11G RAC数据库的SILENT卸载方式。

首先仍然是编辑response文件my_delete_db.rsp：

[GENERAL]
RESPONSEFILE_VERSION = "11.1.0"

OPERATION_TYPE = "deleteDatabase"

[DELETEDATABASE]
SOURCEDB = "rac11g1"

SYSDBAUSERNAME = "sys"

SYSDBAPASSWORD = "test"

删除数据库对应的response.rsp比较简单，只需要提供上面几个参数就可以了。

其中OPERATION_TYPE指定dbca进行的操作类型，这里选择DELETE DATABASE，而SOURCEDB给出本地数据库的SID，下面两个参数分别是SYSDBA用户的用户名和密码，对于采用操作系统验证的情况，这两个参数不是必须的。

$ dbca -silent -deleteDatabase -responseFile /data/database/response/my_delete_db.rsp
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/data/oracle/cfgtoollogs/dbca/rac11g.log" for further details.

不过这种方式删除数据库只会删除当前节点的指定实例，另外一个节点的数据库仍然会处于启动状态。

而且检查删除的日志文件，也可以看到错误信息和RAC数据库有关：

$ more /data/oracle/cfgtoollogs/dbca/rac11g.log
The Database Configuration Assistant will delete the Oracle instance and datafiles for your database. All information in the databas
e will be destroyed. Do you want to proceed?
Connecting to database
DBCA_PROGRESS : 4%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 14%
DBCA_PROGRESS : 19%
DBCA_PROGRESS : 23%
DBCA_PROGRESS : 28%
ORA-01586: ??????????, ???????????? EXCLUSIVE ????????????????

DBCA_PROGRESS : 47%
Updating network configuration files
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 52%
Deleting instance and datafiles
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 100%
Database deletion completed.

可以看到，实例1上数据库已经停止，而实例2的数据库仍然处于启动状态：

$ ps -ef|grep ora
oracle 21490 17112 0 Aug 14 ? 128:38 /data/oracle/product/11.1/database/bin/emagent
root 1903 1 0 Jul 15 ? 28:23 /opt/VRTSobc/pal33/bin/vxpal -a StorageAgent -x
oracle 6970 6969 0 Jul 16 ? 27:43 /data/oracle/product/11.1/crs/bin/oclsomon.bin
oracle 7011 6848 0 Jul 16 ? 186:08 /data/oracle/product/11.1/crs/bin/ocssd.bin
oracle 7082 6773 0 Jul 16 ? 0:47 /data/oracle/product/11.1/crs/bin/evmlogger.bin -o /data/oracle/product/11.1/cr
oracle 6773 6760 0 Jul 16 ? 19:34 /data/oracle/product/11.1/crs/bin/evmd.bin
oracle 7916 1 0 Jul 16 ? 0:00 /data/oracle/product/11.1/crs/opmn/bin/ons -d
oracle 14604 1 0 Sep 19 ? 0:04 ora_q000_rac11g2
oracle 13980 1 0 Sep 19 ? 9:23 ora_lms1_rac11g2
oracle 6969 6968 0 Jul 16 ? 0:00 /bin/sh -c cd /data/oracle/product/11.1/crs/log/newtrade2/cssd/oclsomon; ulimit
root 6953 6804 0 Jul 16 ? 4:52 /data/oracle/product/11.1/crs/bin/oprocd run -t 1000 -m 500
oracle 6760 6509 0 Jul 16 ? 0:00 sh -c sh -c 'ulimit -c unlimited; cd /data/oracle/product/11.1/crs/log/newtrade
oracle 17112 1 0 Jul 16 ? 27:07 /data/oracle/product/11.1/database/perl/bin/perl /data/oracle/product/11.1/data
oracle 24338 1 0 Jul 16 ? 5:26 /data/oracle/product/11.1/database/bin/tnslsnr LISTENER_NEWTRADE2 -inherit
oracle 14012 1 0 Sep 19 ? 0:04 ora_d000_rac11g2
oracle 7918 7916 0 Jul 16 ? 3:22 /data/oracle/product/11.1/crs/opmn/bin/ons -d
oracle 6968 6820 0 Jul 16 ? 0:00 sh -c /bin/sh -c 'cd /data/oracle/product/11.1/crs/log/newtrade2/cssd/oclsomon;
root 6792 6511 0 Jul 16 ? 1006:43 /data/oracle/product/11.1/crs/bin/crsd.bin reboot
oracle 14008 1 0 Sep 19 ? 2:16 ora_mmon_rac11g2
oracle 13966 1 0 Sep 19 ? 0:07 ora_acms_rac11g2
oracle 13986 1 0 Sep 19 ? 0:12 ora_mman_rac11g2
oracle 14426 1 0 Sep 19 ? 0:14 ora_rcbg_rac11g2
oracle 14010 1 0 Sep 19 ? 3:15 ora_mmnl_rac11g2
oracle 14424 1 0 Sep 19 ? 0:07 ora_gtx0_rac11g2
oracle 13823 13822 0 10:09:55 pts/1 0:00 ps -ef
oracle 14249 1 0 Sep 19 ? 0:14 ora_arc0_rac11g2
oracle 14606 1 0 Sep 19 ? 0:06 ora_q001_rac11g2
oracle 13960 1 0 Sep 19 ? 0:07 ora_dbrm_rac11g2
oracle 14076 1 0 Sep 19 ? 0:00 /data/oracle/product/11.1/crs/bin/oclskd.bin
oracle 13962 1 0 Sep 19 ? 0:27 ora_ping_rac11g2
oracle 10105 10103 0 10:04:35 pts/2 0:00 -sh
oracle 14263 1 0 Sep 19 ? 0:05 ora_arc3_rac11g2
oracle 13996 1 0 Sep 19 ? 0:26 ora_dbw0_rac11g2
oracle 13998 1 0 Sep 19 ? 0:26 ora_dbw1_rac11g2
oracle 1931 1 0 Sep 19 ? 108:49 ora_j003_rac11g2
oracle 13822 11549 0 10:09:55 pts/1 0:00 grep ora
oracle 10103 10064 0 10:04:35 ? 0:00 /usr/lib/ssh/sshd
oracle 14150 1 0 Sep 19 ? 3:47 ora_lck0_rac11g2
oracle 11549 18708 0 10:06:41 pts/1 0:00 -sh
oracle 14152 1 0 Sep 19 ? 0:17 ora_rsmn_rac11g2
oracle 14002 1 0 Sep 19 ? 1:57 ora_ckpt_rac11g2
oracle 4550 1 0 Sep 20 ? 4:08 ora_j002_rac11g2
oracle 14257 1 0 Sep 19 ? 0:07 ora_arc1_rac11g2
oracle 14412 1 0 Sep 19 ? 0:17 ora_smco_rac11g2
oracle 14004 1 0 Sep 19 ? 0:45 ora_smon_rac11g2
oracle 13954 1 0 Sep 19 ? 3:12 ora_vktm_rac11g2
oracle 13958 1 0 Sep 19 ? 1:56 ora_diag_rac11g2
oracle 15146 1 0 Sep 19 ? 7:08 ora_cjq0_rac11g2
oracle 14275 1 0 Sep 19 ? 0:33 oraclerac11g2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 9279 1 0 10:03:24 ? 0:00 oraclerac11g2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 13976 1 0 Sep 19 ? 9:19 ora_lms0_rac11g2
oracle 14164 1 0 Sep 19 ? 1:54 /data/oracle/product/11.1/database/bin/racgimon startd rac11g
oracle 14422 1 0 Sep 19 ? 0:08 ora_fbda_rac11g2
oracle 148 1 0 09:50:23 ? 0:00 ora_w000_rac11g2
oracle 14438 1 0 Sep 19 ? 0:12 ora_qmnc_rac11g2
oracle 13964 1 0 Sep 19 ? 0:08 ora_psp0_rac11g2
oracle 14261 1 0 Sep 19 ? 0:30 ora_arc2_rac11g2
oracle 14000 1 0 Sep 19 ? 0:57 ora_lgwr_rac11g2
oracle 13952 1 0 Sep 19 ? 2:33 ora_pmon_rac11g2
oracle 13970 1 0 Sep 19 ? 14:30 ora_dia0_rac11g2
oracle 14006 1 0 Sep 19 ? 0:04 ora_reco_rac11g2
oracle 13974 1 0 Sep 19 ? 5:17 ora_lmd0_rac11g2
oracle 13984 1 0 Sep 19 ? 0:07 ora_rms0_rac11g2
oracle 13972 1 0 Sep 19 ? 18:45 ora_lmon_rac11g2
oracle 10050 1 0 10:04:30 ? 0:00 oraclerac11g2 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 9486 1 0 10:03:42 ? 0:01 ora_q002_rac11g2
oracle 15183 1 0 Sep 19 ? 41:28 ora_j000_rac11g2
oracle 10038 1 0 10:04:28 ? 0:00 ora_q003_rac11g2
oracle 14014 1 0 Sep 19 ? 0:04 ora_s000_rac11g2

可以看到实例2仍然可以顺利连接：

$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on 星期一 9月 22 10:11:19 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
rac11g2

SQL> select instance_name from gv$instance;

INSTANCE_NAME
----------------
rac11g2

这时最简单的方法是在实例2的节点上再次运行dbca，删除数据库：

将上面的my_delete_db.rsp拷贝到本地节点，将其中的参数rac11g1改为当前的SID：rac11g2，然后再次执行删除数据库操作：

$ dbca -silent -deleteDatabase -responseFile /export/home/oracle/my_delete_db.rsp
Connecting to database
4% complete
9% complete
14% complete
19% complete
23% complete
28% complete
47% complete
Updating network configuration files
48% complete
52% complete
Deleting instance and datafiles
76% complete
100% complete
Look at the log file "/data/oracle/cfgtoollogs/dbca/rac11g.log" for further details.
$ more /data/oracle/cfgtoollogs/dbca/rac11g.log
The Database Configuration Assistant will delete the Oracle instance and datafiles for your database. All information in the databas
e will be destroyed. Do you want to proceed?
Connecting to database
DBCA_PROGRESS : 4%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 14%
DBCA_PROGRESS : 19%
DBCA_PROGRESS : 23%
DBCA_PROGRESS : 28%
ORA-01586: ??????????, ???????????? EXCLUSIVE ????????????????

DBCA_PROGRESS : 47%
Updating network configuration files
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 52%
Deleting instance and datafiles
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 100%
Database deletion completed.

数据库删除成功。

另一个方法应该是先删除RAC实例2上的INSTANCE，然后再执行DELETE DATABASE的步骤。