Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Error when adding disk in ASM ORA-15031: disk specification ' ' matches no disks

Noname123Feb 16 2022 — edited Feb 16 2022

I am using Oracle 12 c database.
I got the below error in standby database log:
Error from log:

2022-02-16T11:48:15.050688+03:00
Unable to create archive log file '+FRA'
2022-02-16T11:48:15.051270+03:00
Errors in file /u01/app/oracle/diag/rdbms/linstd/linstd/trace/linstd_arc3_3412.trc:
ORA-19504: failed to create file "+FRA"
ORA-17502: ksfdcre:4 Failed to create file +FRA
ORA-15041: diskgroup "FRA" space exhausted
ARC3: Error 19504 Creating archive log file to '+FRA'

So i went to add disk to the FRA diskgroup:

SQL> show parameter asm
NAME TYPE VALUE
----------------------------------- ----------- ------------------------------
asm_diskgroups string FRA
asm_diskstring string /dev/rdisk/*
asm_power_limit integer 1
asm_preferred_read_failure_groups string

SQL> ALTER DISKGROUP FRA ADD DISK '/dev/rdisk/FRA5' NAME FRA_0004 SIZE 51200 M REBALANCE POWER 10;
ALTER DISKGROUP FRA ADD DISK '/dev/rdisk/FRA5' NAME FRA_0004 SIZE 51200 M REBALANCE POWER 10
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification '/dev/rdisk/FRA5' matches no disks
but I got the error above that it matches no disks
Below is query to show all diskgroup i have.

SQL> select a.name DiskGroup,b.name DiskName, b.total_mb, (b.total_mb-b.free_mb) Used_MB, b.free_mb,b.path,b.header_status from v$asm_disk b, v$asm_diskgroup a where .group_number (+) =b.group_number and a.name='FRA' order by b.group_number,b.name;

DISKGROUP DISKNAME TOTAL_MB USED_MB FREE_MB
------------------------------ ------------------------------ ---------- ---------- ----------
PATH HEADER_STATU
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------
FRA FRA_0000 51200 51140 60
/dev/rdisk/FRA1 MEMBER

FRA FRA_0001 51200 51200 0
/dev/rdisk/FRA2 MEMBER

FRA FRA_0002 51200 51144 56
/dev/rdisk/FRA3 MEMBER

FRA FRA_0003 51200 51036 164
/dev/rdisk/FRA4 MEMBER

Please assist on this as I am new to asm.

Comments

Processing

Post Details

Added on Feb 16 2022
#asm, #general-database-discussions
3 comments
3,280 views
1 mention