|
[Veritas-bu] Oracle backups are slow
2005-12-09 13:52:39
This is a multi-part message in MIME format.
------_=_NextPart_001_01C5FCF1.BA82E015
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
We have many very large oracle databases that we wish to backup with the
NetBackup Oracle agent. We have run some tests and the performance has
not been impressive. The Media server/client is HPUX 11.11 with STK9940b
tape drives. Our test db is about 460 GB and with two streams we are
only getting about 16 or 17 MB/sec per drive. When I run tests of large
flat files (33GB) I'm getting 40 to 45GB/sec. I've tried many
combinations of buffer sizes and found my bests performance was 131072
for SIZE_DATA_BUFFERS and 128 for NUMBER_DATA_BUFFERS. Below are the
some of the kernel values I guess that would be important. The directive
is /home/oracle/script/rman_cold_backup.sh from the sample rman scripts
that came with the oracle agent. Last nights test backup had "waited for
full buffer 188694 times, delayed 270894 times" in the bptm log. My
question is how can I improve these oracle backups?=20
G.Bruce
shmem 1
shmmax 3758096384
shmmni 600
shmseg 600
mesg 1
msgmap 514
msgmax 8192
msgmnb 16384
msgmni 256
msgseg 8192
msgssz 8
msgtql 512
sema 1
semaem 16384
semmap 4098
semmni 4096
semmns 4096
semmnu 4096
semume 512
semvmx 32767
nproc 6420=20
=20
=20
=20
LEGAL DISCLAIMER=20
The information transmitted is intended solely for the individual or =
entity to which it is addressed and may contain confidential and/or =
privileged material. Any review, retransmission, dissemination or other =
use of or taking action in reliance upon this information by persons or =
entities other than the intended recipient is prohibited. If you have =
received this email in error please contact the sender and delete the =
material from any computer.=20
=20
Seeing Beyond Money is a service mark of SunTrust Banks, Inc.=20
[ST:XCL]=20
=20
=20
=20
=20
------_=_NextPart_001_01C5FCF1.BA82E015
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk";>
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16"><TITLE>Message</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1522" name=3DGENERATOR></HEAD><BODY =
><DIV>
<FONT SIZE=3D"+0">
<DIV>
<FONT FACE=3D"Courier">
<DIV>
<FONT FACE=3D"Courier">
<DIV>
<FONT FACE=3D"Courier">
<DIV>
<FONT FACE=3D"Times New Roman">
<DIV><FONT face=3DArial size=3D2><SPAN class=3D710501418-09122005>We =
have many very=20
large oracle databases that we wish to backup with the NetBackup Oracle =
agent.=20
We have run some tests and the performance has not been impressive. The =
Media=20
server/client is HPUX 11.11 with STK9940b tape drives. Our test db is =
about 460=20
GB and with two streams we are only getting about 16 or 17 MB/sec per =
drive.=20
When I run tests of large flat files (33GB) I'm getting 40 to =
45GB/sec.=20
I've tried many combinations of buffer sizes and found my bests =
performance was=20
131072 for SIZE_DATA_BUFFERS and 128 for NUMBER_DATA_BUFFERS. =
Below are=20
the some of the kernel values I guess that would be important. The =
directive is=20
/home/oracle/script/rman_cold_backup.sh from the sample rman scripts =
that came=20
with the oracle agent. Last nights test backup had "waited for full =
buffer=20
188694 times, delayed 270894 times" in the bptm log. My question is how =
can I=20
improve these oracle backups? </SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
class=3D710501418-09122005>G.Bruce<BR></DIV></SPAN></FONT>
<DIV><FONT face=3DArial size=3D2><SPAN =
class=3D710501418-09122005>shmem =20
1<BR>shmmax 3758096384<BR>shmmni 600<BR>shmseg =20
600<BR>mesg 1<BR>msgmap 514<BR>msgmax =20
8192<BR>msgmnb 16384<BR>msgmni 256<BR>msgseg =20
8192<BR>msgssz 8<BR>msgtql 512<BR>sema =20
1<BR>semaem 16384<BR>semmap 4098<BR>semmni =20
4096<BR>semmns 4096<BR>semmnu 4096<BR>semume =20
512<BR>semvmx 32767<BR>nproc =20
6420</SPAN></FONT></DIV></FONT>
</DIV>
<DIV>
<FONT FACE=3D"Times New Roman"> </FONT>
</DIV>
<DIV>
<FONT FACE=3D"Times New Roman">
</FONT> </DIV>
<DIV>
<FONT FACE=3D"Times New Roman">
</FONT> </DIV>
<DIV>
<FONT FACE=3D"Times New Roman">LEGAL DISCLAIMER<BR>The information =
transmitted is intended solely for the individual or entity to which it =
is addressed and may contain confidential and/or privileged material. =
Any review, retransmission, dissemination or other use of or taking =
action in reliance upon this information by persons or entities other =
than the intended recipient is prohibited. If you have received this =
email in error please contact the sender and delete the material from =
any computer.<BR> <BR>Seeing Beyond Money is a service mark of =
SunTrust Banks, Inc.<BR>[ST:XCL]</FONT>
</DIV>
</FONT>
</DIV>
</FONT>
</DIV>
</FONT>
</DIV>
</FONT>
</DIV></BODY></HTML>
------_=_NextPart_001_01C5FCF1.BA82E015--
|
| <Prev in Thread] |
Current Thread |
[Next in Thread> |
- [Veritas-bu] Oracle backups are slow,
Chewning.Bruce <=
|
|
|
