Thinking Out Loud

September 19, 2007

drop database

Filed under: oracle — mdinh @ 9:40 pm

Note: I had to modify the screen shot to remove domain name of the company.

The drop database command can be useful in a testing environment for cleaning up data files, controlfiles, and log files.

d1.jpg

Note: database must be mounted EXCLUSIVE and not open for this operation.

d2.jpg

One disappointment is that it did not delete the directory beneath DIAGNOSTIC_DEST.

Here are all the directories still left behind.

d3.jpg

This is what I executed to remove the remaining directories in my environment.

find /ora* -user oracle -type d -name PRIME -exec rm -rfv {} \;

ALWAYS be careful when using rm -rf command.

Advertisements

1 Comment »

  1. […] Dinh shows how to drop database (don’t try this on […]

    Pingback by Links of the Week - #4 « I’m just a simple DBA on a complex production system — February 1, 2008 @ 6:59 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: