Saturday, May 30, 2020

Drop Database Delete Database manual method or GUI method

Drop Database:

1. GUI Method:

--- Launch dbca and select drop option to drop the database

--- OEM or Grid Control (Only Instance delete)

2. Manual Method:

--- connect to database in mount restrict mode and drop the database

--- shutdown the database and manually delete all the datafiles and configuration file (Not Recommended)

Drop Database possibilities:

open mode - drop database is not possible

mount mode - drop database is not possible

mount exclusive - drop database is not possible

mount restricted - drop database is possible


Please refer the more details in my YouTube channel https://youtu.be/3EWLBLie8-w


Regards,
Mallik

No comments:

Post a Comment

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...