https://nadeemmohammed.wordpress.com/2012/03/13/list-of-oracle-database-patch-set-updates-psu/#11204
select * from gv$asm_operation order by 1,2,3;
col name format a15;
col path format a25;
col failgroup format a20;
--
select dg.name, d.path, d.failgroup, d.failgroup_type,dg.VOTING_FILES
from v$asm_diskgroup dg, v$asm_disk d
where dg.group_number = d.group_number and dg.name = 'GRID'
order by dg.name, d.path, d.failgroup;
crsctl query css votedisk
select * from gv$asm_operation order by 1,2,3;
col name format a15;
col path format a25;
col failgroup format a20;
--
select dg.name, d.path, d.failgroup, d.failgroup_type,dg.VOTING_FILES
from v$asm_diskgroup dg, v$asm_disk d
where dg.group_number = d.group_number and dg.name = 'GRID'
order by dg.name, d.path, d.failgroup;
crsctl query css votedisk
No comments:
Post a Comment