How to drop oracle database manually

In this article, we are going to learn how to drop oracle database manually step by step. Perform these steps in UAT first don’t perform on the production database server.

How to Create Pluggable Database Oracle

Prerequisites

Before taking any action you must know the location of datafile, controlfile and online redo log files. Using the below query you can get the details.

SQL> select name from v$database;  <<--- check database name 

SQL> select name from v$datafile;
SQL> select name from v$controlfile;
SQL> select member from v$logfile;

Step 1. Make a connection with database as sys user.

$export ORACLE_SID=orcl
$sqlplus / as sysdba

Step 2. Shutdown the database.

SQL> shu immediate

Step 3. Start Database in Exclusive mode till mount stage. Start the process to drop oracle database manually.

SQL> startup mount exclusive restrict;

Step 4. Now Drop the Database.

SQL> drop database;

Now your database has been droped successfully.

Note: After drop the database verify the all associated files should be removed from it’s origenal location. Also remove entry from “/etc/oratab”.

Chat with me on:

subscribe on youtube

3 thoughts on “How to drop oracle database manually”

Leave a Comment

%d bloggers like this:
Enable Notifications    OK No thanks