暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

create asm group

原创 逆风飞翔 2021-08-30
315

select t.“GROUP_NUMBER” ,name,path from v$asm_disk t;

create diskgroup ORAFLASH external redundancy
disk ‘/dev/asm-oraflush01’ name ORAFLASH_0000;
alter diskgroup ORAFLASH add disk ‘/dev/asm-oraflush02’ name ORAFLASH_0001;
alter diskgroup ORAFLASH add disk ‘/dev/asm-oraflush03’ name ORAFLASH_0002;

alter diskgroup ORAFLASH dismount;
alter diskgroup ARCH mount;

drop diskgroup ARCH;
drop diskgroup ORADATA ;
drop diskgroup ORAIMAGE;

create diskgroup ORADATA external redundancy
disk ‘/dev/asm-oradata01’ name ORADATA_0000;
alter diskgroup ORADATA add disk ‘/dev/asm-oradata02’ name ORADATA_0001;
alter diskgroup ORADATA add disk ‘/dev/asm-oradata03’ name ORADATA_0002;

create diskgroup ARCH external redundancy
disk ‘/dev/mapper/asm-disk0040’ name ORADATA_0000;

alter diskgroup ARCH add disk ‘/dev/mapper/asm-disk0039’ name ORADATA_0001;
alter diskgroup ARCH add disk ‘/dev/asm-arch03’ name ARCH_0002;

create diskgroup ORADATA normal redundancy
disk ‘/dev/asm-oradata01’ name ORADATA_0000
failgroup ORADATA_fg1 disk ‘/dev/asm-oradata02’ name ORADATA_0001
failgroup ORADATA_fg2 disk ‘/dev/asm-oradata03’ name ORADATA_0002;

create diskgroup ORAFLASH normal redundancy
disk ‘/dev/asm-oraflush01’ name ORAFLASH_0000
failgroup ORAFLASH_fg1 disk ‘/dev/asm-oraflush02’ name ORAFLASH_0001
failgroup ORAFLASH_fg2 disk ‘/dev/asm-oraflush03’ name ORAFLASH_0002;

create diskgroup ARCH normal redundancy
disk ‘/dev/asm-arch01’ name ARCH_0000
failgroup ARCH_fg1 disk ‘/dev/asm-arch02’ name ARCH_0001
failgroup ARCH_fg2 disk ‘/dev/asm-arch03’ name ARCH_0002;

create diskgroup ORAIMAGE external redundancy
disk ‘/dev/asm-oraimage01’ name ORAIMAGE_00000;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage01’ name ORAIMAGE_00001;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage02’ name ORAIMAGE_00002;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage03’ name ORAIMAGE_00003;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage04’ name ORAIMAGE_00004;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage05’ name ORAIMAGE_00005;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage06’ name ORAIMAGE_00006;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage07’ name ORAIMAGE_00007;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage08’ name ORAIMAGE_00008;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage09’ name ORAIMAGE_00009;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage10’ name ORAIMAGE_000010;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage11’ name ORAIMAGE_000011;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage12’ name ORAIMAGE_000012;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage13’ name ORAIMAGE_000013;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage14’ name ORAIMAGE_000014;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage15’ name ORAIMAGE_000015;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage16’ name ORAIMAGE_000016;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage17’ name ORAIMAGE_000017;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage18’ name ORAIMAGE_000018;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage19’ name ORAIMAGE_000019;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage20’ name ORAIMAGE_000020;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage21’ name ORAIMAGE_000021;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage22’ name ORAIMAGE_000022;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage23’ name ORAIMAGE_000023;
alter diskgroup ORAIMAGE add disk ‘/dev/asm-oraimage24’ name ORAIMAGE_000024;

ASMCMD> lsdsk -G ARCH

------crs-0259 数据库注册不上 bug 解决
[grid@jyjgrz ~]$ crscrl stop has
-bash: crscrl: command not found
[grid@jyjgrz ~]$ crsctl stop has

[grid@jyjgrz ~]$
[grid@jyjgrz ~]$
[grid@jyjgrz ~]$
[grid@jyjgrz ~]$ crsctl start has

[oracle@jyjgrz app]$ srvctl add database -d orcl -o $ORACLE_HOME

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论