Oracle数据库ASM管理-华为闪存添加ASM存储实践1

最新推荐文章于 2023-11-28 17:00:12 发布

执笔画情ora

最新推荐文章于 2023-11-28 17:00:12 发布

阅读量694

点赞数

分类专栏： ORACLE数据库ASM存储管理 ORACLE数据库RAC管理

本文链接：https://blog.csdn.net/oradbm/article/details/116491892

版权

ORACLE数据库RAC管理同时被 2 个专栏收录

133 篇文章 5 订阅

订阅专栏

ORACLE数据库ASM存储管理

22 篇文章 0 订阅

订阅专栏

1 在存储管理软件中为主机添加4T存储。

2 使用hot_add命令进行更新存储信息。

存储信息如下

[root@gzrac01 ~]# upadmin

UltraPath CLI #0 >show vlun
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Vlun ID Disk Name Lun WWN Status Capacity Ctrl(Own/Work) Array Name Dev Lun ID No. of Paths(Available/Total)
0 sdb orcl_ocr 6cc64a61003266da1b04fe0200000012 Normal 100.00GB --/-- TianJin.Yidong.Huawei.S 18 4/4
1 sdc orcl_arch 6cc64a61003266da1b04fefc00000013 Normal 900.00GB --/-- TianJin.Yidong.Huawei.S 19 4/4
2 sdd orcl_oradata1 6cc64a61003266da1b05001100000014 Normal 2.00TB --/-- TianJin.Yidong.Huawei.S 20 4/4
3 sde orcl_oradata2 6cc64a61003266da1b05328900000015 Normal 2.00TB --/-- TianJin.Yidong.Huawei.S 21 4/4
4 sdf orcl_oradata3 6cc64a61003266da1b06315300000016 Normal 2.00TB --/-- TianJin.Yidong.Huawei.S 22 4/4
5 sdg orcl_oradata4 6cc64a61003266da1b06434900000017 Normal 2.00TB --/-- TianJin.Yidong.Huawei.S 23 4/4
6 sdh mgmt 6cc64a61003266da201f26c80000001a Normal 100.00GB --/-- TianJin.Yidong.Huawei.S 26 4/4
7 sdi redo 6cc64a61003266da201f2ff00000001b Normal 100.00GB --/-- TianJin.Yidong.Huawei.S 27 4/4
8 sdj orcl-backup0000 6cc64a61003266da698d2f6b00000006 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 6 4/4
9 sdk orcl-backup0001 6cc64a61003266da698d2fde00000007 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 7 4/4
10 sdl orcl-backup0002 6cc64a61003266da698d306f00000008 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 8 4/4
11 sdm orcl-backup0003 6cc64a61003266da698d30f800000009 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 9 4/4
12 sdn orcl-backup0004 6cc64a61003266da698d317e0000000a Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 10 4/4
13 sdo orcl-backup0005 6cc64a61003266da698d31f90000000b Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 11 4/4
14 sdp orcl-backup0006 6cc64a61003266da698d32760000000c Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 12 4/4
15 sdq orcl-backup0007 6cc64a61003266da698d33040000000d Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 13 4/4
16 sdr orcl-backup0008 6cc64a61003266da698d33840000000e Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 14 4/4
17 sds orcl_oradata5 6cc64a61003266da91e50e5e00000037 Normal 2.00TB --/-- TianJin.Yidong.Huawei.S 55 4/4
18 sdt orcl_oradata6 6cc64a61003266da91e52a6800000038 Normal 2.00TB --/-- TianJin.Yidong.Huawei.S 56 4/4
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

UltraPath CLI #1 >

3 使用fdisk命令对sds和sdt进行分盘

4 使用oracleasm创建asm磁盘

[root@gzrac01 ~]# oracleasm createdisk data10 /dev/sds1
Writing disk header: done
Instantiating disk: done
[root@gzrac01 ~]# oracleasm createdisk data11 /dev/sds2
Writing disk header: done
Instantiating disk: done
[root@gzrac01 ~]# oracleasm createdisk data12 /dev/sdt1
Writing disk header: done
Instantiating disk: done
[root@gzrac01 ~]# oracleasm createdisk data13 /dev/sdt2
Writing disk header: done
Instantiating disk: done

oracleasm scandisks
oracleasm listdisks

5 创建ASM磁盘组

一个插曲，之前创建的 ASM磁盘组均为 AU大小为4MB，但是创建脚本采用了默认的1M。切磁盘组添加了数据

create diskgroup dgdata6
external redundancy
disk '/dev/oracleasm/disks/DATA12','/dev/oracleasm/disks/DATA13';

create diskgroup dgdata5
external redundancy
disk '/dev/oracleasm/disks/DATA10','/dev/oracleasm/disks/DATA11';

