Discussion:
Dump and loads
(too old to reply)
unknown
2006-06-20 10:54:00 UTC
Permalink
hi all,

I have a database approximatel 160GB. The dump size is
120GB. Taking a dump of the database to Tape takes 2hrs
while loading takes 3hrs.
backup_tape.cfg is as follows:

Revision 2
nmb-livedbsvr /dev/nst0 2 1 2097152 114 0 1.

Type of Tape: DLTtape
Size: 800GB

How can i reduce these timings.

Martin
A.M.
2006-06-20 11:56:24 UTC
Permalink
Post by unknown
I have a database approximatel 160GB. The dump size is
120GB. Taking a dump of the database to Tape takes 2hrs
while loading takes 3hrs.
Revision 2
nmb-livedbsvr /dev/nst0 2 1 2097152 114 0 1.
What OS are you using? I seem to recall that the
non-rewinding tape device was /dev/nrst for BSD-based
Unix OSes.
Post by unknown
Type of Tape: DLTtape
Size: 800GB
How can i reduce these timings.
Dump striping (which means you'll need more than one device).
Compression will help with the dumps but it won't improve loads
by a great deal.

Also check that you have increased the number of large i/o buffers.

-am © MMVI
unknown
2006-06-20 16:08:00 UTC
Permalink
Thax,

OS: Red Hat Linux ES version 4.0
I had configure the numbet of number of large i/o buffers.



Martin
Post by A.M.
Post by unknown
I have a database approximatel 160GB. The dump size is
120GB. Taking a dump of the database to Tape takes 2hrs
while loading takes 3hrs.
Revision 2
nmb-livedbsvr /dev/nst0 2 1 2097152 114 0 1.
What OS are you using? I seem to recall that the
non-rewinding tape device was /dev/nrst for BSD-based
Unix OSes.
Post by unknown
Type of Tape: DLTtape
Size: 800GB
How can i reduce these timings.
Dump striping (which means you'll need more than one
device).
Compression will help with the dumps but it won't
improve loads
by a great deal.
Also check that you have increased the number of large
i/o buffers.
-am © MMVI
A.M.
2006-06-21 00:54:06 UTC
Permalink
Post by unknown
OS: Red Hat Linux ES version 4.0
I had configure the numbet of number of large i/o buffers.
Also note is you have space disk space, you can
dump to disk and then back up the files to tape.
Recover will have to go in the reverse direction.

-am © MMVI
Jason L. Froebe (Team Sybase)
2006-06-21 02:26:27 UTC
Permalink
Post by A.M.
Post by unknown
OS: Red Hat Linux ES version 4.0
I had configure the numbet of number of large i/o buffers.
Also note is you have space disk space, you can
dump to disk and then back up the files to tape.
Recover will have to go in the reverse direction.
-am © MMVI
dumping to the filesystem is usually 5 to 10 times faster than dumping
to tape. The benefit of dumping to a filesystem is that the directory
can be backed up with the normal os backup routine (or sent to some
network backup).
--
Jason L. Froebe
http://jfroebe.livejournal.com
Team Sybase
unknown
2006-06-21 04:23:47 UTC
Permalink
Have you tried with the blocksize, once I have faced the
same problem, after using blocksize. The dump the database
to tape increased the speed.

Try with blocksize. Even it depends on your tape drive
speed also. Our all backups are taken to tapes.

Regards,
-JD
Post by unknown
Thax,
OS: Red Hat Linux ES version 4.0
I had configure the numbet of number of large i/o buffers.
Martin
Post by A.M.
Post by unknown
I have a database approximatel 160GB. The dump size is
120GB. Taking a dump of the database to Tape takes
2hrs while loading takes 3hrs.
Revision 2
nmb-livedbsvr /dev/nst0 2 1 2097152 114 0 1.
What OS are you using? I seem to recall that the
non-rewinding tape device was /dev/nrst for
BSD-based Unix OSes.
Post by unknown
Type of Tape: DLTtape
Size: 800GB
How can i reduce these timings.
Dump striping (which means you'll need more than one
device).
Compression will help with the dumps but it won't
improve loads
by a great deal.
Also check that you have increased the number of
large i/o buffers.
-am © MMVI
unknown
2006-06-21 10:47:31 UTC
Permalink
Hi All,

I have tried all these settings and still not performing. im
using a block size of 8388608.

How do i determine that this is not a sybase issue rather it
is a Operating system issue.

Thanx

Martin
Post by unknown
Have you tried with the blocksize, once I have faced the
same problem, after using blocksize. The dump the
database to tape increased the speed.
Try with blocksize. Even it depends on your tape drive
speed also. Our all backups are taken to tapes.
Regards,
-JD
Post by unknown
Thax,
OS: Red Hat Linux ES version 4.0
I had configure the numbet of number of large i/o
buffers. >
Post by unknown
Martin
Post by A.M.
Post by unknown
I have a database approximatel 160GB. The dump size
is 120GB. Taking a dump of the database to Tape
takes 2hrs while loading takes 3hrs.
Revision 2
nmb-livedbsvr /dev/nst0 2 1 2097152 114 0 1.
What OS are you using? I seem to recall that the
non-rewinding tape device was /dev/nrst for
BSD-based Unix OSes.
Post by unknown
Type of Tape: DLTtape
Size: 800GB
How can i reduce these timings.
Dump striping (which means you'll need more than
one device).
Compression will help with the dumps but it won't
improve loads
by a great deal.
Also check that you have increased the number of
large i/o buffers.
-am © MMVI
unknown
2006-06-21 04:11:27 UTC
Permalink
Do you use compression while dumping ? You can think of dumping to file
server (local or remote) then take a tape backup this is much faster.

Regards
KRV
Post by unknown
hi all,
I have a database approximatel 160GB. The dump size is
120GB. Taking a dump of the database to Tape takes 2hrs
while loading takes 3hrs.
Revision 2
nmb-livedbsvr /dev/nst0 2 1 2097152 114 0 1.
Type of Tape: DLTtape
Size: 800GB
How can i reduce these timings.
Martin
Loading...