ITPub博客

首页 > Linux操作系统 > Linux操作系统 > solaris 10_oracle asm_diskgroup_failgroup_相关

solaris 10_oracle asm_diskgroup_failgroup_相关

原创 Linux操作系统 作者:wisdomone1 时间:2009-11-25 19:57:55 0 删除 编辑

SQL> create diskgroup dg8 normal redundancy   --构建一个二向镜像磁盘组(就是两个failgroup)
  2  failgroup fg1 disk   ---failgroup可以不加,系统会自动生成一个名字
  3  '/dev/rdsk/c0d1s5' name fg1_d1  ---磁盘的名字
  4  failgroup fg2 disk
  5  '/dev/rdsk/c0d1s6' name fg2_d2;

Diskgroup created.


SQL> select group_number,name from v$asm_diskgroup;

GROUP_NUMBER NAME
------------ ------------------------------
           1 DATA
           2 ARCH
           3 DG8

SQL> select name,path,failgroup from v$asm_disk where group_number=3;

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
FG1_D1
/dev/rdsk/c0d1s5
FG1

FG2_D2
/dev/rdsk/c0d1s6
FG2

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------


SQL> drop diskgroup dg8 including contents;

Diskgroup dropped.


SQL> create diskgroup dg8 normal redundancy  --不加failgroup和nama构建磁盘组,同样成功
  2  disk '/dev/rdsk/c0d1s5'
  3  disk '/dev/rdsk/c0d1s6';

Diskgroup created.

SQL> select group_number from v$asm_diskgroup where name='DG8';

GROUP_NUMBER
------------
           3

SQL> select name,path,failgroup from v$asm_disk where group_number=3;---查看不加failgroup和name的磁盘组

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
DG8_0000
/dev/rdsk/c0d1s5
DG8_0000

DG8_0001
/dev/rdsk/c0d1s6
DG8_0001

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------


SQL> alter diskgroup dg8 drop disks in failgroup dg8_0000; ---删除磁盘组中一个failgroup的disk

Diskgroup altered.




SQL> select path,name,mount_status from v$asm_disk;

PATH
--------------------------------------------------------------------------------
NAME                           MOUNT_S
------------------------------ -------
/dev/rdsk/c0d1s0
                               CLOSED

/dev/rdsk/c0d1s7
                               CLOSED

/dev/rdsk/c0d1s3
                               CLOSED


PATH
--------------------------------------------------------------------------------
NAME                           MOUNT_S
------------------------------ -------
/dev/rdsk/c1d1s0
                               CLOSED

/dev/rdsk/c1d1s1
                               CLOSED

/dev/rdsk/c0d1s1
DATA_0000                      CACHED


PATH
--------------------------------------------------------------------------------
NAME                           MOUNT_S
------------------------------ -------
/dev/rdsk/c0d1s4
ARCH_0000                      CACHED

/dev/rdsk/c0d1s5
DG8_0000                       CACHED

/dev/rdsk/c0d1s6
DG8_0001                       CACHED


9 rows selected.


SQL> alter diskgroup dg8 add failgroup fg3 disk '/dev/rdsk/c0d1s3';---为磁盘组添加failgroup

Diskgroup altered.

SQL> select name,path,failgroup from v$asm_disk where group_number=3;

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------
DG8_0002
/dev/rdsk/c0d1s3
FG3

DG8_0001
/dev/rdsk/c0d1s6
DG8_0001

NAME
------------------------------
PATH
--------------------------------------------------------------------------------
FAILGROUP
------------------------------


SQL> alter diskgroup dg8 resize disks in failgroup fg3 size 20m; --对磁盘组中一个failgroup重定义大小

Diskgroup altered.

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-620563/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
提供针对oracle初学者及进阶的数据库培训,欢迎大家咨询: 微信: wisdomone 微信公众号: lovedb 工作经历: 中国普天 北京科蓝 北京云和恩墨 北京神州新桥

注册时间:2008-04-04

  • 博文量
    2189
  • 访问量
    12689906