Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN tuning

RE: RMAN tuning

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Wed, 29 Aug 2001 05:21:47 -0700
Message-ID: <F001.0037ADEF.20010829051025@fatcity.com>

Michael,

You might look at the BLKSIZE parameter. I did some basic tests using NT and the EDM client, and found that setting the BLKSIZE to 2 Meg was the fastest for my installation. I think the default is 64k.

You set the parameter like:

allocate channel d2 type 'SBT_TAPE' parms 'BLKSIZE=2097152';

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Tuesday, August 28, 2001 9:26 PM
To: Multiple recipients of list ORACLE-L

Hi All,

I use RMAN to do a full backup of 120G database while the database is up running. It takes around 6 hours to finish. I have 61 data files and manually allocate 6 channels. For all the RMAN parameters such as FILESPERSET, I take the default.

Does anybody there know how to maximize the throughput?

Thanks,

Michael



This e-mail contains privileged attorney-client communications and/or confidential information, and is only for the use by the intended recipient. Receipt by an unintended recipient does not constitute a waiver of any applicable privilege.

Reading, disclosure, discussion, dissemination, distribution or copying of this information by anyone other than the intended recipient or his or her employees or agents is strictly prohibited. If you have received this communication in error, please immediately notify us and delete the original material from your computer.

Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCalGas, the utilities owned by SET's parent company. SET is not regulated by the California Public Utilities Commission and you do not have to buy SET's products and services to continue to receive quality regulated service from the utilities.



--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Xin \"Michael\" Wu
  INET: xwu_at_sempratrading.com
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mercadante, Thomas F
  INET: NDATFM_at_labor.state.ny.us
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Aug 29 2001 - 07:21:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US