eygle.com   eygle.com
eygle.com  
 

« 网络和自由-言论两则 | Blog首页 | Oracle10g ASM Auto IO Rebalance新特性 »

扩展Oracle10gR2 ASM磁盘空间

作者:eygle |【转载时请以超链接形式标明文章和作者信息及本声明
链接:

一个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

 

 


历史上的今天...
      >> 2009-02-17文章:
      >> 2008-02-17文章:
      >> 2007-02-17文章:
             新年快乐-百度已至 谷歌未达
      >> 2005-02-17文章:
------
这篇 【扩展Oracle10gR2 ASM磁盘空间】来自 eygle.com | CSDN网摘| del.icio.us|Google订阅 | 鲜果订阅 | 抓虾订阅

By eygle on 2006-02-17 10:39 | Comments (0) | Posted to Oracle10g/11g | Edit |

相关文章 随机文章
  • 10g New Feature:MAXTRANS参数已经废弃
  • 20090811-墨墨、书书、Oracle
  • 如何 DUMP ASH 信息至跟踪文件
  • Oracle收购GoldenGate - 甲骨文到底想做什么
  • 10g Profile FAILED_LOGIN_ATTEMPTS如何计数?
  • What's Mean "reliable message"?
    樱桃红时 - 记北京白家疃采摘
    支持国货 拒绝互联
    决心修订《深入浅出Oracle》一书
    Baby病了
    搜索本站:

    Listed below are links to weblogs that reference 扩展Oracle10gR2 ASM磁盘空间:

    » Oracle10g ASM Auto IO Rebalance新特性 from Friends Life and Oracle
    ASM ( Automatic Storage Management ) 的一个重要特性是可以进行在线磁盘重配置及动态均衡。 [Read More]

    Tracked on February 17, 2006 2:53 PM

    留言 (0)

    发表留言:



    Remember Me?
    (输入验证码后方可评论,谢谢支持)



    CopyRight © 2004~2010 eygle.com, All rights reserved.