We can use the following sql for Datafile Controlfile and Logfile control, we can check it again at the end of the drop process.
SQL> select name from v$datafile;
SQL> select name from v$controlfile;
SQL> select * from v$logfile;
Let’s connect and close the database
SQL> shu immediate;
Let’s open the database in Exclusive Mode Mount mode
SQL> startup mount exclusive restrict;
We can drop.
SQL> drop database;