eygle.com   eygle.com
eygle.com  
 

« February 16, 2006 | Blog首页 | February 18, 2006 »


February 17, 2006

EMC CX500最后一次扩容

作者:eygle

出处:http://blog.eygle.com

昨天将公司的EMC CX500进行了最后一次扩容.

自此,此存储容量已达12T, 7个FC DAE Enclosure 一个 ATA Enclosure, EMC CX500满配.

bash-2.03# navicli -h 172.16.9.5 getloop -conn
Connection #                  0: Enclosure 0
Connection #                  1: Enclosure 1
Connection #                  2: Enclosure 2
Connection #                  3: Enclosure 3
Connection #                  4: Bus 1 Enclosure 0
Connection #                  5: Bus 1 Enclosure 1
Connection #                  6: Bus 1 Enclosure 2
Connection #                  7: Bus 1 Enclosure 3 

EMC在过去的一年内,没少出故障,主要是硬盘损坏,SP出过一次故障,还好没有影响业务.

希望在2006年,EMC给我少找点麻烦.

Posted by eygle at 5:25 PM | Comments (8)

Oracle10g ASM Auto IO Rebalance新特性

作者:eygle

出处:http://blog.eygle.com

ASM ( Automatic Storage Management ) 的一个重要特性是可以进行在线磁盘重配置及动态均衡。

当我们向已有磁盘组中增加磁盘后，Oracle会自动进行IO均衡,为了完成这个任务，Oracle引入了一个新的后台进程：

[oracle@danaly ~]$ ps -ef|grep ora_rbal*
oracle    3815     1  0 Jan23 ?        00:00:01 ora_rbal_danaly
oracle   31601 23407  0 14:33 pts/2    00:00:00 grep ora_rbal* 

这个进程用来进行IO均衡。

IO调整是自动进行的，并且这个平衡速度是可以控制的。

Oracle通过一个新增的参数:asm_power_limit 来控制速度。
该参数取值范围为1~11,参数值越大平衡速度越快。

Oracle文档对该参数解释为:

ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but consume fewer processing and I/O resources.

If the POWER clause of a rebalance operation is not specified, then the default power will be the value of ASM_POWER_LIMIT.

 该参数缺省值为1:

SQL> show parameter power
NAME                                 TYPE                   VALUE
------------------------------------ ---------------------- ----------------
asm_power_limit                      integer                1
 

该参数也可以在增加磁盘时指定: 

SQL> alter diskgroup ORADG add disk 'ORCL:VOL6' rebalance power 11;
Diskgroup altered. 

我们可以看一下，最初我的磁盘使用情况为: 

SQL> select name,total_mb,free_mb from v$asm_disk;
NAME                   TOTAL_MB    FREE_MB
-------------------- ---------- ----------
                           2870          0
VOL1                      19077       6571
VOL2                      19077       6497
VOL3                      19077       6558
VOL4                      12228       4321
VOL6                     104187      97622
6 rows selected. 

经过Oracle的自动调整均衡之后，磁盘空间使用情况变为:

SQL> select name,total_mb,free_mb from v$asm_disk;
NAME                   TOTAL_MB    FREE_MB
-------------------- ---------- ----------
                           2870          0
VOL1                      19077      13337
VOL2                      19077      13381
VOL3                      19077      13337
VOL4                      12228       8548
VOL6                     104187      72966
6 rows selected. 

ASM在存储管理上实在是给我们带来了更多的便利之处。 

参考文档:

扩展Oracle10gR2 ASM磁盘空间

How to Use Oracle10g release 2 ASM

Posted by eygle at 2:04 PM | Comments (0)

扩展Oracle10gR2 ASM磁盘空间

作者:eygle

出处:http://blog.eygle.com

一个Linux AD4上的Oracle10gR2数据库,由于空间不足,扩展了一下硬盘,增加100G做为数据库存储.

在ASM中,可以使用如下类似步骤将存储加入到ASM磁盘组中.

1.确认候选磁盘

此处为/dev/cciss/c0d2p2

[root@danaly /]# fdisk /dev/cciss/c0d2
The number of cylinders for this disk is set to 52299.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
   (e.g., DOS FDISK, OS/2 FDISK)
Command (m for help): p
Disk /dev/cciss/c0d2: 218.5 GB, 218501038080 bytes
255 heads, 32 sectors/track, 52299 cylinders
Units = cylinders of 8160 * 512 = 4177920 bytes
           Device Boot      Start         End      Blocks   Id  System
/dev/cciss/c0d2p1               1       26150   106691984   83  Linux
/dev/cciss/c0d2p2           26151       52299   106687920   83  Linux
Command (m for help): q 

2.使用ASM创建磁盘卷

[root@danaly /]# /etc/init.d/oracleasm createdisk VOL6 /dev/cciss/c0d2p2
Marking disk "/dev/cciss/c0d2p2" as an ASM disk: [  OK  ]
[root@danaly /]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4
VOL5
VOL6 

3.在ASM实例中加入磁盘

SQL> select name,TOTAL_MB,FREE_MB from v$asm_diskgroup;
NAME         TOTAL_MB    FREE_MB
---------- ---------- ----------
ORADG           69459      17384
SQL> alter diskgroup ORADG add disk 'ORCL:VOL6' rebalance power 11;
Diskgroup altered.
SQL> select group_number,disk_number,mode_status,name from v$asm_disk;
GROUP_NUMBER DISK_NUMBER MODE_STATUS    NAME
------------ ----------- -------------- ----------
           0           4 ONLINE
           1           0 ONLINE         VOL1
           1           1 ONLINE         VOL2
           1           2 ONLINE         VOL3
           1           3 ONLINE         VOL4
           1           4 ONLINE         VOL6
6 rows selected.
SQL> select name,TOTAL_MB,FREE_MB from v$asm_diskgroup;
NAME         TOTAL_MB    FREE_MB
---------- ---------- ----------
ORADG          173646     121569 

至此扩展完毕.

以上步骤仅供参考.

更详细内容还可以参考:

How to Use Oracle10g release 2 ASM

 

 

Posted by eygle at 10:39 AM | Comments (0)

CopyRight © 2004-2008 eygle.com, All rights reserved.