签到成功

知道了

CNDBA社区CNDBA社区

用新的磁盘组替换OCR-

2022-06-14 17:42 1155 0 原创 oracle
作者： Anshen
本文链接：http://www.cndba.cn/redhat/article/108065

重建OCR：
思路：sysdg中添加5块磁盘，剔出需要用的OCR5块磁盘并新建成OCR, 用OCR替换SYSDG，最后删除sysdg

SQL> set lines 400
SQL> col name for a25
SQL> col path for a60
SQL> set pagesize 1000
SQL> select group_number,name,path,OS_MB/1024 as “size_GB” from v$asm_disk where group_number=0;

GROUP_NUMBER NAME PATH size_GB

       0                           /dev/oracleasm/disks/st2h14_99b                              1788.23438
       0                           /dev/oracleasm/disks/st2h16_99b                              1788.23438
       0                           /dev/oracleasm/disks/st2h18_99b                              1788.23438
       0                           /dev/oracleasm/disks/st2h15_99b                              1788.23438
       0                           /dev/oracleasm/disks/st2h13_99b                              1788.23438
       0                           /dev/oracleasm/disks/st2h12_99b                              1788.23438
       0                           /dev/oracleasm/disks/st2h17_99b                              1788.23438

7 rows selected.

SQL>
SQL>
SQL> set lines 300
SQL> col name for a25
SQL> col path for a60
SQL> select GROUP_NUMBER,TYPE,name,round(TOTAL_MB/1024),
2 round(FREE_MB/1024),
3 round(round(FREE_MB/1024)/round(TOTAL_MB/1024))
4 from v$asm_diskgroup order by 4;

GROUP_NUMBER TYPE NAME ROUND(TOTAL_MB/1024) ROUND(FREE_MB/1024) ROUND(ROUND(FREE_MB/1024)/ROUND(TOTAL_MB/1024))

       1 HIGH   SYSDG                                      100                  99                                               1
       6 NORMAL REDODG                                   12518               11717                                               1
       5 NORMAL DATA4                                   125194               35776                                               0
       4 NORMAL DATA3                                   125194              122510                                               1
       2 NORMAL DATA1                                   125194              123708                                               1
       3 NORMAL DATA2                                   125194              120774                                               1

6 rows selected.http://www.cndba.cn/redhat/article/108065

SQL> select group_number,name,path,OS_MB/1024 as “size_GB” from v$asm_disk where group_number=1;

GROUP_NUMBER NAME PATH size_GB

       1 SYSDG_0002                /dev/oracleasm/disks/asmdisk0e                                       20
       1 SYSDG_0003                /dev/oracleasm/disks/asmdisk0f                                       20
       1 SYSDG_0000                /dev/oracleasm/disks/asmdisk0c                                       20
       1 SYSDG_0004                /dev/oracleasm/disks/asmdisk10                                       20
       1 SYSDG_0001                /dev/oracleasm/disks/asmdisk0d                                       20

====

添加磁盘到sysdg
alter diskgroup SYSDG add disk
‘/dev/oracleasm/disks/st2h14_99b’ size 20480M ,
‘/dev/oracleasm/disks/st2h16_99b’ size 20480M ,
‘/dev/oracleasm/disks/st2h18_99b’ size 20480M ,
‘/dev/oracleasm/disks/st2h15_99b’ size 20480M ,
‘/dev/oracleasm/disks/st2h13_99b’ size 20480M rebalance power 4;

等待平衡完成：
SQL> select * from v$asm_operation;

no rows selectedhttp://www.cndba.cn/redhat/article/108065

删除磁盘：http://www.cndba.cn/redhat/article/108065http://www.cndba.cn/redhat/article/108065

alter diskgroup sysdg drop disk SYSDG_0002 ;
alter diskgroup sysdg drop disk SYSDG_0003 ;
alter diskgroup sysdg drop disk SYSDG_0000 ;
alter diskgroup sysdg drop disk SYSDG_0004 ;
alter diskgroup sysdg drop disk SYSDG_0001 ;

删除完成：
SQL> r
1* select group_number,name,path,OS_MB as “size_GB” from v$asm_disk where group_number=1

GROUP_NUMBER NAME PATH size_GB

       1 SYSDG_0005                /dev/oracleasm/disks/st2h14_99b                                 1831152
       1 SYSDG_0006                /dev/oracleasm/disks/st2h16_99b                                 1831152
       1 SYSDG_0008                /dev/oracleasm/disks/st2h15_99b                                 1831152
       1 SYSDG_0007                /dev/oracleasm/disks/st2h18_99b                                 1831152
       1 SYSDG_0009                /dev/oracleasm/disks/st2h13_99b                                 1831152

