How to drop database using RMAN

Search
Generic filters
Exact matches only
Filter by Custom Post Type

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

Steps

Use the ‘drop database’ command to drop database usingĀ  RMAN . Here are the steps to follow:

  1. Set the Operating System Variables to connect to database.
  2. 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
  3. 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

Liked this Article.?

We have lot more interesting posts like this!  Join more than 5000 subscribers who stays ahead on technology.

By entering your email, you agree to the Terms and Conditions and Privacy Policy and cookies usage

You Make like the below posts

About The Author

Share on

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest

Leave a comment

Your email address will not be published. Required fields are marked *

Can't Find What You Are Looking For?.

Please enter the details below. We will try our best for you :-)

We have more amazing posts

Try searching here

lick edit button to change this text. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

We assure our best to meet up to your expectations

Your Feedback will help us

Glad That You Liked It

Your Feedback will help us to improve