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 -188.8.131.52
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
When you start the restore from the failure, RMAN knows whcih are restored and it will check file headers. if the headers match, it will skip restoring the files.
Hope this helps,
RMAN Debug and Trace
Time for Change: Migrate your Non-RAC Database to RAC