3 Replies Latest reply: Dec 4, 2012 1:33 PM by Sivamani RSS

    RMAN restore fails due to space issue


      My database size is 225 GB . I m restoring the backupfiles using RMAN from production backup to the test instance.During restore process rman failed due to space issue.When the error occurred rman restored around 122 GB.
      Now i increased the free space in server.So now my doubt is i have to delete the restored files (122GB) and start the restore process again or RMAN will automatically skip the the restored file and resume the process from where it was failed ?

      DB Version -

      RMAN error

      channel CH2: ORA-19870: error while restoring backup piece /ebs/DEV/backup/GOLD_db_t801111628_s10788_p1.rman
      ORA-19502: write error on file "/ebs/DEV/bin/db/apps_st/data/a_txn_data11.dbf", block number 3492608 (block size=8192)
      ORA-27072: File I/O error
      Linux-x86_64 Error: 28: No space left on device
      Additional information: 4
      Additional information: 3492608
      Additional information: -1