The title of the blogpost looks weird right? But sometimes as a business requirement we many need to delete or drop the databases. If there is requirement to drop any database which has prod/non prod data then ensure you've performed a complete backup of the database. Once you drop the database there is no chance that you can recover it and hence backup is must.
This blogpost will provide a step by step method for dropping an Oracle 19c Cluster Database.
1. check the status of Database:
[oracle@ebsdb01 ~]$ ps -ef | grep pmon
oracle 92680 92633 0 16:33 pts/4 00:00:00 grep --color=auto pmon
oracle 110059 1 0 03:36 ? 00:00:10 ora_pmon_ebsdb1
2. Stop the Database on all nodes:
[oracle@ebsdb01 ~]$ srvctl stop database -d ebsdb
[oracle@ebsdb01 ~]$
3. Startup database and disable cluster database parameter:
bring up he database in mount mode.
oracle@ebsdb01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 8 16:37:59 2021
Version 19.10.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 8.0531E+10 bytes
Fixed Size 30388440 bytes
Variable Size 1.0737E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 238043136 bytes
Database mounted.
SQL> alter system set cluster_database=FALSE scope=spfile;
System altered.
SQL>
4. Shutdown, start database in restricted mode:
SQL> startup mount restrict exclusive;
ORACLE instance started.
Total System Global Area 8.0531E+10 bytes
Fixed Size 30388440 bytes
Variable Size 1.0737E+10 bytes
Database Buffers 6.9525E+10 bytes
Redo Buffers 238043136 bytes
Database mounted.
SQL> select logins,parallel from v$instance;
LOGINS PAR
---------- ---
RESTRICTED NO
SQL>
5. Drop the Database:
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0
SQL>
Conclusion:
The cluster database is dropped in five simple steps but if there is a need to get back this database then your only source is backup. If there is no backup then there is no chance of recovery. Incase if you are performing this activity have proper recorded approvals with required backups before proceeding.
Hope it helps.
Thanks for reading :)
regards,
zaheer
Comments