Lokeshaggarwal's DBA

Live the life you love. Love the life you live

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.

Advertisements

February 26, 2016 - Posted by | ASM, Uncategorized

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: