Oracle 19c Rman Backup Performance Issue with Bigfile Tablespaces
Hi,
We have a new 19c database (19.16.0.0) with approximately 25TB of data. There are two bigfile tablespaces in this database and 99% of the data are in these two tablespaces. I used the following script to make a full backup:
The problem was that the backup would take approximately 60 hours to complete. That's a lot, and when I checked the rman progress I noticed that sixteen backup channels were released in the first thirty minutes, leaving only two slow channels!
Therefore, I modified the script as below and decided to backup those two tablespaces separately:
After running the backup I checked the rman progress again and saw that the parallel channels were working fine and the backup finished within four hours.