I. Description
When we install the DB cluster, the last step is to use the DBCA to build the library, in the process of building the database in the cluster resources do? Actually added a ora.dbname.db this cluster resource.
Ways to delete a database
1, use DBCA to delete, this everybody will
2, manually delete the library, first remove the cluster resource ora.dbanme.db, and then to ASM to delete the relevant data.
Second, the Operation procedure
1. View Database Configuration
<rac01:+ASM1:/home/grid>$srvctl config database -d orclDatabase unique name: orclDatabase name: orclOracle home: /u01/app/oracle/product/12.1.0/dbhome_1Oracle user: oracleSpfile: +DATADG/ORCL/PARAMETERFILE/spfile.268.954540133Password file: +DATADG/ORCL/PASSWORD/pwdorcl.256.954539259Domain: Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: Disk Groups: DATADGMount point paths: Services: Type: RACStart concurrency: Stop concurrency: OSDBA group: dbaOSOPER group: operDatabase instances: orcl1,orcl2Configured nodes: rac01,rac02Database is administrator managed<rac01:+ASM1:/home/grid>$
2. Delete Resources
--grid user Execution Srvctl stop database-d orcl--oracle user execution <rac01:orcl1:/home/oracle> $srvctl remove instance-d orcl-i orc L1remove instance from the database ORCL? (Y/[n]) y<rac01:orcl1:/home/oracle> $srvctl remove instance-d orcl-i orcl2remove instance from the database ORCL? (Y/[n]) y<rac01:orcl1:/home/oracle> $srvctl config database-d orcldatabase unique name:orcldatabase name: Orcloracle Home:/u01/app/oracle/product/12.1.0/dbhome_1oracle user:oraclespfile: +datadg/orcl/parameterfile/ Spfile.268.954540133password file: +datadg/orcl/password/pwdorcl.256.954539259domain:start options:openstop Options:immediatedatabase role:primarymanagement policy:automaticserver pools:disk groups:datadgmount Point Paths:se Rvices:Type:RACStart concurrency:stop concurrency:osdba group:dbaosoper group:operdatabase instances:configured nod Es:database is Administrator managed<rac01:orcl1:/home/oracle>$<rac01:orcl1:/home/oracle> $srvctl Remove Database-d Orclremove the database ORCL? (Y/[n]) y
3, and then add the resources
--oracle user srvctl Add database-d orcl-o $ORACLE _homesrvctl add instance-d orcl-n rac01-i orcl1srvctl Add instance-d Orcl-n rac02-i orcl2<rac01:orcl1:/home/oracle> $srvctl add database-d orcl-o $ORACLE _home<rac01:orcl1:/home/ Oracle> $srvctl config database-d orcldatabase unique name:orcldatabase name:oracle home:/U01/APP/ORACLE/PRODUCT/12 .1.0/dbhome_1oracle User:oracleSpfile:Password File:Domain:Start options:openstop options:immediatedatabase ROLE:PR Imarymanagement policy:automaticserver pools:disk groups:mount Point Paths:Services:Type:RACStart concurrency:stop CONCURRENCY:OSDBA group:dbaosoper group:operdatabase instances:configured nodes:database is Administrator managed< Rac01:orcl1:/home/oracle> $srvctl Add instance-d orcl-n rac01-i orcl1<rac01:orcl1:/home/oracle> $srvctl Add instance-d orcl-n rac02-i orcl2<rac01:orcl1:/home/oracle>$<rac01:orcl1:/home/oracle> $srvctl Config database-d orcldatabase Unique Name:Orcldatabase name:oracle Home:/u01/app/oracle/product/12.1.0/dbhome_1oracle User:oracleSpfile:Password File:domain : Start options:openstop options:immediatedatabase role:primarymanagement policy:automaticserver pools:disk groups:m Ount Point Paths:Services:Type:RACStart concurrency:stop concurrency:osdba group:dbaosoper group:operdatabase Insta nces:orcl1,orcl2configured Nodes:rac01,rac02database is Administrator managed<rac01:orcl1:/home/oracle>$ Srvctl Modify Database-db orcl-spfile ' +datadg/orcl/parameterfile/spfile.268.954540133 '-pwfile ' +DATADG/ORCL/ password/pwdorcl.256.954539259 ' <rac01:orcl1:/home/oracle> $srvctl modify database-db orcl-spfile ' +datadg/ orcl/parameterfile/spfile.268.954540133 '-pwfile ' +datadg/orcl/password/pwdorcl.256.954539259 ' <rac01:orcl1:/ home/oracle> $srvctl start database-d orcl<rac01:orcl1:/home/oracle>$
12c RAC Add Delete ora.dbanme.db resource