I am demonstrating how we can drop the database in RAC environment manually in Oracle12c(12.1.0.2.0) version.

I have two node RAC and the database name is TEST.  The instance names are TEST1 & TEST2.

  1. Verify the instance

2. Stop the entire cluster environment

3. Start only one instance to edit the cluster_database parameter to FALSE

4. Mount the first instance in restrict mode and drop the database.

5. Update the OCR

6. Verify the instance

7. To drop the database including the backup, we can go for the below option

8. Go to OS and clean if there is any files related to the database. Go to ASM disk and clean if there is any relevant files to  this database.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: www.linkedin.com/in/SirDBaaSJoelPerez

Anuradha’s LinkedIn: https://www.linkedin.com/in/dbaanuradhamudgal/

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply