Archive for ‘database’

February 22, 2011

Dropping database

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;