您的位置: 旅游网 > 情感

扩展Oracle10gR2 ASM磁盘空间

发布时间:2019-12-04 22:03:44

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

查看本文来源

北京国济中医医院怎么样
宿迁市工人医院预约挂号
吉林好的妇科医院
长春专治癫痫病医院哪家好
贵州治疗睾丸炎费用
猜你会喜欢的
猜你会喜欢的