Drop Oracle single instance Database Manually

Hostname : lovetech
OS : Red Hat Enterprise Linux Server release 7.9 (Maipo)
DB Name : DBADEV
Version : 11.2.0.1
Filesystem : Normal
Database type : Single Instance
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1

Set env to DBADEV database

[oracle@lovetech ~]$ . oraenv
ORACLE_SID = [dbadev] ? dbadev
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@lovetech ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Sep 6 00:37:21 2021

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

check the status of the database

SQL> select name,open_mode from v$database;

NAME OPEN_MODE


DBADEV READ WRITE

Shutdown the database

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

Startup and mount the database in restricted mode

SQL> startup mount restrict;
ORACLE instance started.

Total System Global Area 367439872 bytes
Fixed Size 2213456 bytes
Variable Size 276826544 bytes
Database Buffers 83886080 bytes
Redo Buffers 4513792 bytes
Database mounted.

Issue the drop command

SQL> drop database;

Database dropped.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit

Remove entries in the oratab file as the drop command will not perform this action

Note: The use of any materials on this website is at your own risk. It is provided for educational purposes only. It has been tested internally, but we do not guarantee that it will work for you. We recommend you test in your test environment before using.

Leave a Comment

Logged in as lovetyLog out?