Demonstration of FAILGROUP_REPAIR_TIME attribute of ASM diskgroup

In this tutorial I show how FAILGROUP_REPAIR_TIME attribute works when all disks of a single failgroup fails 

Create diskgrup newdg normal redundancy 

failgroup fg1 disk '/dev/sde1' name NEWDG_DISK1

failgroup fg2 disk '/dev/sdf1' name NEWDG_DISK2;

col name format a40

set linesize 150

select group_number, name, state, type, total_mb, free_mb from v$asm_diskgroup;

alter diskgroup newset set attribute 'compatible.asm'='12.1';

alter diskgroup newset set attribute 'compatible.rdbms'='12.1';

select name, value from v$asm_attribute where group_number=2 and name like '%repair%';

alter diskgroup newdg dismount;

alter diskgroup newdg online disks in failgroup fg1;

Student Reviews

average rating
0
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%

leave comment

Sign in

Sign in

sign in or sign up

add to watchlist
  • 568 views
  • Duration : 00:04:53