The only way to perform the backup is to backup data into a stage area first, and then push to tape, erase the files on disk, and do another backup, ..., iterate until all of the data is backed up. (I assume that RMAN will lose cross-checking capability on a file that is erased in disk, but what about in tape?) Things become complicated due to the space issue, particular for the first initial backup, and time issue, as well. From the testing I did, it will take more than 10 hours to backup 500 GB.
I'm thinking that to take the tablespace level backup, one by one, monthly level 0 backup, and level 1/2 cumulative backup in between. What is the best way for situation like this? Is there any way to speed up the backup time using RMAN?
Dig deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.