Oracle RMAN to Media Agent I/O Throughput

Last post 09-29-2014, 3:34 PM by mikedalv. 4 replies.
Sort Posts: Previous Next
  • Oracle RMAN to Media Agent I/O Throughput
    Posted: 09-26-2014, 4:21 PM

    I have read some of the posts on diagnosing I/O throughput for Oracle RMAN and CommVault media agents.  I have a 4.5 TB Enterprise Edition database that needs to be backed up and I configured it to use 4 streams, but it is taking days to copmlete.  I turned on the sORASBTPERSTAT parameter and collected the information for I/O throughput and the Media Agent is obviously the constraint with less than 8GB/HR I/O.  What can I do on the media agent to increase this I/O.

     

    SBTPS: Stream no = 2, Archive File Name = 386783_IBCARC_73pjahba_1_1, Size = 37331402752 bytes, Oracle I/O Time = 179.480095 secs,  MA I/O Time = 16659.268790 secs, Total (Oracle + MA) I/O Time = 16838.748885 secs
    SBTPS: Stream no = 2, Archive File Name = 386783_IBCARC_73pjahba_1_1, Oracle I/O Throughput = 697.365807 GB/Hr, MA I/O Throughput = 7.513132 GB/Hr, Total I/O Throughput = 7.433051 GB/Hr

    SBTPS: Stream no = 4, Archive File Name = 386783_IBCARC_75pjahba_1_1, Size = 41705013248 bytes, Oracle I/O Time = 164.585437 secs,  MA I/O Time = 18468.098958 secs, Total (Oracle + MA) I/O Time = 18632.684394 secs
    SBTPS: Stream no = 4, Archive File Name = 386783_IBCARC_75pjahba_1_1, Oracle I/O Throughput = 849.570629 GB/Hr, MA I/O Throughput = 7.571269 GB/Hr, Total I/O Throughput = 7.504391 GB/Hr

    SBTPS: Stream no = 1, Archive File Name = 386783_IBCARC_72pjahba_1_1, Size = 48322576384 bytes, Oracle I/O Time = 159.083442 secs,  MA I/O Time = 19732.487220 secs, Total (Oracle + MA) I/O Time = 19891.570661 secs
    SBTPS: Stream no = 1, Archive File Name = 386783_IBCARC_72pjahba_1_1, Oracle I/O Throughput = 1018.421909 GB/Hr, MA I/O Throughput = 8.210524 GB/Hr, Total I/O Throughput = 8.144860 GB/Hr

    SBTPS: Stream no = 3, Archive File Name = 386783_IBCARC_77pjb2gu_1_1, Size = 42018537472 bytes, Oracle I/O Time = 306.400186 secs,  MA I/O Time = 17704.847209 secs, Total (Oracle + MA) I/O Time = 18011.247395 secs
    SBTPS: Stream no = 3, Archive File Name = 386783_IBCARC_77pjb2gu_1_1, Oracle I/O Throughput = 459.784725 GB/Hr, MA I/O Throughput = 7.957037 GB/Hr, Total I/O Throughput = 7.821675 GB/Hr

     

    Thank you in advance.

  • Re: Oracle RMAN to Media Agent I/O Throughput
    Posted: 09-29-2014, 8:52 AM
    • efg is not online. Last active: 07-19-2019, 1:09 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,665

    Check the network throughput to the MediaAgent in question.   CV has a utility called "CvNetworkTestTool" which is located in the Base directory where the agent is installed.  (See Network Tools in BOL)  You can check the throughput between the Oracle server and the mediaagent to see if there is a "bottleneck" in the network.  There is also a non-CV utility called iperf that can perform the same throughput tests (google iperf to find/download for your platform).  There are also other settings that can be made for example there is a setting called nNumPipelineBuffers which defaults to 30, but can be adjusted higher and can improve throughput.  Here is a link to BOL that goes over tunable settings: CommCell Performance Tuning

    Please take a look through this link for the other settings that may also help. 

    Let us know how you make out.


    Ernst F. Graeler
    Senior Engineer III
    Development
  • Re: Oracle RMAN to Media Agent I/O Throughput
    Posted: 09-29-2014, 2:12 PM

    Thank you for the information.  Is there any screen shots or more information on the cvNetworkTestTools command.  I am not really sure what I need to run to troubleshoot the Network Throughput?  Am I supposed to run this on the client or the media agent?  Not exactly sure what I should do to test the throughput.

     

    Thanks in advance

  • Re: Oracle RMAN to Media Agent I/O Throughput
    Posted: 09-29-2014, 2:32 PM
    • efg is not online. Last active: 07-19-2019, 1:09 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Expert
    • Points 1,665

    It would be run from both...   there are -server and -client options accordingly.   I have attached a text file that contains output from a couple servers in my lab.   You may want to specify a 64k block/buffer size as that is what CommVault uses by default for almost all of its communications. (the example has 16k)  You would first start a "server" process on one side, and then start the client on the other.  Check the logs created to get the results.  The attached text file contains the output from a "Windows" system running as a "server" and a Linux system running as a "client".

    Let us know if this helps.


    Ernst F. Graeler
    Senior Engineer III
    Development
  • Re: Oracle RMAN to Media Agent I/O Throughput
    Posted: 09-29-2014, 3:34 PM

    So from the text file I could see that you were getting 7.81MB/SEC on the server which is about 27.45 GB/HR and on the client you were getting 11.16MB/SEC which is around 39.23GB/HR.  So would you say that your bottlenecked at your server?

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy