当前使用了28块800G的SAS SSD。
昨晚,往使用了17T的DG中添加2个1.5T的LUN,从开始到ASM rebalance完成,总共耗时3小时(以前测试的Exadata 1/4配置,加载纯LOB对象,也是1小时1T,当时也感觉很震撼……),速度很快啊,记录一下,O(∩_∩)O哈哈~:
[grid@lunardb1 ~]$ asmcmd ASMCMD> lsdg State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name MOUNTED EXTERN N 512 4096 1048576 3072390 2803853 0 2803853 0 N ARCHDG/ MOUNTED EXTERN Y 512 4096 1048576 23040000 4766148 0 4766148 0 N DATA/ MOUNTED EXTERN N 512 4096 1048576 3072 2676 0 2676 0 Y OCR_VOTE/ MOUNTED EXTERN N 512 4096 1048576 614400 614183 0 614183 0 N REDODG/ ASMCMD> exit Thu Sep 25 18:42:33 2014 SQL> ALTER DISKGROUP DATA ADD DISK '/dev/lunardatalun14' SIZE 1536000M , '/dev/lunardatalun15' SIZE 1536000M /* ASMCA */ NOTE: GroupBlock outside rolling migration privileged region NOTE: Assigning number (2,13) to disk (/dev/lunardatalun14) NOTE: Assigning number (2,14) to disk (/dev/lunardatalun15) NOTE: requesting all-instance membership refresh for group=2 NOTE: initializing header on grp 2 disk DATA_0013 NOTE: initializing header on grp 2 disk DATA_0014 NOTE: requesting all-instance disk validation for group=2 Thu Sep 25 18:42:37 2014 NOTE: skipping rediscovery for group 2/0x5ffb2459 (DATA) on local instance. NOTE: requesting all-instance disk validation for group=2 NOTE: skipping rediscovery for group 2/0x5ffb2459 (DATA) on local instance. NOTE: initiating PST update: grp = 2 Thu Sep 25 18:42:41 2014 GMON updating group 2 at 17 for pid 27, osid 97661 NOTE: PST update grp = 2 completed successfully NOTE: membership refresh pending for group 2/0x5ffb2459 (DATA) GMON querying group 2 at 18 for pid 18, osid 85811 NOTE: cache opening disk 13 of grp 2: DATA_0013 path:/dev/lunardatalun14 NOTE: cache opening disk 14 of grp 2: DATA_0014 path:/dev/lunardatalun15 NOTE: Attempting voting file refresh on diskgroup DATA GMON querying group 2 at 19 for pid 18, osid 85811 SUCCESS: refreshed membership for 2/0x5ffb2459 (DATA) Thu Sep 25 18:42:45 2014 SUCCESS: ALTER DISKGROUP DATA ADD DISK '/dev/lunardatalun14' SIZE 1536000M , '/dev/lunardatalun15' SIZE 1536000M /* ASMCA */ NOTE: starting rebalance of group 2/0x5ffb2459 (DATA) at power 1 Starting background process ARB0 Thu Sep 25 18:42:45 2014 ARB0 started with pid=40, OS id=97872 NOTE: assigning ARB0 to group 2/0x5ffb2459 (DATA) with 1 parallel I/O Thu Sep 25 18:42:48 2014 NOTE: Attempting voting file refresh on diskgroup DATA Thu Sep 25 19:15:00 2014 SQL> alter diskgroup data rebalance power 11 NOTE: GroupBlock outside rolling migration privileged region Thu Sep 25 19:15:00 2014 NOTE: stopping process ARB0 NOTE: rebalance interrupted for group 2/0x5ffb2459 (DATA) NOTE: requesting all-instance membership refresh for group=2 NOTE: membership refresh pending for group 2/0x5ffb2459 (DATA) Thu Sep 25 19:15:07 2014 GMON querying group 2 at 20 for pid 18, osid 85811 SUCCESS: refreshed membership for 2/0x5ffb2459 (DATA) SUCCESS: alter diskgroup data rebalance power 11 NOTE: starting rebalance of group 2/0x5ffb2459 (DATA) at power 11 Starting background process ARB0 Thu Sep 25 19:15:07 2014 ARB0 started with pid=28, OS id=111465 NOTE: assigning ARB0 to group 2/0x5ffb2459 (DATA) with 11 parallel I/Os Thu Sep 25 19:15:15 2014 NOTE: Attempting voting file refresh on diskgroup DATA Thu Sep 25 20:30:47 2014 NOTE: GroupBlock outside rolling migration privileged region NOTE: requesting all-instance membership refresh for group=2 Thu Sep 25 20:30:50 2014 NOTE: membership refresh pending for group 2/0x5ffb2459 (DATA) Thu Sep 25 20:30:53 2014 GMON querying group 2 at 21 for pid 18, osid 85811 SUCCESS: refreshed membership for 2/0x5ffb2459 (DATA) NOTE: Attempting voting file refresh on diskgroup DATA Thu Sep 25 21:45:28 2014 NOTE: stopping process ARB0 SUCCESS: rebalance completed for group 2/0x5ffb2459 (DATA)
rebalance的速度,是和dg中的数据文件大小有关还是和segment对象的大小有关? 求指导!