Drop Database Using RMAN
There are multiple ways to drop the database . One of the common method is by using ‘SQLPLUS ‘ .The other method is using ‘RMAN’ . In this article we will discuss how to drop database using RMAN
Use the ‘drop database’ command to drop database using RMAN . Here are the steps to follow:
- Set the Operating System Variables to connect to database.
- From RMAN prompt connect to database . Please note this command should be executed only from ‘Mount’ stage. So if the database is up and running , please shutdown before proceeding to next step
- Execute the following steps in the order to drop database using RMAN
RMAN > Connect target / RMAN > startup mount exclusive RMAN > Drop database;
Make sure if all the files ( datafiles , controlfiles and online redo logs ) related to this database is removed