DBCA命令删除数据库
dbca -silent -deleteDatabase -sourceDB wzsydb -sysDBAUserName sys -sysDBAPassword XXXXX
删除单实例数据库
shutdown abort;
startup mount restrict;
drop database;
find file and delete (optional)
删除RAC数据库
1--删除数据库实例资源
srvctl stop instance -d oradg -i oradb1
srvctl remove instance -d oradg -i oradb1
srvctl stop instance -d oradg -i oradb2
srvctl remove instance -d oradg -i oradb2
2--删除数据库资源
srvctl stop database -d oradg
srvctl remove database -d oradg
3--确认已经停止所有节点实例
否则会报错如下:
ORA-29707: inconsistent value 1 for initialization parameter cluster_database_instances with other instances
4--在其中一节点操作,先关闭rac模式
startup nomount
alter system set CLUSTER_DATABASE=FALSE scope=spfile;
shutdown immediate
5--在其中一节点操作,删除数据库
startup mount restrict
drop database;
6--如果想删除磁盘组
SQL> alter diskgroup ARCH dismount;(需要在两个节点上都操作)
SQL> drop diskgroup ARCH force including contents;