rac删除数据库.docx
- 文档编号:7518424
- 上传时间:2023-01-24
- 格式:DOCX
- 页数:17
- 大小:774.25KB
rac删除数据库.docx
《rac删除数据库.docx》由会员分享,可在线阅读,更多相关《rac删除数据库.docx(17页珍藏版)》请在冰豆网上搜索。
rac删除数据库
1.方法一:
通过srvctl命令从crs中删除DB的服务(oracle用户执行)
[oracle@hcn1~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora....SM1.asmapplicationONLINEONLINEhcn1
ora....N1.lsnrapplicationONLINEONLINEhcn1
ora.hcn1.gsdapplicationONLINEONLINEhcn1
ora.hcn1.onsapplicationONLINEONLINEhcn1
ora.hcn1.vipapplicationONLINEONLINEhcn1
ora....SM2.asmapplicationONLINEONLINEhcn2
ora....N2.lsnrapplicationONLINEONLINEhcn2
ora.hcn2.gsdapplicationONLINEONLINEhcn2
ora.hcn2.onsapplicationONLINEONLINEhcn2
ora.hcn2.vipapplicationONLINEONLINEhcn2
ora.hcndb.dbapplicationONLINEONLINEhcn1
ora....b1.instapplicationONLINEONLINEhcn1
ora....b2.instapplicationONLINEONLINEhcn2
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$srvctl-help
Usage:
srvctl
command:
enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config
objects:
database|instance|service|nodeapps|asm|listener
Fordetailedhelponeachcommandandobjectanditsoptionsuse:
srvctl
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$srvctlremovedatabase-h
Usage:
srvctlremovedatabase-d
-d
-fForceremove
-hPrintusage
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$srvctlremovedatabase-dhcndb
Removethedatabasehcndb?
(y/[n])y
PRKP-1022:
Thedatabasehcndbisstillrunning.
数据库在运行状态下不能删除
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora....SM1.asmapplicationONLINEONLINEhcn1
ora....N1.lsnrapplicationONLINEONLINEhcn1
ora.hcn1.gsdapplicationONLINEONLINEhcn1
ora.hcn1.onsapplicationONLINEONLINEhcn1
ora.hcn1.vipapplicationONLINEONLINEhcn1
ora....SM2.asmapplicationONLINEONLINEhcn2
ora....N2.lsnrapplicationONLINEONLINEhcn2
ora.hcn2.gsdapplicationONLINEONLINEhcn2
ora.hcn2.onsapplicationONLINEONLINEhcn2
ora.hcn2.vipapplicationONLINEONLINEhcn2
ora.hcndb.dbapplicationONLINEONLINEhcn1
ora....b1.instapplicationONLINEONLINEhcn1
ora....b2.instapplicationONLINEONLINEhcn2
[oracle@hcn1~]$
[oracle@hcn1~]$
a.关闭数据库
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$srvctlstopdatabase-dhcndb
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora....SM1.asmapplicationONLINEONLINEhcn1
ora....N1.lsnrapplicationONLINEONLINEhcn1
ora.hcn1.gsdapplicationONLINEONLINEhcn1
ora.hcn1.onsapplicationONLINEONLINEhcn1
ora.hcn1.vipapplicationONLINEONLINEhcn1
ora....SM2.asmapplicationONLINEONLINEhcn2
ora....N2.lsnrapplicationONLINEONLINEhcn2
ora.hcn2.gsdapplicationONLINEONLINEhcn2
ora.hcn2.onsapplicationONLINEONLINEhcn2
ora.hcn2.vipapplicationONLINEONLINEhcn2
ora.hcndb.dbapplicationOFFLINEOFFLINE
ora....b1.instapplicationOFFLINEOFFLINE
ora....b2.instapplicationOFFLINEOFFLINE
[oracle@hcn1~]$
b.删除db服务
[oracle@hcn1~]$
[oracle@hcn1~]$srvctlremovedatabase-dhcndb
Removethedatabasehcndb?
(y/[n])y
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora....SM1.asmapplicationONLINEONLINEhcn1
ora....N1.lsnrapplicationONLINEONLINEhcn1
ora.hcn1.gsdapplicationONLINEONLINEhcn1
ora.hcn1.onsapplicationONLINEONLINEhcn1
ora.hcn1.vipapplicationONLINEONLINEhcn1
ora....SM2.asmapplicationONLINEONLINEhcn2
ora....N2.lsnrapplicationONLINEONLINEhcn2
ora.hcn2.gsdapplicationONLINEONLINEhcn2
ora.hcn2.onsapplicationONLINEONLINEhcn2
ora.hcn2.vipapplicationONLINEONLINEhcn2
[oracle@hcn1~]$
[oracle@hcn1~]$
c.此时的db已经从crs服务中删除,但是ASM中的数据文件等还是存在的
[oracle@hcn1~]$
[oracle@hcn1~]$exportORACLE_SID=+ASM1
[oracle@hcn1~]$ps-ef|greppmon
oracle48751020:
41?
00:
00:
00asm_pmon_+ASM1
oracle159838895021:
08pts/100:
00:
00greppmon
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$asmcmd
ASMCMD>lsdg
StateTypeRebalUnbalSectorBlockAUTotal_MBFree_MBReq_mir_free_MBUsable_file_MBOffline_disksName
MOUNTEDEXTERNNN51240961048576102408147081470DATADG/
ASMCMD>
ASMCMD>pwd
+
ASMCMD>cd
usage:
cd
ASMCMD>cd+
ASMCMD>ls
DATADG/
ASMCMD>cdDATADG
ASMCMD>LS
commands:
--------
cd
du
find
help
ls
lsct
lsdg
mkalias
mkdir
pwd
rm
rmalias
ASMCMD>ls
HCNDB/
ASMCMD>cdHCNDB
ASMCMD>ls
ARCHIVELOG/
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
TEMPFILE/
spfilehcndb.ora
ASMCMD>ls-lrt
TypeRedundStripedTimeSysName
YARCHIVELOG/
YCONTROLFILE/
YDATAFILE/
YONLINELOG/
YPARAMETERFILE/
YTEMPFILE/
Nspfilehcndb.ora=>+DATADG/HCNDB/PARAMETERFILE/spfile.272.805334085
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD>cddatafile
ASMCMD>ls
SYSAUX.264.805333303
SYSTEM.262.805333299
UNDOTBS1.263.805333303
UNDOTBS2.266.805333305
USERS.267.805333305
ASMCMD>
ASMCMD>
d.可以通过手工删除的方式删除asm中的数据文件
2.通过dbca的方式,图形化删除
先恢复之前的状态,把db加入到crs中
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$srvctladddatabase-dhcndb-o$ORACLE_HOME
[oracle@hcn1~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora....SM1.asmapplicationONLINEONLINEhcn1
ora....N1.lsnrapplicationONLINEONLINEhcn1
ora.hcn1.gsdapplicationONLINEONLINEhcn1
ora.hcn1.onsapplicationONLINEONLINEhcn1
ora.hcn1.vipapplicationONLINEONLINEhcn1
ora....SM2.asmapplicationONLINEONLINEhcn2
ora....N2.lsnrapplicationONLINEONLINEhcn2
ora.hcn2.gsdapplicationONLINEONLINEhcn2
ora.hcn2.onsapplicationONLINEONLINEhcn2
ora.hcn2.vipapplicationONLINEONLINEhcn2
ora.hcndb.dbapplicationOFFLINEOFFLINE
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$
[oracle@hcn1~]$srvctladdinstance-dhcndb-ihcndb1-nhcn1
[oracle@hcn1~]$srvctladdinstance-dhcndb-ihcndb2-nhcn2
[oracle@hcn1~]$
[oracle@hcn1~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora....SM1.asmapplicationONLINEONLINEhcn1
ora....N1.lsnrapplicationONLINEONLINEhcn1
ora.hcn1.gsdapplicationONLINEONLINEhcn1
ora.hcn1.onsapplicationONLINEONLINEhcn1
ora.hcn1.vipapplicationONLINEONLINEhcn1
ora....SM2.asmapplicationONLINEONLINEhcn2
ora....N2.lsnrapplicationONLINEONLINEhcn2
ora.hcn2.gsdapplicationONLINEONLINEhcn2
ora.hcn2.onsapplicationONLINEONLINEhcn2
ora.hcn2.vipapplicationONLINEONLINEhcn2
ora.hcndb.dbapplicationOFFLINEOFFLINE
ora....b1.instapplicationOFFLINEOFFLINE
ora....b2.instapplicationOFFLINEOFFLINE
[oracle@hcn1~]$
[oracle@hcn1~]$
启动服务看是否能成功
[oracle@hcn1~]$
[oracle@hcn1~]$srvctlstartdatabase-dhcndb
[oracle@hcn1~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora....SM1.asmapplicationONLINEONLINEhcn1
ora....N1.lsnrapplicationONLINEONLINEhcn1
ora.hcn1.gsdapplicationONLINEONLINEhcn1
ora.hcn1.onsapplicationONLINEONLINEhcn1
ora.hcn1.vipapplicationONLINEONLINEhcn1
ora....SM2.asmapplicationONLINEONLINEhcn2
ora....N2.lsnrapplicationONLINEONLINEhcn2
ora.hcn2.gsdapplicationONLINEONLINEhcn2
ora.hcn2.onsapplicationONLINEONLINEhcn2
ora.hcn2.vipapplicationONLINEONLINEhcn2
ora.hcndb.dbapplicationONLINEONLINEhcn1
ora....b1.instapplicationONLINEONLINEhcn1
ora....b2.instapplicationONLINEONLINEhcn2
[oracle@hcn1~]$
在安装的节点上执行dbca
[oracle@hcn1admin]$
[oracle@hcn1admin]$ls-lrt
total24
-rw-r--r--1oracleoinstall172Dec262003shrept.lst
drwxr-x---2oracleoinstall4096Jan172013samples
-rw-r-----1oracleoinstall836May52013listener.ora
-rw-r-----1oracleoinstall1164May52013tnsnames.ora
[oracle@hcn1admin]$
[oracle@hcn1admin]$
[oracle@hcn1admin]$
[oracle@hcn1admin]$ls-lrt
total24
-rw-r--r--1oracleoinstall172Dec262003shrept.lst
drwxr-x---2oracleoinstall4096Jan172013samples
-rw-r-----1oracleoinstall836May52013listener.ora
-rw-r-----1oracleoinstall330Jan921:
38tnsnames.ora
[oracle@hcn1admin]$
[oracle@hcn1admin]$
[oracle@hcn1admin]$date
ThuJan921:
39:
51CST2014
[oracle@hcn1admin]$
[oracle@hcn1admin]$
其中的Updatingnetworkconfigurationfiles过程是修改了tnsnames.ora文件
修改前:
[oracle@hcn1admin]$
[oracle@hcn1admin]$cattnsnames.ora
#tnsnames.oraNetworkConfigurationFile:
/u01/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
#GeneratedbyOracleconfigurationtools.
HCNDB=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=hcn1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=hcn2-vip)(PORT=1521))
(LOAD_BALANCE=yes)
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=hcndb)
)
)
HCNDB2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=hcn2-vip)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=hcndb)
(INSTANCE_NAME=hcndb2)
)
)
HCNDB1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=hcn1-vip)(PORT=1521))
(CONNECT_DATA=
(SERVER=DEDICATED)
(SERVICE_NAME=hcndb)
(INSTANCE_NAME=hcndb1)
)
)
LISTENERS_HCNDB=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=hcn1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=hcn2-vip)(PORT=1521))
)
HCNDBDG=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.100.33)(PORT=152
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- rac 删除 数据库