RE: Curiosity question - Bandwidth using RMAN duplicate from Serivce

Mladen,

" One channel on a physical Linux box typically does around 350 GB/hr when compression is used. It's around 7.5 MB/sec. "

Mate, do you mean a single channel is throttled within Oracle itself? Why do we need 10 channels on a 10G net to get 3.5T/hr? Is it documented ?

Thanks,
Yogi | Technical Consultant – Databases | Fidelity International 5th Floor, Building 9, Candor Tech Space, Sector 48, Gurgaon 122 002, Haryana, India. T: +91 124 615 3656 | I: 8 779 3656 | E: yogesh.tiwari_at_fil.com<mailto:yogesh.tiwari_at_fil.com> Disclaimer: The information transmitted is intended for the person or entity to which it is addressed and may contain confidential, privileged or copyrighted material or attorney work product. If you receive this in error, please contact the sender and delete the material from any system. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Any comments or statements made are not necessarily those of Fidelity. All e-mails may be monitored or recorded.

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mladen Gogala Sent: 28 February 2019 07:46
To: oracle-l_at_freelists.org
Subject: Re: Curiosity question - Bandwidth using RMAN duplicate from Serivce

Hi Chris!

One channel on a physical Linux box typically does around 350 GB/hr when compression is used. It's around 7.5 MB/sec. Incidentally, that is also a 1Gb NIC bandwidth. If you have a 10 Gb network, these number scale pretty much linearly. On a 10 GB network, with 10 channels you can achieve around 3.5 TB/hr. That will devour the entire 10Gb connection, so I wouldn't go above 8. You can also have an Infiniband, which provides up to 40 Gb/sec. You will frequently find storage connected by Infiniband when using Exadata. That would achieve around 15 TB/hour. That would achieve the throughput of around 15 TB/hr, which means that you would backup 100 TB database in approximately 7 hours. There are also faster, 100 Gb network connection, which are very useful for backing up 100+ TB databases. On a full rack Exadata, that would mean 16 channels per node.

However, for a more precise information, I would need to know the kind of computer you're connecting to and its writing speed. If the connection target is using some cheapo NAS as the backup storage, more than likely, the best you can do is a 10 Gb connection. It is also important to know what backup system is being used. I have a lot of experience with Commvault and the numbers reported are for Commvault.

FULL DISCLOSURE: I am an employee of Commvault Systems.

Regards
On 2/27/19 6:34 PM, Chris Taylor wrote: If you're doing a duplicate from a service_name to a clone, can one channel use all the available bandwidth between the 2 hosts?

I don't know of any reason why a channel itself would be throttled. I can understand a channel not being able to read enough from disk to fill up the network card, so I'm guessing in theory 1 channel could use all the available bandwidth if it was reading from disk fast enough?

Key question:
I wonder how you could determine the correct number of channels if you know your disk read rate to avoid hammering your network bandwidth going out of the server?

(Note: I recently pegged a network card on a production server doing an RMAN duplicate and I've been puzzling over this since then - doesn't help that our production server had one network card only)

Chris

--

Mladen Gogala

Database Consultant

Tel: (347) 321-1217
--

http://www.freelists.org/webpage/oracle-l Received on Fri Mar 01 2019 - 04:54:07 CET