签到成功

知道了

CNDBA社区CNDBA社区

oracle rac 替换asm磁盘组过程

2022-04-05 22:24 1073 0 原创 oracle
作者： hbhe0316
本文链接：http://www.cndba.cn/hbhe0316/article/107910

1、添加新磁盘：
两个节点都操作,使用root用户http://www.cndba.cn/hbhe0316/article/107910

for i in j k; do 
echo "KERNEL==/"sd*/",ENV{DEVTYPE}==/"disk/",SUBSYSTEM==/"block/",PROGRAM==/"/usr/lib/udev/scsi_id -g -u -d /$devnode/",RESULT==/"`/usr/lib/udev/scsi_id -g -u /dev/sd$i`/", RUN+=/"/bin/sh -c 'mknod /dev/asm-disk$i b  /$major /$minor; chown grid:asmadmin /dev/asm-disk$i; chmod 0660 /dev/asm-disk$i'/"" >> /etc/udev/rules.d/99-oracle-asmdevices.rules 
done

/sbin/udevadm trigger --type=devices --action=change
/sbin/udevadm control --reload
ll /dev/asm*

一个节点http://www.cndba.cn/hbhe0316/article/107910http://www.cndba.cn/hbhe0316/article/107910

[root@rac01 ~]# su - grid
Last login: Tue Apr  5 21:48:21 CST 2022 on pts/1
[grid@rac01 ~]$ asmcmd
ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512             512   4096  4194304    143360   123652            51200           36226              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     40960    39444                0           39444              0             N  MGMT/
MOUNTED  NORMAL  N         512             512   4096  4194304     15360    14444             5120            4662              0             Y  OCR/

[root@rac01 ~]# su - grid
Last login: Tue Apr  5 21:25:22 CST 2022 on pts/0

[grid@rac01 ~]$ sqlplus / as sysasm

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Apr 5 21:51:11 2022
Version 19.12.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0

SQL> alter diskgroup DATA add disk '/dev/asm-diskj';

Diskgroup altered.

SQL> alter diskgroup DATA add disk '/dev/asm-diskk';

Diskgroup altered.

SQL> col name format a10
SQL> set line 9999
SQL> col path format a25
SQL> select GROUP_NUMBER,path,name,disk_number,total_mb,free_mb,CREATE_DATE,MOUNT_STATUS,MOUNT_DATE from v$asm_disk order by GROUP_NUMBER desc,disk_number;

GROUP_NUMBER PATH                      NAME       DISK_NUMBER   TOTAL_MB    FREE_MB CREATE_DA MOUNT_S MOUNT_DAT
------------ ------------------------- ---------- ----------- ---------- ---------- --------- ------- ---------
           3 AFD:OCR1                  OCR1                 0       5120       4812 19-SEP-21 CACHED  05-APR-22
           3 AFD:OCR2                  OCR2                 1       5120       4820 19-SEP-21 CACHED  05-APR-22
           3 AFD:OCR3                  OCR3                 2       5120       4812 19-SEP-21 CACHED  05-APR-22
           2 AFD:MGMT1                 MGMT1                0      40960      39444 19-SEP-21 CACHED  05-APR-22
           1 AFD:DATA1                 DATA1                0      51200      45304 20-SEP-21 CACHED  05-APR-22
           1 AFD:DATA2                 DATA2                1      51200      45304 20-SEP-21 CACHED  05-APR-22
           1 /dev/asmdiskh             DATA_0002            2      20480      17668 26-DEC-21 CACHED  05-APR-22
           1 /dev/asmdiski             DATA_0003            3      20480      17664 26-DEC-21 CACHED  05-APR-22
           1 /dev/asm-diskj            DATA_0004            4       8192       7016 05-APR-22 CACHED  05-APR-22
           1 /dev/asm-diskk            DATA_0005            5       8192       7008 05-APR-22 CACHED  05-APR-22
           0 /dev/asmdiskd                                  0          0          0 19-SEP-21 IGNORED 05-APR-22

GROUP_NUMBER PATH                      NAME       DISK_NUMBER   TOTAL_MB    FREE_MB CREATE_DA MOUNT_S MOUNT_DAT
------------ ------------------------- ---------- ----------- ---------- ---------- --------- ------- ---------
           0 /dev/asmdiskb                                  1          0          0 20-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiske                                  2          0          0 19-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiskf                                  3          0          0 19-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiskc                                  4          0          0 20-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiskg                                  5          0          0 19-SEP-21 IGNORED 05-APR-22

16 rows selected.

SQL> select name,state,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup;

NAME       STATE          FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ----------- ---------- ----------------------- --------------
DATA       MOUNTED         139964                   51200          44382
MGMT       MOUNTED          39444                       0          39444
OCR        MOUNTED          14444                    5120           4662

ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  Y         512             512   4096  4194304    159744   139964            51200           44382              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     40960    39444                0           39444              0             N  MGMT/
MOUNTED  NORMAL  N         512             512   4096  4194304     15360    14444             5120            4662              0             Y  OCR/

