Re: Backup of large databases

On Oct 26, 4:53 pm, zigzag..._at_yahoo.com wrote:
> I am still on Oracle 8.1.6.1 on HP UNIX 11, I am using RMAN for
> backups. We are going to setup a large data warehouse which is
> expected to grow to 500GB. My main concerns is backup times taken by
> database backups. Currently, for 20GB database size, full backups take
> 12 hours to complete, I am using RMAN with default parameters and only
> one channel is being used:
> Allocate channel ch1 type 'SBT_TAPE';
>
> I think reason backups take so long is Network band width. Our servers
> reside in a local data center but backups are done over WAN in central
> data center where all Netbackup tape servers and tape drives reside.
> We cannot move our databases to central data center.
>
> Only parameters which I know to experiment are usng multiple channels
> and tuning some init.ora parameters documented in RMAN manual.
>
> I will appreciate any other ideas.

We back up a 250G database in less time than your backup of a 20G database is taking. I suggest your firm invest in better hardware, especially disk. Your primary backup should be to disk and the disk can be backed up to tape.

A newer version of Oracle would not hurt either.

HTH -- Mark D Powell -- Received on Fri Oct 26 2007 - 18:44:16 CDT