Today we are discussing how to drop Oracle RAC database with Oracle RAC instances manually.
Our Oracle RAC database name is RACDB
Our Oracle RAC instances are 2 and both names RAC1 and RAC2.
Dropping Oracle RAC database step by step as follows:
1) First, use the command line and Stop database using srvctl command.
srvctl stop database -d RACDB
2) Now remove the database entry from crs (Cluster Ready Services)
srvctl remove instance -d RACDB -i RAC1
srvctl remove instance -d RACDB -i RAC2
srvctl remove database -d RACDB
3) After finishing above steps, Start the database on first instance using sqlplus.
SQL> alter system set cluster_database=false scope=spfile;
SQL> alter system set cluster_database_instances=1 scope=spfile;
SQL> alter database disable thread 2;
4) Delete the unwanted thread and redo logfiles. Thread 1 is for active instance and other is for another instance. Drop all redo group of other thread. Ex: Group 4,5,6 are for other thread then drop as follows.
SQL> select thread#, group# from v$log;
SQL> alter database drop logfile group 4;
SQL> alter database drop logfile group 5;
SQL> alter database drop logfile group 6;
5) Drop the unwanted undo tablespace
SQL> drop tablespace UNDOTBS2 including contents and datafiles; create pfile from spfile;
SQL> shut immediate
After shutdowning Oracle database kindly ensure to “shutdown immediate” command should need to use. Don’t use “shutdown abort”
7) Now start database again in mount stage
SQL>startup mount restrict
8) Drop database
Your Oracle RAC database will be dropped with Oracle RAC instance smoothly.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.