12c RAC 添加删除ora.dbanme.db资源
admin
2023-04-23 02:02:42
0

一、说明
我们在安装数据库集群的时候,最后有一步是使用DBCA建库,建库的过程中到底在集群资源中做了什么呢?实际上添加了一个ora.dbname.db这个集群资源。
删除数据库的方法
1、使用DBCA进行删除,这个大家都会
2、手动删库,先删除集群资源ora.dbanme.db,然后到ASM中删除相关数据即可。

二、操作步骤
1、查看数据库配置

$srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATADG/ORCL/PARAMETERFILE/spfile.268.954540133
Password file: +DATADG/ORCL/PASSWORD/pwdorcl.256.954539259
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: DATADG
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2
Configured nodes: rac01,rac02
Database is administrator managed
$

2、删除资源

--grid用户执行
srvctl stop database -d orcl
--oracle 用户执行
$srvctl remove instance -d orcl -i  orcl1
Remove instance from the database orcl? (y/[n]) y
$srvctl remove instance -d orcl -i  orcl2
Remove instance from the database orcl? (y/[n]) y
$srvctl config database -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATADG/ORCL/PARAMETERFILE/spfile.268.954540133
Password file: +DATADG/ORCL/PASSWORD/pwdorcl.256.954539259
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: DATADG
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: oper
Database instances: 
Configured nodes: 
Database is administrator managed
$
$srvctl remove database -d orcl
Remove the database orcl? (y/[n]) y

3、再添加资源

--oracle 用户 
srvctl add database -d orcl -o $ORACLE_HOME
srvctl add instance -d orcl -n rac01 -i orcl1
srvctl add instance -d orcl -n rac02 -i orcl2

$srvctl add database -d orcl -o $ORACLE_HOME
$srvctl config database -d orcl
Database unique name: orcl
Database name: 
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: 
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: 
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: oper
Database 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 orcl
Database unique name: orcl
Database name: 
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: 
Password file: 
Domain: 
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: 
Disk Groups: 
Mount point paths: 
Services: 
Type: RAC
Start concurrency: 
Stop concurrency: 
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2
Configured nodes: rac01,rac02
Database 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 -d orcl
$

相关内容

热门资讯

元旦假期首日:多个景区发布限流... 2026年1月1日,元旦假期第一天,全国多地迎来客流高峰。据湖南省文旅厅当日公布的数据显示,湖南省当...
赫步智能取得集成实时压力反馈系... 国家知识产权局信息显示,赫步智能科技(福建)有限公司取得一项名为“一种集成实时压力反馈系统的抛光用电...
2026哪些云手机好用?云手机... 时光来到2026年,云手机市场已然是一片热闹非凡的景象,各大品牌纷纷发力,在这片充满机遇与挑战的领域...
“稚晖君”发布第一款人形机器人 来源:市场资讯 (来源:第一财经资讯) 2026.01.01 本文字数:1864,阅读时长大约3分...
原创 英... 这家微型工厂将在太空中制造半导体 这听起来像是科幻小说,一座位于地球上空数百公里处的工厂,源源不断地...
终于明白“新老夫子牛牛怎么装挂... 终于明白“新老夫子牛牛怎么装挂?”(太坑了原来有挂)您好,新老夫子牛牛这个游戏其实有挂的,确实是有挂...
终于了解“鹤岗52麻将是不是有... 有 亲,根据资深记者爆料鹤岗52麻将是可以开挂的,确实有挂(咨询软件无需...
我来教教您“微信链接麻将开挂器... 您好:微信链接麻将这款游戏可以开挂,确实是有挂的,需要了解加客服微信【9784099】很多玩家在这款...
【第一资讯】“钱潮十三水怎么装... 【第一资讯】“钱潮十三水怎么装挂?”(透视曝光猫腻)您好,钱潮十三水这个游戏其实有挂的,确实是有挂的...
玩家最新攻略“决战仙桃麻将开挂... 家人们!今天小编来为大家解答决战仙桃麻将透视挂怎么安装这个问题咨询软件客服徽9752949的挂在哪里...