Rebal为Y说明磁盘在做rebance

ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512             512   4096  4194304    159744   139964            51200           44382              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     40960    39444                0           39444              0             N  MGMT/
MOUNTED  NORMAL  N         512             512   4096  4194304     15360    14444             5120            4662              0             Y  OCR/

SQL> select * from gv$asm_operation;

no rows selected

2、删除旧磁盘
剔除DATA_0002和DATA_0003http://www.cndba.cn/hbhe0316/article/107910

http://www.cndba.cn/hbhe0316/article/107910 

SQL> alter diskgroup DATA drop disk DATA_0002;

Diskgroup altered.

SQL> alter diskgroup DATA drop disk DATA_0003;

Diskgroup altered.

3、做动态平衡http://www.cndba.cn/hbhe0316/article/107910

http://www.cndba.cn/hbhe0316/article/107910 

SQL> alter system set asm_power_limit = 6 sid='*' ;

System altered.

SQL> alter diskgroup DATA rebalance wait ; 

Diskgroup altered.

SQL> select * from gv$asm_operation;

no rows selected

ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  Y         512             512   4096  4194304    159744   139964            51200           44382              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     40960    39444                0           39444              0             N  MGMT/
MOUNTED  NORMAL  N         512             512   4096  4194304     15360    14444             5120            4662              0             Y  OCR/
ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  NORMAL  N         512             512   4096  4194304    118784    99028            51200           23914              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     40960    39444                0           39444              0             N  MGMT/
MOUNTED  NORMAL  N         512             512   4096  4194304     15360    14444             5120            4662              0             Y  OCR/
ASMCMD>

4.查看是否完成http://www.cndba.cn/hbhe0316/article/107910http://www.cndba.cn/hbhe0316/article/107910

SQL> col name format a10
SQL> set line 9999
SQL> col path format a25
SQL> select GROUP_NUMBER,path,name,disk_number,total_mb,free_mb,CREATE_DATE,MOUNT_STATUS,MOUNT_DATE from v$asm_disk order by GROUP_NUMBER desc,disk_number;

GROUP_NUMBER PATH                      NAME       DISK_NUMBER   TOTAL_MB    FREE_MB CREATE_DA MOUNT_S MOUNT_DAT
------------ ------------------------- ---------- ----------- ---------- ---------- --------- ------- ---------
           3 AFD:OCR1                  OCR1                 0       5120       4812 19-SEP-21 CACHED  05-APR-22
           3 AFD:OCR2                  OCR2                 1       5120       4820 19-SEP-21 CACHED  05-APR-22
           3 AFD:OCR3                  OCR3                 2       5120       4812 19-SEP-21 CACHED  05-APR-22
           2 AFD:MGMT1                 MGMT1                0      40960      39444 19-SEP-21 CACHED  05-APR-22
           1 AFD:DATA1                 DATA1                0      51200      43272 20-SEP-21 CACHED  05-APR-22
           1 AFD:DATA2                 DATA2                1      51200      43272 20-SEP-21 CACHED  05-APR-22
           1 /dev/asm-diskj            DATA_0004            4       8192       6244 05-APR-22 CACHED  05-APR-22
           1 /dev/asm-diskk            DATA_0005            5       8192       6240 05-APR-22 CACHED  05-APR-22
           0 /dev/asmdiskd                                  0          0          0 19-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiskb                                  1          0          0 20-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiski                                  2          0          0 26-DEC-21 CLOSED  05-APR-22

GROUP_NUMBER PATH                      NAME       DISK_NUMBER   TOTAL_MB    FREE_MB CREATE_DA MOUNT_S MOUNT_DAT
------------ ------------------------- ---------- ----------- ---------- ---------- --------- ------- ---------
           0 /dev/asmdiskh                                  3          0          0 26-DEC-21 CLOSED  05-APR-22
           0 /dev/asmdiske                                  4          0          0 19-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiskf                                  5          0          0 19-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiskc                                  6          0          0 20-SEP-21 IGNORED 05-APR-22
           0 /dev/asmdiskg                                  7          0          0 19-SEP-21 IGNORED 05-APR-22

16 rows selected.

SQL> select name,state,free_mb,required_mirror_free_mb,usable_file_mb from v$asm_diskgroup;

NAME       STATE          FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
---------- ----------- ---------- ----------------------- --------------
DATA       MOUNTED          99028                   51200          23914
MGMT       MOUNTED          39444                       0          39444
OCR        MOUNTED          14444                    5120           4662

5.更新udev
更新udev，— 2个节点都操作，修改如下文件/etc/udev/rules.d/99-oracle-asmdevices.rules，去掉刚才的diskh和diski

http://www.cndba.cn/hbhe0316/article/107910 

/sbin/udevadm trigger --type=devices --action=change
/sbin/udevadm control --reload
ll /dev/asm*

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问：1038732次
  • 积分：1523
  • 等级：核心会员
  • 排名：第6名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