Shulou(Shulou.com)06/01 Report--

I. explanation

When we install the database cluster, the last step is to use DBCA to build the database. What exactly did we do in the cluster resources in the process of building the database? Actually added an ora.dbname.db as a cluster resource.

The method of deleting the database

1. Delete using DBCA, which everyone can do.

2. Delete the database manually, first delete the cluster resource ora.dbanme.db, and then delete the relevant data in ASM.

II. Operation steps

1. View the database configuration

$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$

2. Delete resources

Grid user executes srvctl stop database-d orcl--oracle user executes $srvctl remove instance-d orcl- I orcl1Remove instance from the database orcl? (y / [n]) y$srvctl remove instance-d orcl-I orcl2Remove instance from the database orcl? (y / [n]) y$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: dbaOSOPER group: operDatabase instances: Configured nodes: Database is administrator managed$$srvctl remove database-d orclRemove the database orcl? (y / [n]) y

3. Add more 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 $srvctl add database-d orcl-o $ORACLE_HOME$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: Mount point paths: Services: Type: RACStart concurrency: Stop Concurrency: OSDBA group: dbaOSOPER group: operDatabase instances: Configured nodes: Database is administrator managed$srvctl add instance-d orcl-n rac01-I orcl1 $srvctl add instance-d orcl-n rac02-I orcl2 $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: Mount point paths: Services: Type: RACStart concurrency: Stop concurrency: OSDBA group: dbaOSOPER group: operDatabase instances: orcl1 Orcl2Configured nodes: rac01,rac02Database is administrator managed$srvctl modify database-db orcl-spfile'+ DATADG/ORCL/PARAMETERFILE/spfile.268.954540133'-pwfile'+ DATADG/ORCL/PASSWORD/pwdorcl.256.954539259'$srvctl modify database-db orcl-spfile'+ DATADG/ORCL/PARAMETERFILE/spfile.268.954540133'-pwfile'+ DATADG/ORCL/PASSWORD/pwdorcl.256.954539259'$srvctl start database-dorcl $

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.