Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Andrea.

Asked: June 07, 2023 - 3:53 pm UTC

Last updated: June 12, 2023 - 4:25 am UTC

Version: oracle database server rac 19.7

Viewed 1000+ times

You Asked

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



and Connor said...

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




Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

ORA-59700

andrea, June 08, 2023 - 8:17 am UTC

Hi Tom,
do you have any suggestion about this error code:

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

thanks a lot
Connor McDonald
June 12, 2023 - 4:25 am UTC

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.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database