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

Interview_Questions_5 | Oracle ASM Architecture, Internals, Disk Groups & Redundancy

1. change diskgroup redundancy?  TESTDB -> +DATA (External Redundancy) Change redundancy of DATA diskgroup to NORMAL / HIGH?  - Not possi...