We are planing to drop a database and want to make sure you drop all the data files, online logs, and control files pertaining to the database. Of course, you can drop a database from SQL*Plus using the drop database 12c command.
use the drop database command to drop a database from the Rman prompt. Here are the steps to follow:
1) Startup the database in mount exclusive mode:
Sql> startup mount exclusive;
2) From the Rman interface, use the following command to drop the database;
Rman> connect target /;
Rman> drop database;
Do you really want to drop the database (enter YES or NO)? yes Database dropped.