2 Replies Latest reply: Mar 4, 2013 8:26 AM by moreajays RSS

    ORA-27072: File I/O error,Linux-x86_64 Error: 28: No space left on device

    994595
      Hi,

      We have full backup schedule which is using by expdp in our cron, and we are getting the below error that shows no space left on device.
      But i am sure that my filesystem(/usr/oracle/exports/exp001) has enough space to hold a entire dump.Please have a look into the below details.
      Why it throws an error even after have enough space.

      ORA-31644: unable to position to block number 12457213 in dump file "/usr/oracle/exports/exp001/OHSIMPD/OHSIMPD_E_03.03.2013_compressed.dmp"
      ORA-19502: write error on file "/usr/oracle/exports/exp001/OHSIMPD/OHSIMPD_E_03.03.2013_compressed.dmp", block number 12457213 (block size=4096)
      ORA-27072: File I/O error
      Linux-x86_64 Error: 28: No space left on device
      Additional information: 4
      Additional
      ORA-31693: Table data object "OHSIM"."STAGE_CHDT052_PVISIT" failed to load/unload and is being skipped due to error:
      ORA-19502: write error on file "/usr/oracle/exports/exp001/OHSIMPD/OHSIMPD_E_03.03.2013_compressed.dmp", block number 12457324 (block size=4096)
      ORA-27072: File I/O error
      Linux-x86_64 Error: 28: No space left on device
      Additional information: 4
      Additional information: 12457324
      Additional information: -1
      ORA-31693: Table data object "OHSIM"."BOHS115_PERSON_ALL_IDS" failed to load/unload and is being skipped due to error:
      ORA-19502: write error on file "/usr/oracle/exports/exp001/OHSIMPD/OHSIMPD_E_03.03.2013_compressed.dmp", block number 12457580 (block size=4096)
      ORA-27072: File I/O error
      Linux-x86_64 Error: 28: No space left on device
      Additional information: 4
      Additional information: 12457580
      Additional information: -1
      ======================================
      1.3T 1.5G 1.2T 1% /usr/oracle/archive_logs/arc001
      /dev/mapper/vgSAN--fcdb1095-lv--exp001
      99G 48G 46G 52% /usr/oracle/exports/exp001
      /dev/mapper/vgSAN--fcdb1095-lv--dbs001
      1008M 78M 879M 9% /usr/oracle/oradata/dbs001


      Kindly anyone have a glance of the above details and reply back to me.