topic Re: Backing up RH Linux 3.0 w/Oracle 10g server in Operating System - Linux

Backing up RH Linux 3.0 w/Oracle 10g server

Ian Derringer — Thu, 06 Oct 2005 09:05:10 GMT

hi,
I have local attached and SANs storage attached to this server. Currently, I 'm backing up the data (2.9 TB) from disks to disks at this time. After I backed from disks to disks, then I backed it up to a tape device. However, the process from disks to tapes is taking way too long for a 2.9TB of data. Anyone here have any experience working with Linux and Oracle 10g backup? Please share your thoughts with me.

Thank you in advance.

Ian

Re: Backing up RH Linux 3.0 w/Oracle 10g server

Ivan Ferreira — Thu, 06 Oct 2005 09:18:27 GMT

Oracle can do "incrementals backups". You can use rman to integrate with your existing backup solution.

Re: Backing up RH Linux 3.0 w/Oracle 10g server

Ian Derringer — Thu, 06 Oct 2005 09:21:45 GMT

Ooops, I forgot to mention that we're currently using RMAN for the Oracle part.

Re: Backing up RH Linux 3.0 w/Oracle 10g server

Ivan Ferreira — Thu, 06 Oct 2005 10:01:13 GMT

Great!, so configure to use incremental backups:

http://www.cs.umb.edu/cs634/ora9idocs/server.920/a96566/rcmconc1.htm

Re: Backing up RH Linux 3.0 w/Oracle 10g server

Ian Derringer — Thu, 06 Oct 2005 10:20:12 GMT

How do I speed up the tape process? Right now, I am getting 80GB per hour on dual drives, this will take hours to back up 2.9TB - Any suggestions on tape backup?

Thanks,
Ian

Re: Backing up RH Linux 3.0 w/Oracle 10g server

Ivan Ferreira — Thu, 06 Oct 2005 10:42:20 GMT

You could try using differents block sizes to keep the tape device moving. The best way to know the exact block size that gives you the best performance is testing. I don't know if your backup software allows you to specify the block size.

Also, you could use a streamig technology, where multiples drives are used for the backup. You need a library and a supported software to do that.

Re: Backing up RH Linux 3.0 w/Oracle 10g server

Ivan Ferreira — Thu, 06 Oct 2005 13:49:50 GMT

You should also consider that maybe you are raching the maximum throughput of the device. How much time takes your 2.9 TB backup? What is the tape device model that are you using?