How to Drop Oracle Database
If you want to drop your database it is wise to take an offline backup before you drop your database. if incase it is required to restore the database back we can use this backup.
Check if database is up and running
$> ps -ef | grep pmon
if this returns a process with the database sid then the DB is running.
login to sqlplus as sysdba
$> sqlplus / as sysdba
shutdown the database to start it in restrict mode
SQL> shut immediate;
put the database in mount restrict mode
SQL> startup restrict mount;
ORACLE instance started.
issues the following command to drop the database.
SQL> drop database;