从Oracle ASMLIB/udev 迁移到ASM Filter Driver
mhr18 2024-10-05 17:53 37 浏览 0 评论
1.查询并设置当前的ASM磁盘以及发现路径
[root@dbserver ~]# su - grid
[grid@dbserver ~]$ asmcmd dsget
parameter:/dev/asm*
profile:/dev/asm*
[grid@dbserver ~]$ asmcmd dsset '/dev/asm*','AFD:*'
[grid@dbserver ~]$ asmcmd dsget
parameter:/dev/asm*, AFD:*
profile:/dev/asm*,AFD:*
2.停止GI服务
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/crsctl stop has -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbserver'
CRS-2673: Attempting to stop 'ora.orcl.db' on 'dbserver'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dbserver'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dbserver' succeeded
CRS-2677: Stop of 'ora.orcl.db' on 'dbserver' succeeded
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'dbserver'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'dbserver'
CRS-2677: Stop of 'ora.DATA.dg' on 'dbserver' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'dbserver' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dbserver'
CRS-2677: Stop of 'ora.asm' on 'dbserver' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'dbserver'
CRS-2677: Stop of 'ora.evmd' on 'dbserver' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dbserver'
CRS-2677: Stop of 'ora.cssd' on 'dbserver' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbserver' has completed
CRS-4133: Oracle High Availability Services has been stopped.
3.卸载ASMLIB软件
# systemctl disable oracleasm
# oracleasm exit
3 yum remove oracleasm-support
4.配置AFD
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_configure
AFD-627: AFD distribution files found.
AFD-634: Removing previous AFD installation.
AFD-635: Previous AFD components successfully removed.
AFD-9294: updating file /etc/sysconfig/oracledrivers.conf
AFD-636: Installing requested AFD software.
AFD-637: Loading installed AFD drivers.
AFD-9321: Creating udev for AFD.
AFD-9323: Creating module dependencies - this may take some time.
AFD-9154: Loading 'oracleafd.ko' driver.
AFD-649: Verifying AFD devices.
AFD-9156: Detecting control device '/dev/oracleafd/admin'.
AFD-638: AFD installation correctness verified.
Modifying resource dependencies - this may take some time.
5.查看状态
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_state
ASMCMD-9526: The AFD state is 'LOADED' and filtering is 'ENABLED' on host 'dbserver‘
--如果上述的状态为disabled,则使用下面的命令启用
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_filter -e
6.修改/etc/oracleafd.conf
[root@dbserver ~]# vim /etc/oracleafd.conf
afd_diskstring='/dev/asm/data*‘
加上上面这行
7.迁移所有ASM磁盘
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data1 /dev/asm/data1 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data1 /dev/asm/data2 –migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data3 /dev/asm/data3 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data4 /dev/asm/data4 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data5 /dev/asm/data5 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data6 /dev/asm/data6 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data7 /dev/asm/data7 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data8 /dev/asm/data8 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data9 /dev/asm/data9 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_label data10 /dev/asm/data10 --migrate
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
DATA1 ENABLED /dev/asm/data1
DATA10 ENABLED /dev/asm/data10
DATA2 ENABLED /dev/asm/data2
DATA3 ENABLED /dev/asm/data3
DATA4 ENABLED /dev/asm/data4
DATA5 ENABLED /dev/asm/data5
DATA6 ENABLED /dev/asm/data6
DATA7 ENABLED /dev/asm/data7
DATA8 ENABLED /dev/asm/data8
DATA9 ENABLED /dev/asm/data9
8.启动GI
[root@dbserver ~]# /u01/app/19.10.0/grid/bin/crsctl start has
CRS-4123: Oracle High Availability Services has been started.
9.修改新的ASM磁盘发现路径,只包含AFD
[root@dbserver ~]# su - grid
[grid@dbserver ~]$ asmcmd dsget
parameter:/dev/asm*, AFD:*
profile:/dev/asm*,AFD:*
[grid@dbserver ~]$ asmcmd dsset 'AFD:*'
[grid@dbserver ~]$ asmcmd dsget
parameter:AFD:*
profile:AFD:*
10.列出ASM磁盘
[grid@dbserver ~]$ asmcmd lsdsk
Path
AFD:DATA1
AFD:DATA10
AFD:DATA2
AFD:DATA3
AFD:DATA4
AFD:DATA5
AFD:DATA6
AFD:DATA7
AFD:DATA8
AFD:DATA9
11.执行下面的SQL进行验证
[grid@dbserver ~]$ sqlplus /nolog
SQL> conn / as sysasm
SQL> set linesize 300
SQL> col path for a20
SQL> col library for a45
SQL> col name for a15
SQL> select inst_id,group_number grp_num,name,state,header_status header,mount_status mount,path, library
2 from gv$asm_disk order by inst_id,group_number,name;
INST_ID GRP_NUM NAME STATE HEADER MOUNT PATH LIBRARY
---------- ---------- --------------- -------- ------------ ------- -------------------- ---------------------------------------------
1 1 DATA_0000 NORMAL MEMBER CACHED AFD:DATA1 AFD Library - Generic , version 3 (KABI_V3)
1 1 DATA_0001 NORMAL MEMBER CACHED AFD:DATA2 AFD Library - Generic , version 3 (KABI_V3)
1 1 DATA_0002 NORMAL MEMBER CACHED AFD:DATA3 AFD Library - Generic , version 3 (KABI_V3)
1 1 DATA_0003 NORMAL MEMBER CACHED AFD:DATA4 AFD Library - Generic , version 3 (KABI_V3)
1 1 DATA_0004 NORMAL MEMBER CACHED AFD:DATA5 AFD Library - Generic , version 3 (KABI_V3)
1 1 DATA_0005 NORMAL MEMBER CACHED AFD:DATA6 AFD Library - Generic , version 3 (KABI_V3)
1 1 DATA_0006 NORMAL MEMBER CACHED AFD:DATA7 AFD Library - Generic , version 3 (KABI_V3)
1 2 FRA_0000 NORMAL MEMBER CACHED AFD:DATA10 AFD Library - Generic , version 3 (KABI_V3)
1 2 FRA_0001 NORMAL MEMBER CACHED AFD:DATA8 AFD Library - Generic , version 3 (KABI_V3)
1 2 FRA_0002 NORMAL MEMBER CACHED AFD:DATA9 AFD Library - Generic , version 3 (KABI_V3)
10 rows selected.
相关推荐
- Redis合集-使用benchmark性能测试
-
采用开源Redis的redis-benchmark工具进行压测,它是Redis官方的性能测试工具,可以有效地测试Redis服务的性能。本次测试使用Redis官方最新的代码进行编译,详情请参见Redis...
- Java简历总被已读不回?面试挂到怀疑人生?这几点你可能真没做好
-
最近看了几十份简历,发现大部分人不是技术差,而是不会“卖自己”——一、简历死穴:你写的不是经验,是岗位说明书!反面教材:ד使用SpringBoot开发项目”ד负责用户模块功能实现”救命写法:...
- redission YYDS(redission官网)
-
每天分享一个架构知识Redission是一个基于Redis的分布式Java锁框架,它提供了各种锁实现,包括可重入锁、公平锁、读写锁等。使用Redission可以方便地实现分布式锁。red...
- 从数据库行锁到分布式事务:电商库存防超卖的九重劫难与破局之道
-
2023年6月18日我们维护的电商平台在零点刚过3秒就遭遇了严重事故。监控大屏显示某爆款手机SKU_IPHONE13_PRO_MAX在库存仅剩500台时,订单系统却产生了1200笔有效订单。事故复盘发...
- SpringBoot系列——实战11:接口幂等性的形而上思...
-
欢迎关注、点赞、收藏。幂等性不仅是一种技术需求,更是数字文明对确定性追求的体现。在充满不确定性的网络世界中,它为我们建立起可依赖的存在秩序,这或许正是技术哲学最深刻的价值所在。幂等性的本质困境在支付系...
- 如何优化系统架构设计缓解流量压力提升并发性能?Java实战分享
-
如何优化系统架构设计缓解流量压力提升并发性能?Java实战分享在高流量场景下。首先,我需要回忆一下常见的优化策略,比如负载均衡、缓存、数据库优化、微服务拆分这些。不过,可能还需要考虑用户的具体情况,比...
- Java面试题: 项目开发中的有哪些成长?该如何回答
-
在Java面试中,当被问到“项目中的成长点”时,面试官不仅想了解你的技术能力,更希望看到你的问题解决能力、学习迭代意识以及对项目的深度思考。以下是回答的策略和示例,帮助你清晰、有说服力地展示成长点:一...
- 互联网大厂后端必看!Spring Boot 如何实现高并发抢券逻辑?
-
你有没有遇到过这样的情况?在电商大促时,系统上线了抢券活动,结果活动刚一开始,服务器就不堪重负,出现超卖、系统崩溃等问题。又或者用户疯狂点击抢券按钮,最后却被告知无券可抢,体验极差。作为互联网大厂的后...
- 每日一题 |10W QPS高并发限流方案设计(含真实代码)
-
面试场景还原面试官:“如果系统要承载10WQPS的高并发流量,你会如何设计限流方案?”你:“(稳住,我要从限流算法到分布式架构全盘分析)…”一、为什么需要限流?核心矛盾:系统资源(CPU/内存/数据...
- Java面试题:服务雪崩如何解决?90%人栽了
-
服务雪崩是指微服务架构中,由于某个服务出现故障,导致故障在服务之间不断传递和扩散,最终造成整个系统崩溃的现象。以下是一些解决服务雪崩问题的常见方法:限流限制请求速率:通过限流算法(如令牌桶算法、漏桶算...
- 面试题官:高并发经验有吗,并发量多少,如何回复?
-
一、有实际高并发经验(建议结构)直接量化"在XX项目中,系统日活用户约XX万,核心接口峰值QPS达到XX,TPS处理能力为XX/秒。通过压力测试验证过XX并发线程下的稳定性。"技术方案...
- 瞬时流量高并发“保命指南”:这样做系统稳如泰山,老板跪求加薪
-
“系统崩了,用户骂了,年终奖飞了!”——这是多少程序员在瞬时大流量下的真实噩梦?双11秒杀、春运抢票、直播带货……每秒百万请求的冲击,你的代码扛得住吗?2025年了,为什么你的系统一遇高并发就“躺平”...
- 其实很多Java工程师不是能力不够,是没找到展示自己的正确姿势。
-
其实很多Java工程师不是能力不够,是没找到展示自己的正确姿势。比如上周有个小伙伴找我,五年经验但简历全是'参与系统设计''优化接口性能'这种空话。我就问他:你做的秒杀...
- PHP技能评测(php等级考试)
-
公司出了一些自我评测的PHP题目,现将题目和答案记录于此,以方便记忆。1.魔术函数有哪些,分别在什么时候调用?__construct(),类的构造函数__destruct(),类的析构函数__cal...
- 你的简历在HR眼里是青铜还是王者?
-
你的简历在HR眼里是青铜还是王者?兄弟,简历投了100份没反应?面试总在第三轮被刷?别急着怀疑人生,你可能只是踩了这些"隐形求职雷"。帮3630+程序员改简历+面试指导和处理空窗期时间...
你 发表评论:
欢迎- 一周热门
- 最近发表
- 标签列表
-
- oracle位图索引 (63)
- oracle批量插入数据 (62)
- oracle事务隔离级别 (53)
- oracle 空为0 (50)
- oracle主从同步 (55)
- oracle 乐观锁 (51)
- redis 命令 (78)
- php redis (88)
- redis 存储 (66)
- redis 锁 (69)
- 启动 redis (66)
- redis 时间 (56)
- redis 删除 (67)
- redis内存 (57)
- redis并发 (52)
- redis 主从 (69)
- redis 订阅 (51)
- redis 登录 (54)
- redis 面试 (58)
- 阿里 redis (59)
- redis 搭建 (53)
- redis的缓存 (55)
- lua redis (58)
- redis 连接池 (61)
- redis 限流 (51)