12c RAC Add Delete ora.dbanme.db resource

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.