Silent Mode using dbca
$ dbca -silent -deleteInstance -nodeList rac2 -gdbName devdb -instanceName devdb2 -sysDBAUserName sys -sysDBAPassword myPassword
Deleting instance
20% complete
21% complete
22% complete
26% complete
33% complete
40% complete
46% complete
53% complete
60% complete
66% complete
Completing instance management.
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/devdb.log" for further details.
$
Post-Delete Checks
Check the redo thread associated with the deleted node has been disabled. In this case we deleted the instance "RAC2" which was thread 2.
SQL> select distinct thread# from v$log;
THREAD#
----------
1
If the thread associated with the deleted instance hans't been disabled, do it manually.
SQL> ALTER DATABASE DISABLE THREAD 2;
Check the instance information has been deleted from the OCR.
$ srvctl config database -d RAC
Database unique name: RAC
Database name: RAC
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/RAC/spfileRAC.ora
Domain: localdomain
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RAC
Database instances: RAC1
Disk Groups: DATA
Mount point paths:
Services: BATCH_SERVICE,OLTP_SERVICE
Type: RAC
Database is administrator managed