[grid@gzrac02 ~]$ srvctl start diskgroup -diskgroup dgdata5
[grid@gzrac02 ~]$ srvctl start diskgroup -diskgroup dgdata6

ALTER TABLESPACE HPM1 ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1 ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1 ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1 ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1 ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;

6 查看数据库配置信息

[grid@gzrac02 ~]$ srvctl config database -d wyzxdb -a
Database unique name: wyzxdb
Database name: wyzxdb
Oracle home: /u01/app/oracle/product/19.3/db_1
Oracle user: oracle
Spfile: +DGDATA4/WYZXDB/PARAMETERFILE/spfile.291.1038929443
Password file: +DGDATA4/WYZXDB/PASSWORD/pwdwyzxdb.275.1038924359
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DGDATA4,DGDATA3,DGARCH,DGDATA1,DGDATA2,DGDATA5
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
Database is enabled
Database is individually enabled on nodes:
Database is individually disabled on nodes:
OSDBA group: dba
OSOPER group: oper
Database instances: wyzxdb1,wyzxdb2
Configured nodes: gzrac01,gzrac02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed

7 重建 DISKGROUP6

节点2 dismount dgdata6；
节点1 drop diskgroup dgdata6；

create diskgroup dgdata6
external redundancy
disk '/dev/oracleasm/disks/DATA12','/dev/oracleasm/disks/DATA13' attribute 'compatible.asm'='19.0.0.0.0','compatible.rdbms'='10.1.0.0.0','AU_SIZE'='4M';

Diskgroup created.

8 将DGDATA5上面的文件迁移到DGDATA6;

#####388号数据文件原始位置。
[grid@gzrac02 ~]$ asmcmd
ASMCMD> ls -lrt +DGDATA5/WYZXDB/AB2C32F4BDDCF4DBE05304E0E40AD62B/DATAFILE/hpmdbs2.261.1071850971
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'

Type Redund Striped Time Sys Name
DATAFILE UNPROT COARSE MAY 06 16:00:00 Y hpmdbs2.261.1071850971
ASMCMD>

[oracle@gzrac01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Thu May 6 16:54:46 2021
Version 19.8.0.0.0

Copyright (c) 1982, 2020, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0

SQL> alter session set container=tjnpm;

Session altered.

SQL> ALTER DATABASE MOVE DATAFILE 388 TO '+DGDATA6';

ASMCMD> ls -lrt +DGDATA5/WYZXDB/AB2C32F4BDDCF4DBE05304E0E40AD62B/DATAFILE/hpmdbs2.261.1071850971
WARNING:option 'r' is deprecated for 'ls'
please use 'reverse'

ASMCMD-8002: entry 'hpmdbs2.261.1071850971' does not exist in directory '+DGDATA5/WYZXDB/AB2C32F4BDDCF4DBE05304E0E40AD62B/DATAFILE/'
ASMCMD>

move完成后文件已经不存在。

select 'ALTER DATABASE move DATAFILE '||FILE_ID||' TO '||Q'('+DGDATA6';)' From dba_Data_files where file_name like '%DGDATA5%';

ALTER DATABASE move DATAFILE 384 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 385 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 386 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 387 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 389 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 390 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 391 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 392 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 393 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 394 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 395 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 396 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 397 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 398 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 399 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 400 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 401 TO '+DGDATA6';
ALTER DATABASE move DATAFILE 402 TO '+DGDATA6';

[grid@gzrac01 ~]$ asmcmd
ASMCMD> ls
DGARCH/
DGDATA1/
DGDATA2/
DGDATA3/
DGDATA4/
DGDATA5/
DGDATA6/
DGOCR/
MGMT/
REDO/
ASMCMD> cd DGDATA5/
ASMCMD> ls
ASMCMD>

节点2 dismount dgdata5
节点1 drop dgdata5
SQL> alter diskgroup dgdata5 mount;
SQL> drop diskgroup dgdata5 including contents;

重建dgdata5
create diskgroup dgdata5
external redundancy
disk '/dev/oracleasm/disks/DATA10','/dev/oracleasm/disks/DATA11' attribute 'compatible.asm'='19.0.0.0.0','compatible.rdbms'='10.1.0.0.0','AU_SIZE'='4M';

执笔画情ora

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
Oracle数据库ASM管理-华为闪存添加ASM存储实践1

1 在存储管理软件中为主机添加4T存储。2 使用hot_add命令进行更新存储信息。存储信息如下[root@gzrac01 ~]# upadminUltraPath CLI #0 >show vlun----------------------------------------------------------------------------------------------------------------------------------------------
复制链接

扫一扫

专栏目录