Expensive All,
On this publish i’m sharing how one can delete a unused 2 node RAC Database take away from the database server.
Atmosphere ::
racnode1 :: db 1st node ( 2 databases are working – i’m eradicating on db UATDB1)
racnode2 :: db 2nd node ( 2 databases are working – i’m eradicating on db UATDB2)
drop/delete a 2 node rac database >>
> take backup earlier than drop the database and maintain for a while .
> test all of the recordsdata
choose title from v$datafile;
choose title from v$controlfile;
choose member from v$logfile;
> disable any schedule jobs on OEM /Cron
[racsinfo@racnode1 dbs]$ crontab -l
no crontab for racsinfo
[racsinfo@racnode1 dbs]$
> alter system set cluster_database=FALSE scope=spfile sid=’*’;
> test the db cluster parameters
srvctl standing database -d uatdb
srvctl config database -d uatdb
srvctl cease database -d uatdb
sqlplus / as sysdba
startup mount unique limit;
present parameter cluster
choose logins,instance_name,standing from gv$occasion;
drop database;
>> take away the configuration from the cluster
srvctl config database -d uatdb
srvctl take away database -d uatdb
srvctl config database -d uatdb
## Take away the directories if not required like archivelog directories and many others.
##Cross confirm if all of the related datafiles, controlfiles and on-line redologs
are eliminated
## Take away the entry of the database from /and many others/oratab
## crosscheck and cleanup all of the previous dumps or any log recordsdata
##Modify/drop any of the scripts used for this database in crontab
test the database occasion standing
cluster standing : ni uat db useful resource .
============================ ================================
additional steps if you wish to take away together with houses …
srvctl cease occasion -db db_unique_name -node node_name
srvctl relocate server -servers “server_name_list” -serverpool Free
srvctl standing listener -l LISTENER
srvctl disable listener -l LISTENER -n racnode1
srvctl cease listener -l LISTENER -n racnode1
[grid@racnode1 ~]$ olsnodes -s -t
racnode1 Lively Unpinned
racnode2 Lively Unpinned
[grid@racnode1 ~]$
Thanks,
Srini
