oracle的asm下扩容表空间,oracle12c下rac扩容asm存储
oracle的asm下扩容表空间,oracle12c下rac扩容asm存储1rac扩容asm存储
基本思路：
氮气的用途第⼀步：通过multipath  -ll命令到 要加载的共享磁盘
第⼆步：将到的共享盘，添加到绑定⽂件中(/etc/udev/rules.d/99-oracle.rules)
第三部：su – grid  sqlplus  “/as sysasm”添加到数据库磁盘组中。
create
diskgroup data_dg25t external redundancy disk'/dev/data-disk05-2.5t';
multipath
-ll
grid⽤户
create
diskgroup data_dg25t external redundancy disk'/dev/data-disk05-2.5t';
1.1具体添加过程
1.1.1第⼀步：查系统要添加的共享盘
[root@inmdb04
~]# multipath -ll
mpathp
(3600000e00d100000001007f4004f0000) dm-4 FUJITSU,ETERNUS_DX400
size=1000G
features='0' hwhandler='0' wp=rw
`-+-
policy='round-robin 0' prio=1 status=active
`- 3:0:0:14 sdp 8:240 active ready running
mpatho
(3600000e00d100000001007f4004d0000) dm-2 FUJITSU,ETERNUS_DX400
size=1000G
features='0' hwhandler='0' wp=rw
`-+-
policy='round-robin 0' prio=1 status=active
`- 3:0:0:12 sdn 8:208 active ready running
3600000e00d100000001007f400100000
dm-6 FUJITSU,ETERNUS_DX400
size=2.4T
features='0' hwhandler='0' wp=rw
`-+-
policy='round-robin 0' prio=1 status=enabled
`- 3:0:0:9
sdk 8:160 failed ready running
mpathn
(3600000e00d100000001007f4004e0000) dm-3 FUJITSU,ETERNUS_DX400 size=1000G
features='0' hwhandler='0' wp=rw
`-+-
policy='round-robin 0' prio=1 status=active
`- 3:0:0:13 sdo 8:224 active ready running
mpatha
(3600605b0073a96901c63704a1a11425f) dm-5 IBM,ServeRAID M5015
size=557G
features='0' hwhandler='0' wp=rw
`-+-
policy='round-robin 0' prio=1 status=active
`- 0:2:0:0
sda 8:0  active ready running
mpathm
(3600000e00d100000001007f4000e0000) dm-0 FUJITSU,ETERNUS_DX400 size=1000G
features='0' hwhandler='0' wp=rw
`-+-
policy='round-robin 0' prio=1 status=active
`- 3:0:0:10 sdl 8:176 active ready running
3600000e00d100000001007f400110000
dm-7 FUJITSU,ETERNUS_DX400
size=2.4T
features='0' hwhandler='0' wp=rw励志人生的正能量句子
`-+-
policy='round-robin 0' prio=1 status=enabled
`- 3:0:0:8
sdj 8:144 failed ready running
mpathl
(3600000e00d100000001007f4000f0000) dm-1 FUJITSU,ETERNUS_DX400 size=1000G
features='0' hwhandler='0' wp=rw
`-+-
policy='round-robin 0' prio=1 status=active
`- 3:0:0:11 sdm 8:192 active ready running
[root@inmdb04
~]#
智慧线简化为：
[root@inmdb04
~]# multipath -ll
mpathp
(3600000e00d100000001007f4004f0000) dm-4 FUJITSU,ETERNUS_DX400 size=1000G
大马哈鱼籽的做法features='0' hwhandler='0' wp=rw
mpatho
(3600000e00d100000001007f4004d0000) dm-2 FUJITSU,ETERNUS_DX400 size=1000G
features='0' hwhandler='0' wp=rw
mpathn
(3600000e00d100000001007f4004e0000) dm-3 FUJITSU,ETERNUS_DX400 size=1000G
features='0' hwhandler='0' wp=rw
mpathm
(3600000e00d100000001007f4000e0000) dm-0 FUJITSU,ETERNUS_DX400 size=1000G
features='0' hwhandler='0' wp=rw
mpathl
(3600000e00d100000001007f4000f0000) dm-1 FUJITSU,ETERNUS_DX400 size=1000G
features='0' hwhandler='0' wp=rw
要添加的是五个盘：
(3600000e00d100000001007f4004f0000)
mpatho
(3600000e00d100000001007f4004d0000)
金融管理专业mpathn
(3600000e00d100000001007f4004e0000)
mpathm
(3600000e00d100000001007f4000e0000)
mpathl
(3600000e00d100000001007f4000f0000)
1.1.4添加到系统数据盘组中
alter
diskgroup data_dg add disk '/dev/data-disk05';
alter
diskgroup data_dg add disk '/dev/data-disk06';
alter
diskgroup data_dg add disk '/dev/data-disk07';
alter
diskgroup data_dg add disk '/dev/data-disk08';
alter
diskgroup data_dg add disk '/dev/data-disk09';
具体操作过程：
[grid@inmdb03
~]$ sqlplus "/as sysasm"
SQL*Plus:
Release 12.1.0.2.0 Production on Tue Nov 1 18:28:06 2016
Copyright
爱老公(c) 1982, 2014, Oracle.  All rights reserved.
Connected
to:
Oracle
Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the
Real Application Clusters and Automatic Storage Management options
alter diskgroup data_dg add disk '/dev/data-disk05';
Diskgroup
altered.
SQL>
alter diskgroup data_dg add disk '/dev/data-disk06';
Diskgroup
altered.
SQL>
select name,TOTAL_MB ,FREE_MB ,round((TOTAL_MB-FREE_MB)/TOTAL_MB*100,2) used_percent from v$asm_diskgroup order by used_percent desc ;
NAME                        TOTAL_MB    FREE_MB USED_PERCENT
------------------------------
---------- ---------- ------------
OCR_DG                                15360    5432
64.64
DATA_DG                    6242304
2395221          61.63
FRA_DG                        1048576
583997          44.31
SQL>
alter diskgroup data_dg add disk '/dev/data-disk07';
Diskgroup
altered.
SQL>
SQL> alter diskgroup data_dg add disk '/dev/data-disk08';
Diskgroup
altered.
SQL>
alter diskgroup data_dg add disk '/dev/data-disk09';
Diskgroup
altered.
SQL>
select name,TOTAL_MB ,FREE_MB ,round((TOTAL_MB-FREE_MB)/TOTAL_MB*100,2)

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。