ORA-15033 disk belongs to diskgroup
Recently, we have faced one issue while adding disk into the diskgroup.
We have one diskgroup viz. CRS created with “NORMAL” redundancy. Someone in the UNIX team replaced the disk without running “ALTER DISKGROUP” Command.
So, while adding diskgroup, we got the below error:
alter diskgroup CRS add
FAILGROUP CRS01_0000 disk ‘/dev/rhdiskpower98’ rebalance power 11;SQL> 2
alter diskgroup CRS add
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15033: disk ‘/dev/rhdiskpower98’ belongs to diskgroup “CRS”
As the “Alter DiskGroup DATA DROP DISK” command has not been run so, we need to add disk with Force option.
SQL> alter diskgroup CRS add
FAILGROUP CRS01_0000 disk ‘/dev/rhdiskpower98’ force rebalance power 11;
Diskgroup altered.
SQL> SELECT
NVL(a.name, ‘[CANDIDATE]’) disk_group_name
, b.path disk_file_path
, b.name disk_file_name
, b.failgroup disk_file_fail_group
FROM
v$asm_diskgroup a RIGHT OUTER JOIN v$asm_disk b USING (group_number) where b.path=’/dev/rhdiskpower98′
ORDER BY
a.name;
DISK_GROUP_NAME DISK_FILE_PATH DISK_FILE_NAME DISK_FILE_FAIL_GROUP
—————————————- —————————————- —————————— ——————————
CRS /dev/rhdiskpower98 CRS01_0000 CRS01_0000
So, problem can be resolved by using the FORCE clause while adding disk.
-
Recent
- ORA-15033 disk belongs to diskgroup
- Testing the Media Management API
- PROC-26: Error while accessing the physical storage ASM error AMDU-00204: AMDU-00201:
- Oracle Database 12c installation steps
- Auto start of Golden Gate after DB server reboots
- Relocating SCAN VIP from one node to another node
- amdu – ASM Metadata Dump Utility
- Backup and Restore of ASM Metadata in Oracle 11gR2 (md_backup and md_restore)
- Deleting an OCR in 11gR2
- Adding an OCR on a separate Diskgroup 11gR2
- ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28
- Oracle DBA Training
-
Links
-
Archives
- February 2016 (1)
- December 2015 (1)
- February 2014 (1)
- June 2013 (1)
- April 2013 (1)
- December 2012 (5)
- November 2012 (1)
- August 2012 (3)
- July 2012 (1)
- June 2012 (2)
- October 2011 (1)
- May 2011 (2)
-
Categories
-
RSS
Entries RSS
Comments RSS