Cause :
1. Check if there are available space exist in your disk group.
2. Check re balance process are running or not.
Solution:
1. If disk space are not available reduce the size or add new LUN in your disk group.
2. If re balance process are running wait to complete the process.
erpdcdb01 acfsutil size +300G /backup
acfsutil size: ACFS-03171: Insufficient contiguous free ASM Diskgroup space. Check the ASM alert log.
erpdcdb01 asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN Y 512 4096 8388608 2150400 317160 0 317160 0 N BACKUP/
MOUNTED EXTERN N 512 4096 4194304 3686400 1456524 0 1456524 0 N DATA/
MOUNTED EXTERN N 512 4096 4194304 1228800 1043700 0 1043700 0 N FRA/
MOUNTED HIGH N 512 4096 4194304 25600 24212 10240 4657 0 Y OCR_VOT/
MOUNTED EXTERN N 512 4096 1048576 204800 177992 0 177992 0 N REDO/
ASMCMD> exit
erpdcdb01
erpdcdb01 sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 15 20:00:30 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
1 REBAL RUN 1 1 15841 32731 837
20
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
erpdcdb01
1. Check if there are available space exist in your disk group.
2. Check re balance process are running or not.
Solution:
1. If disk space are not available reduce the size or add new LUN in your disk group.
2. If re balance process are running wait to complete the process.
erpdcdb01 acfsutil size +300G /backup
acfsutil size: ACFS-03171: Insufficient contiguous free ASM Diskgroup space. Check the ASM alert log.
erpdcdb01 asmcmd
ASMCMD> lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN Y 512 4096 8388608 2150400 317160 0 317160 0 N BACKUP/
MOUNTED EXTERN N 512 4096 4194304 3686400 1456524 0 1456524 0 N DATA/
MOUNTED EXTERN N 512 4096 4194304 1228800 1043700 0 1043700 0 N FRA/
MOUNTED HIGH N 512 4096 4194304 25600 24212 10240 4657 0 Y OCR_VOT/
MOUNTED EXTERN N 512 4096 1048576 204800 177992 0 177992 0 N REDO/
ASMCMD> exit
erpdcdb01
erpdcdb01 sqlplus "/as sysasm"
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 15 20:00:30 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> select * from v$asm_operation;
GROUP_NUMBER OPERA STAT POWER ACTUAL SOFAR EST_WORK EST_RATE
------------ ----- ---- ---------- ---------- ---------- ---------- ----------
EST_MINUTES ERROR_CODE
----------- --------------------------------------------
1 REBAL RUN 1 1 15841 32731 837
20
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
erpdcdb01
ACFS-03171 error indicates a lack of contiguous free space in Oracle ASM Cluster File System (ACFS). How Play Games This can impede file operations. Resolving it involves managing disk space, defragmentation, or allocating additional space.
ReplyDelete