2 Replies Latest reply: Apr 30, 2013 7:23 PM by onedbguru RSS

    Space freed up in ACFS not reflected in DiskGroup

    resistanceIsFruitful
      GI version: 11.2.0.3/RHEL 5.8

      When I was trying to add a datafile to a tablespace and I got the following error
      SYS> ALTER TABLESPACE JPMS_UAT_UATA ADD DATAFILE '+DATA' SIZE 10g AUTOEXTEND ON NEXT 128M MAXSIZE 30721M;
      ALTER TABLESPACE JPMS_UAT_UATA ADD DATAFILE '+DATA' SIZE 10g AUTOEXTEND ON NEXT 128M MAXSIZE 30721M
      *
      ERROR at line 1:
      ORA-01119: error in creating database file '+DATA'
      ORA-17502: ksfdcre:4 Failed to create file +DATA
      ORA-15041: diskgroup "DATA" space exhausted
      -- I can see 170gb free in DATA Diskgroup. But I was still getting the above error
      SYS> select name, TOTAL_MB/1024/1024 TB, free_mb/1024 gb from v$asm_diskgroup;
      
      NAME                                   TB         GB
      ------------------------------ ---------- ----------
      DATA                           14.9914579 170.639648
      FRA                            24.5131664 3902.52637
      
      -- Tried Rebalance. It didn't help
      SQL> alter diskgroup DATA rebalance power 1;
      
      Diskgroup altered.
      We have an ACFS (/ora_dump ) which is created on top of DATA diskgroup.
      I deleted 400GB of files from /ora_dump and it was reflected correctly in the df output
      $ df -h /ora_dump
      Filesystem            Size  Used Avail Use% Mounted on
      /dev/asm/ora_dump-148
                            1.8T  1.2T  589G  68% /ora_dump
      But this space is NOT recovered in DATA diskroup, the ALTER TABLESPACE .. ADD DATAFILE command failed again
      and v$asm_diskgroup was still showing the old values
      SYS> select name, TOTAL_MB/1024/1024 TB, free_mb/1024 gb from v$asm_diskgroup;
      
      NAME                                   TB         GB
      ------------------------------ ---------- ----------
      DATA                           14.9914579 170.639648
      FRA                            24.5131664 3902.52637
      Is this expected ?
        • 1. Re: Space freed up in ACFS not reflected in DiskGroup
          FreddieEssex
          Has the rebalance completed?
          select * from v$asm_operation;
          I'd imagine a rebalance with a power=1 it might take a bit of time.

          What does the following show for your DATA disk group:
          select d.name, a.disk_number, a.total_mb, a.free_mb, a.state
          from v$asm_diskgroup d, v$asm_disk a 
          where d.group_number = a.group_number;
          • 2. Re: Space freed up in ACFS not reflected in DiskGroup
            onedbguru
            You have a misunderstanding of ASM and ACFS. Think of ACFS as a single container file stored in ASM. While you have space in ACFS - that space is no longer available in ASM.

            Now, for your create file problem..
            Review the ASM alert log. It shows you have 170G (170*1024) available. which should be more than sufficient space. So something else is going on.

            Do you per chance have different size disk devices? Make sure all of your devices per disk group are the same size.