High level steps of database drop in oracle

Shutdown the database instance

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

Startup database in exclusive restrict to block incoming client connections to the database

SQL> startup mount exclusive restrict;
ORACLE instance started.

Total System Global Area 1169149952 bytes
Fixed Size                  2252624 bytes
Variable Size             385876144 bytes
Database Buffers          771751936 bytes
Redo Buffers                9269248 bytes
Database mounted.

Drop the database

SQL> drop database;

Database dropped.

Then you can use dbca to delete the SID and other entries from the server

Then perform the housekeeping of old archivelogs ,audit files and trace files related to the database

Leave a Reply