Re: Backup of large databases

On Fri, 26 Oct 2007 13:53:07 -0700, zigzagdna_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.

You should not set up *new* databases in a desupported version of Oracle. The only reason to retain desupported versions is vendors unwilling to upgrade their product.
Your problem would be extinct in Oracle 9i and higher, where you can backup to database, and backup the resulting backupsets to tape. Yet another reason to dump the 8.1.6 crap asap. If management doesn't want to dump the 8.1.6 crap you should be looking out for a new job, that is: before they fire you when they decide to discontinue Oracle, because you are lightyears behind, and you will suffer from it, as the world has moved on.

-- 
Sybrand Bakker
Senior Oracle DBA