Database Backup and Recovery (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center