Vote disk 迁移失败 ORA-15274: Not enough failgroups (3) to create voting files

在一些特殊的情况下,比如存储迁移等,需要将vote disk从一个ASM disk group迁移到另外一个ASM disk group。

- 当前vote disk位于VOTE diskgroup

$crsctl query css votedisk

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

1. ONLINE   7971b4acbea54fbabf17d0cc091ed451 (/dev/rhdisk42) [VOTE]

2. ONLINE   56cb40af1ff64f9fbff79bfadd03d432 (/dev/rhdisk82) [VOTE]

3. ONLINE   40228e87536e4f9dbfdb7c6f90fbe917 (/dev/rhdisk2) [VOTE]

Located 3 voting disk(s).



- 迁移vote disk到+data diskgroup,命令失败:

$crsctl replace votedisk +data

Failed to create voting files on disk group data.

Change to configuration failed, but was successfully rolled back.

CRS-4000: Command Replace failed, or completed with errors.



- GI_HOME/log/<hostname>/client/crsctl_log.txt 错误信息

2013-08-14 10:32:01.767: [  CRSCTL][1]crsctl_replace_votedisk: calling kgfdvfPushDiskString

2013-08-14 10:32:03.153: [  CRSCTL][1]function crsctl_replace_votedisk, error 1 [clsuSlosFormatDiag called with non-error slos.]

2013-08-14 10:32:03.153: [  CRSCTL][1]crsctl_replace_votedisk: pushed the ASM DS to the profile 1

[   CLWAL][1]clsw_Initialize: OLR initlevel [30000]

2013-08-14 10:32:03.386: [  CRSCTL][1]crsctl_format_diskgroup: creating diskgroup data

2013-08-14 10:32:05.855: [  CRSCTL][1]function crsctl_format_diskgroup, error 1 SLOS: cat=-1, opn=(none), dep=(none), loc=ORA-01405: f

2013-08-14 10:32:05.856: [  CRSCTL][1]crsctl_format_diskgroup: diskgroup data creation with status 1. Please check the alert log file for ASM



- asm alert log 错误信息:

NOTE: Creating voting files in diskgroup DATA

NOTE: Voting File refresh pending for group 1/0xad5e996c (DATA)

NOTE: Attempting voting file creation in diskgroup DATA

NOTE: voting file allocation on grp 1 disk DATA_0000

NOTE: voting file allocation on grp 1 disk DATA_0001

ERROR: Voting file allocation failed for group DATA

Errors in file /app/base/diag/asm/+asm/+ASM1/trace/+ASM1_ora_43581494.trc:

ORA-15274: Not enough failgroups (3) to create voting files



- 问题原因:存放vote disk的diskgroup必须满足下面的要求:

1. 如果diskgroup是normal redundant,那么要求有3个failure group才能存放vote disk。

2. 如果diskgroup是high redundant,那么要求有5个failure group才能存放vote disk。



+DATA diskgroup是normal redundant diskgroup,但是只有2个failure group,不满足上面的要求,因此失败,

查看diskgroup的failure group信息:

select GROUP_NUMBER,name,type from v$asm_diskgroup;

GROUP_NUMBER NAME                           TYPE

------------ ------------------------------ ------

           2 DATA                           NORMAL  

<<<<<<<<<<< +DATA是normal redundant diskgroup   


select group_number,disk_number,name,path,failgroup from v$asm_disk where GROUP_NUMBER=2;    

GROUP_NUMBER DISK_NUMBER NAME                           PATH       FAILGROUP

------------ ----------- ------------------------------ ---------- ------------------------------

           2           0 ASMDISK1                   ORCL:ASMDISK1 CONTROLLER1

           2           1 ASMDISK2                   ORCL:ASMDISK2 CONTROLLER2

<<<<<<<<<<<+DATA只有2个failure group,CONTROLLER1和CONTROLLER2



- 解决方法:创建一个normal redundant diskgroup,并且有3个failure group,然后再迁移.



方法#1 指定3个disk,并且设置3个failure group

CREATE DISKGROUP temp1 NORMAL REDUNDANCY

FAILGROUP controller1 DISK '/dev/ASMDISK1' NAME ASMDISK1

FAILGROUP controller2 DISK '/dev/ASMDISK2' NAME ASMDISK2

FAILGROUP controller3 DISK '/dev/ASMDISK3' NAME ASMDISK3;



方法#2 指定3个disks,默认每个disk为自己的failure group

CREATE DISKGROUP temp1 NORMAL REDUNDANCY

DISK '/dev/ASMDISK1' NAME ASMDISK1

DISK '/dev/ASMDISK2' NAME ASMDISK2

DISK '/dev/ASMDISK3' NAME ASMDISK3;

-迁移vote disk

$crsctl replace votedisk +temp1



参考在线文档:http://docs.oracle.com/cd/E11882_01/install.112/e41961/storage.htm#CWLIN290

Disk groups containing voting files must have at least 3 failure groups for normal redundancy or at least 5 failure groups for high redundancy. 



参与此主题的后续讨论,可以访问我们的中文社区,跟帖“共享:Vote disk 迁移失败 ORA-15274: Not enough failgroups (3) to create voting files"。 

评论:

发表一条评论:
  • HTML语法: 禁用
About

本博客由Oracle全球技术支持中国区的工程师维护。为中文用户提供数据库相关的技术支持信息,包括常用的诊断工具、诊断方法、产品新特性、案例分析等。此外,MOS也陆续推出各类中文内容:技术通讯统一发布在Note 1529795.1 中,中文文档列表更新在Note 1533057.1 中,网上讲座请查看MOS文档 1456176.1,在"Archived"中可以下载历史的录音和文档。

Search

Archives
« 四月 2014
星期日星期一星期二星期三星期四星期五星期六
  
1
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
今天