创建OCR
create diskgroup ocr HIGH redundancy
failgroup OCR_FG_1 disk
‘/dev/oracleasm/disks/asmdisk0c’ name ocr_fg_01 size 20480M
failgroup OCR_FG_2 disk
‘/dev/oracleasm/disks/asmdisk0d’ name ocr_fg_02 size 20480M
failgroup OCR_FG_3 disk
‘/dev/oracleasm/disks/asmdisk0e’ name ocr_fg_03 size 20480M
failgroup OCR_FG_4 disk
‘/dev/oracleasm/disks/asmdisk0f’ name ocr_fg_04 size 20480M
failgroup OCR_FG_5 disk
‘/dev/oracleasm/disks/asmdisk10’ name ocr_fg_05 size 20480M
attribute ‘au_size’=’4M’,’compatible.asm’=’19.0’,’compatible.rdbms’=’19.0’;

创建完成：
[root@dsmdb1 ~]# srvctl start diskgroup -diskgroup ocr
srvctl start diskgroup -diskgroup ocr

准备迁移OCR和voting file

1.首先检查OCR状态：
[root@dsmdb1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84272
Available space (kbytes) : 407412
ID : 1646018297
Device/File Name : +SYSDG
Device/File integrity check succeeded

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

     Cluster registry integrity check succeeded

     Logical corruption check succeeded

如上：OCR文件都在sysdg中
2.将OCR文件添加到OCR磁盘组中：
/u01/app/19.3.0/grid/bin/ocrconfig -add +ocr
[root@dsmdb1 ~]# /u01/app/19.3.0/grid/bin/ocrconfig -add +ocr
[root@dsmdb1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84272
Available space (kbytes) : 407412
ID : 1646018297
Device/File Name : +SYSDG
Device/File integrity check succeeded
Device/File Name : +OCR
Device/File integrity check succeeded

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

     Cluster registry integrity check succeeded

     Logical corruption check succeeded

===
看到device/file 已经存在 sysdg和OCR中了。http://www.cndba.cn/redhat/article/108065

3.通过replace转移SYSDG到OCR中：http://www.cndba.cn/redhat/article/108065

/u01/app/19.3.0/grid/bin/ocrconfig -replace +sysdg -replacement +ocr

[root@dsmdb1 ~]# /u01/app/19.3.0/grid/bin/ocrconfig -replace +sysdg -replacement +OCR
PROT-29: The Oracle Cluster Registry location is already configured

4.准备迁移voting file到OCR中
检查votedisk
[root@dsmdb1 ~]# crsctl query css votedisk

STATE File Universal Id File Name Disk group

  1. ONLINE cc9a37caa0de4faabfd505d34b521583 (/dev/oracleasm/disks/st2h16_99b) [SYSDG]
  2. ONLINE 60976b27a5ec4f3cbf03100aa7f5561f (/dev/oracleasm/disks/st2h18_99b) [SYSDG]
  3. ONLINE 13771fbd3cb64ff9bfe2a09b27f11ef2 (/dev/oracleasm/disks/st2h14_99b) [SYSDG]
  4. ONLINE fd13b3e46cb44f64bfe5649d0e93c468 (/dev/oracleasm/disks/st2h15_99b) [SYSDG]
  5. ONLINE 8ebfc6d1bd484f2fbf04392a3048973f (/dev/oracleasm/disks/st2h13_99b) [SYSDG]
    Located 5 voting disk(s).

替换voting 文件到OCR中
[root@dsmdb1 ~]# crsctl query css votedisk

STATE File Universal Id File Name Disk group

  1. ONLINE cc9a37caa0de4faabfd505d34b521583 (/dev/oracleasm/disks/st2h16_99b) [SYSDG]
  2. ONLINE 60976b27a5ec4f3cbf03100aa7f5561f (/dev/oracleasm/disks/st2h18_99b) [SYSDG]
  3. ONLINE 13771fbd3cb64ff9bfe2a09b27f11ef2 (/dev/oracleasm/disks/st2h14_99b) [SYSDG]
  4. ONLINE fd13b3e46cb44f64bfe5649d0e93c468 (/dev/oracleasm/disks/st2h15_99b) [SYSDG]
  5. ONLINE 8ebfc6d1bd484f2fbf04392a3048973f (/dev/oracleasm/disks/st2h13_99b) [SYSDG]
    Located 5 voting disk(s).
    [root@dsmdb1 ~]# crsctl replace votedisk +ocr
    Successful addition of voting disk c4860f2aa6484f2ebf6e2fdd57be8cc6.
    Successful addition of voting disk 678a15bd624a4ffabf70fb7551da1107.
    Successful addition of voting disk 3fa43ddaa34d4f95bf7a8afbb1c86c94.
    Successful addition of voting disk ac5dde9e051a4f1abf42eade16deb298.
    Successful addition of voting disk 7929b0014e414f95bf8af753a65747f8.
    Successful deletion of voting disk cc9a37caa0de4faabfd505d34b521583.
    Successful deletion of voting disk 60976b27a5ec4f3cbf03100aa7f5561f.
    Successful deletion of voting disk 13771fbd3cb64ff9bfe2a09b27f11ef2.
    Successful deletion of voting disk fd13b3e46cb44f64bfe5649d0e93c468.
    Successful deletion of voting disk 8ebfc6d1bd484f2fbf04392a3048973f.
    Successfully replaced voting disk group with +ocr.
    CRS-4266: Voting file(s) successfully replaced
    [root@dsmdb1 ~]# crsctl query css votedisk

    STATE File Universal Id File Name Disk group

  1. ONLINE c4860f2aa6484f2ebf6e2fdd57be8cc6 (/dev/oracleasm/disks/asmdisk0c) [OCR]
  2. ONLINE 678a15bd624a4ffabf70fb7551da1107 (/dev/oracleasm/disks/asmdisk0d) [OCR]
  3. ONLINE 3fa43ddaa34d4f95bf7a8afbb1c86c94 (/dev/oracleasm/disks/asmdisk0e) [OCR]
  4. ONLINE ac5dde9e051a4f1abf42eade16deb298 (/dev/oracleasm/disks/asmdisk0f) [OCR]
  5. ONLINE 7929b0014e414f95bf8af753a65747f8 (/dev/oracleasm/disks/asmdisk10) [OCR]
    Located 5 voting disk(s).

替换完成，删除旧的磁盘组sysdg

/u01/app/19.3.0/grid/bin/ocrconfig -delete +sysdg http://www.cndba.cn/redhat/article/108065

[root@dsmdb1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84272
Available space (kbytes) : 407412
ID : 1646018297
Device/File Name : +SYSDG
Device/File integrity check succeeded
Device/File Name : +OCR
Device/File integrity check succeeded

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

     Cluster registry integrity check succeeded

     Logical corruption check succeeded

[root@dsmdb1 ~]#
[root@dsmdb1 ~]# /u01/app/19.3.0/grid/bin/ocrconfig -delete +sysdg
[root@dsmdb1 ~]# ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 491684
Used space (kbytes) : 84272
Available space (kbytes) : 407412
ID : 1646018297
Device/File Name : +OCR
Device/File integrity check succeeded

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

                                Device/File not configured

     Cluster registry integrity check succeeded

     Logical corruption check succeeded

-看到已经删除了旧的sysdg 磁盘组。

5.重建asm spfile,重启集群

[root@dsmdb1 ~]# su - grid
Last login: Tue Jun 14 17:24:45 CST 2022
[grid@dsmdb1 ~]$ sqlplus / as sysasmhttp://www.cndba.cn/redhat/article/108065

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jun 14 17:26:59 2022
Version 19.3.0.0.0

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

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0http://www.cndba.cn/redhat/article/108065

SQL> create pfile=’/tmp/p1’ from spfile;

File created.

SQL>
SQL> create spfile=’+ocr’ from pfile=’/tmp/p1’ ;

File created.

重启集群：两个节点都要重启：
crsctl stop crs -f
crsctl start crs

删除sysdg：
SQL> alter diskgroup sysdg dismount force ;http://www.cndba.cn/redhat/article/108065

Diskgroup altered.

SQL> drop diskgroup sysdg force including contents ;

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

OracleRAC删除就的磁盘组替换OCR

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

Anshen

关注

成功不是将来才有的，而是从决定去做的那一刻起，持续累积而成。

  • 69
    原创
  • 0
    翻译
  • 5
    转载
  • 8
    评论
  • 访问：287121次
  • 积分：326
  • 等级：中级会员
  • 排名：第13名
精华文章

    达梦数据库运维实战

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

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

        QQ交流群

        注册联系QQ