📋Steps in this guide1/3

Drop database in oracle RAC DBACLASS

Drop database in oracle RAC , Change the parameter cluster_database to False and start database in mount exclusive mode.

oracle clusteringintermediate

by OracleDba

15 views

Overview

Below are the steps for dropping database in Oracle RAC. 1. Make cluster database to FALSE 2. Stop the db service

Code/Command (click line numbers to comment):

1
2
3

SQL> alter system set cluster_database=FALSE scope=spfile sid='*';

System altered.

Section 2

3. start the database in mount exclusive mode: 4.Now drop the database:

Code/Command (click line numbers to comment):

Srvctl stop database –d DBACLASS

SQL> startup mount exclusive restrict
ORACLE instance started.

Total System Global Area 1.0737E+11 bytes
Fixed Size                  7647784 bytes
Variable Size            8.2410E+10 bytes
Database Buffers         2.4159E+10 bytes
Redo Buffers              797655040 bytes
Database mounted.


SQL> select instance_name,status,logins from v$Instance;

INSTANCE_NAME    STATUS       LOGINS
---------------- ------------ ----------
DBACLASS        MOUNTED      RESTRICTED

Section 3

5. Remove the db service from cluster

Code/Command (click line numbers to comment):

SQL> drop database;

Database dropped.

srvctl remove database -db DBACLASS

Comments (0)

Please to add comments

No comments yet. Be the first to comment!