Hi Tom,
when I try to add two new disk , once for failgroup , I receive this error:
ALTER DISKGROUP OCR ADD
FAILGROUP FGA disk '/dev/oracleasm/disks/pippo_OCR1_A_alfa' NAME pippo_OCR1_A_alfa
FAILGROUP FGH disk '/dev/oracleasm/disks/pippo_OCR1_H_alfa' NAME pippo_OCR1_H_alfa
REBALANCE POWER 8;
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-59700: Failgroup FGH already belongs to site cedh
ORA-59700: Failgroup FGA already belongs to site ceda
But if I query the view v$asm_disk I found that the name of failgroups are:
Disk Group Name Path File Name Fail Group FAILGROUP_LABEL SITE_LABEL
-------------------- ------------------------------------------ -------------------------- ----------- ---------------- ------------
OCR /dev/oracleasm/disks/CEDA_OCR1 OCR_0000 FGA
/dev/oracleasm/disks/CEDA_OCR2 OCR_0001 FGA
/dev/oracleasm/disks/CEDH_OCR1 OCR_0002 FGH
/dev/oracleasm/disks/CEDH_OCR2 OCR_0003 FGH
/voting_disk/asm-nfs-ocrvote03 OCR_0004 FGQ
********************
Disk Group
[CANDIDATE] /dev/oracleasm/disks/pippo_OCR1_A_alfa
/dev/oracleasm/disks/pippo_OCR1_H_alfa
If I change the statements , exchange FGA -> CCEDA and FGH -> CEDH , I've ora-00600 error:
ALTER DISKGROUP OCRVOTE
ADD
FAILGROUP CEDA disk '/dev/oracleasm/disks/RPU_HTH_DB_OCR1_A_UNITY' NAME RPU_HTH_DB_OCR1_A_UNITY
FAILGROUP CEDH disk '/dev/oracleasm/disks/RPU_HTH_DB_OCR1_H_UNITY' NAME RPU_HTH_DB_OCR1_H_UNITY
REBALANCE POWER 8;
# ALTER DISKGROUP OCRVOTE
# *
# ERROR at line 1:
# ORA-00600: internal error code, arguments: [kfgSiteNumPopulate02], [], [], [], [], [], [], [], [], [], [], []
Do you have any suggestions?
Thans a lot,
Andrea
ORA-600 (always) means contact Support, especially when it comes to disks/ASM, because you don't want to experiment with commands (either your own or offered by us) and jeopardize your data.
Whilst you're there, check MOS note 2781003.1