oracle RAC如何正确地删除ASM磁盘组
来源:互联网 发布:豆瓣python 编辑:程序博客网 时间:2024/06/16 05:57
1.检查确认要删除的磁盘组是否在用
select * from dba_data_files;
select * from dba_temp_files;
select * from v$logfile;
2.先在各节点上dismount磁盘组
alter diskgroup REDO01 dismount;
alter diskgroup REDO02 dismount;
alter diskgroup REDODG1 dismount;
3.ASM中删除磁盘组
drop diskgroup REDO01 force including contents;
drop diskgroup REDO02 force including contents;
drop diskgroup REDODG1 force including contents;
4.crs删除磁盘组
crsctl stat res -t ---查看磁盘组
srvctl remove diskgroup -g REDO01 -f
srvctl remove diskgroup -g REDO02 -f
srvctl remove diskgroup -g REDODG1 -f
5.更新crs信息
查看crs依赖的磁盘组:
crsctl status res ora.verlms.db -f
START_DEPENDENCIES=hard(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.testDG1.dg,shutdown:ora.testDG2.dg,shutdown:ora.REDODG1.dg,shutdown:ora.testDG3.dg,shutdown:ora.REDO01.dg,shutdown:ora.REDO02.dg,shutdown:ora.REDODG01.dg)
修改正确的磁盘组:
srvctl modify database -d verlms -a "testDG1,testDG2,testDG3,REDODG01"
select * from dba_data_files;
select * from dba_temp_files;
select * from v$logfile;
2.先在各节点上dismount磁盘组
alter diskgroup REDO01 dismount;
alter diskgroup REDO02 dismount;
alter diskgroup REDODG1 dismount;
3.ASM中删除磁盘组
drop diskgroup REDO01 force including contents;
drop diskgroup REDO02 force including contents;
drop diskgroup REDODG1 force including contents;
4.crs删除磁盘组
crsctl stat res -t ---查看磁盘组
srvctl remove diskgroup -g REDO01 -f
srvctl remove diskgroup -g REDO02 -f
srvctl remove diskgroup -g REDODG1 -f
5.更新crs信息
查看crs依赖的磁盘组:
crsctl status res ora.verlms.db -f
START_DEPENDENCIES=hard(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(ora.testDG1.dg,ora.testDG2.dg,ora.REDODG1.dg,ora.testDG3.dg,ora.REDO01.dg,ora.REDO02.dg,ora.REDODG01.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.testDG1.dg,shutdown:ora.testDG2.dg,shutdown:ora.REDODG1.dg,shutdown:ora.testDG3.dg,shutdown:ora.REDO01.dg,shutdown:ora.REDO02.dg,shutdown:ora.REDODG01.dg)
修改正确的磁盘组:
srvctl modify database -d verlms -a "testDG1,testDG2,testDG3,REDODG01"
阅读全文
0 0
- oracle RAC如何正确地删除ASM磁盘组
- 如何卸载并删除ASM磁盘组
- oracle 10g rac asm磁盘组增加硬盘
- Oracle 11gR2 RAC DBCA无法识别ASM磁盘组
- Oracle 11gR2 RAC DBCA无法识别ASM磁盘组
- ORACLE RAC 重新安装时清空ASM 磁盘命令
- 如何正确地将PVID从ASM磁盘头部除去
- ASM如何删除/增加磁盘
- oracle rac 11g如何修改归档到ASM FRA磁盘
- Oracle DG环境如何正确地删除Archivelog
- ASM磁盘组删除磁盘试验
- ASM磁盘组及磁盘 添加、删除
- ASM磁盘组及磁盘 添加、删除
- oracle 10g rac+asm 归档路径磁盘组空间满问题处理
- ORACLE 12C RAC修改ocr/votedisk/asm spfile所在磁盘组名称
- Oracle 11.2.0.1 RAC ASM磁盘组全部丢失后的恢复
- oracle RAC 更换存储迁移数据(在线迁移ASM磁盘组)测试
- Oracle 10g rac将归档日志从文件系统拷贝至ASM磁盘组
- ST17H26调试板操作注意事项
- CentOS 编译安装 zabbix 3
- 自定义RecyclerView之上拉刷新更新数据
- DoTween
- 如何生成 RDF 数据?
- oracle RAC如何正确地删除ASM磁盘组
- 偶串
- 动画
- HDOJ 1013 Digital Roots
- 双非渣硕的算法求职路
- win 服务器迁移 ubuntu
- 新手上路之plsqldev(oracle)个人喜欢的背景色图文配置
- 【笔记】AI100-Kaggle竞赛_2017年房价预测
- Ajax上传文件(JQuery篇)