From Oracle 10g it’s possible to drop database
1) shutdown abort;
2) startup mount exclusive restrict;
3) drop database;
this command will remove datafiles, control files, redo logs and spfile.
drop database Deleted file /app/oracle/oradata/DB11R2LS/system01.dbf Deleted file /app/oracle/oradata/DB11R2LS/sysaux01.dbf Deleted file /app/oracle/oradata/DB11R2LS/undotbs01.dbf Deleted file /app/oracle/oradata/DB11R2LS/users01.dbf Deleted file /app/oracle/oradata/DB11R2LS/guang_tbs_01.dbf Deleted file /app/oracle/oradata/DB11R2LS/guang_tbs_02.dbf Deleted file /app/oracle/oradata/DB11R2LS/users02.dbf Deleted file /app/oracle/oradata/DB11R2LS/users03.dbf Deleted Oracle managed file /app/oracle/oradata/DB11R2LS/datafile/o1_mf_logstdby_6ox53yz7_.dbf Deleted file /app/oracle/product/11.2.0/db/dbs/broken0 Deleted file /app/oracle/flash_recovery_area/DB11R2LS/onlinelog/redo01_b.log Deleted file /app/oracle/product/11.2.0/db/dbs/broken1 Deleted file /app/oracle/flash_recovery_area/DB11R2LS/onlinelog/redo02_b.log Deleted file /app/oracle/product/11.2.0/db/dbs/broken2 Deleted file /app/oracle/flash_recovery_area/DB11R2LS/onlinelog/redo03_b.log Deleted Oracle managed file /app/oracle/oradata/DB11R2LS/onlinelog/o1_mf_4_6oozwspg_.log Deleted Oracle managed file /app/oracle/flash_recovery_area/DB11R2LS/onlinelog/o1_mf_4_6oozwvlk_.log Deleted Oracle managed file /app/oracle/oradata/DB11R2LS/onlinelog/o1_mf_5_6oozx3nn_.log Deleted Oracle managed file /app/oracle/flash_recovery_area/DB11R2LS/onlinelog/o1_mf_5_6oozx3xp_.log Deleted Oracle managed file /app/oracle/oradata/DB11R2LS/onlinelog/o1_mf_6_6oozxbqz_.log Deleted Oracle managed file /app/oracle/flash_recovery_area/DB11R2LS/onlinelog/o1_mf_6_6oozxbwy_.log Deleted Oracle managed file /app/oracle/oradata/DB11R2LS/onlinelog/o1_mf_7_6oozxlrm_.log Deleted Oracle managed file /app/oracle/flash_recovery_area/DB11R2LS/onlinelog/o1_mf_7_6oozxn1x_.log Deleted file /app/oracle/oradata/DB11R2LS/temp01.dbf Deleted file /app/oracle/product/11.2.0/db/dbs/snapcf_DB11R2LS.f
4) exit;