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 NameDev Lun ID No. of Paths(Available/Total)
0 sdb orcl_ocr 6cc64a61003266da1b04fe0200000012 Normal 100.00GB--/-- TianJin.Yidong.Huawei.S 184/4
1 sdc orcl_arch 6cc64a61003266da1b04fefc00000013 Normal 900.00GB--/-- TianJin.Yidong.Huawei.S 194/4
2 sdd orcl_oradata1 6cc64a61003266da1b05001100000014 Normal 2.00TB--/-- TianJin.Yidong.Huawei.S 204/4
3 sde orcl_oradata2 6cc64a61003266da1b05328900000015 Normal 2.00TB--/-- TianJin.Yidong.Huawei.S 214/4
4 sdf orcl_oradata3 6cc64a61003266da1b06315300000016 Normal 2.00TB--/-- TianJin.Yidong.Huawei.S 224/4
5 sdg orcl_oradata4 6cc64a61003266da1b06434900000017 Normal 2.00TB--/-- TianJin.Yidong.Huawei.S 234/4
6 sdhmgmt6cc64a61003266da201f26c80000001a Normal 100.00GB--/-- TianJin.Yidong.Huawei.S 264/4
7 sdiredo6cc64a61003266da201f2ff00000001b Normal 100.00GB--/-- TianJin.Yidong.Huawei.S 274/4
8 sdj orcl-backup0000 6cc64a61003266da698d2f6b00000006 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 64/4
9 sdk orcl-backup0001 6cc64a61003266da698d2fde00000007 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 74/4
10 sdl orcl-backup0002 6cc64a61003266da698d306f00000008 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 84/4
11 sdm orcl-backup0003 6cc64a61003266da698d30f800000009 Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 94/4
12 sdn orcl-backup0004 6cc64a61003266da698d317e0000000a Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 104/4
13 sdo orcl-backup0005 6cc64a61003266da698d31f90000000b Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 114/4
14 sdp orcl-backup0006 6cc64a61003266da698d32760000000c Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 124/4
15 sdq orcl-backup0007 6cc64a61003266da698d33040000000d Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 134/4
16 sdr orcl-backup0008 6cc64a61003266da698d33840000000e Normal 1932735283.00KB --/-- TianJin.Yidong.Huawei.S 144/4
17 sds orcl_oradata5 6cc64a61003266da91e50e5e00000037 Normal 2.00TB--/-- TianJin.Yidong.Huawei.S 554/4
18 sdt orcl_oradata6 6cc64a61003266da91e52a6800000038 Normal 2.00TB--/-- TianJin.Yidong.Huawei.S 564/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 HPM1ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1 ADD DATAFILE '+DGDATA5' SIZE 30G autoextend off;
ALTER TABLESPACE HPM1ADD 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
Version 19.8.0.0.0
Copyright (c) 1982, , 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';