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.