Manual Delete/Drop Database in 11gr2 via command line

There is two option to delete/drop database in oracle via DBCA or COMMAND line.

How to drop database via command line

Step:

1.  connect with sysdba user 

SQL> startup mount

ORACLE instance started.

Total System Global Area  150667264 bytes

Fixed Size                  1382112 bytes

Variable Size              92277024 bytes

Database Buffers           50331648 bytes

Redo Buffers                6676480 bytes

Database mounted.

SQL> alter system enable restricted session;

System altered.

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Pr

oduction

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Important Point:

1. Database must be closed

2. database must be in restricted mode

3. drop database command will delete ORADATA FILES (control/redo/datafile and SPFILE)

4. archivelog and rman backup can be deleted via rman command

5. drop database will not delete any files on raw disk. we need to delete manually

6. registry entry need to delete manually

write me email in case of any queries at askdbataj