Oracle删除数据库/数据库软件

1. 删除数据库

SQL> select name,open_mode,database_role from v$database; #查看需要删除的数据库信息

NAME      OPEN_MODE            DATABASE_ROLE
--------- -------------------- ----------------
ORCL      READ WRITE           PRIMARY

SQL> shutdown immediate #关闭数据库
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup nomount; #启动到nomount状态
ORACLE instance started.

Total System Global Area  751595520 bytes
Fixed Size                  2257032 bytes
Variable Size             490737528 bytes
Database Buffers          255852544 bytes
Redo Buffers                2748416 bytes
SQL> alter database mount exclusive; #以独占模式Mount数据库

Database altered.

SQL> alter system enable restricted session; #默认只有sysdba和sysoper具有restricted的权限

System altered.

SQL> drop database; #删除数据库

Database dropped.

drop database只删除了数据库文件(数据文件、日志文件和控制文件)，$ORACLE_BASE/admin/orcl下的文件没有被删除，密码文件和参数文件也没有被删除。

2. 删除数据库软件(重新安装)

[oracle@centos6 ~]$ cd $ORACLE_HOME
[oracle@centos6 db_1]$ rm -rf * #删除ORACLE_HOME下的所有文件
[oracle@centos6 ContentsXML]$ pwd
/u01/app/oraInventory/ContentsXML
[oracle@centos6 ContentsXML]$ cat inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2013, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>11.2.0.4.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST> #删除之前的home_list信息
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>