Re: Backing up large database

dbaplusplus_at_hotmail.com wrote:
> Subject: Backing up large (500GB) database
>
> My Oracle version is 8.1.6.1 (yes, it is 8i and I have to support it
> because of reasons
> beyond my control).
>
> I have been using RMAN/Netbackup. Database servers reside in some
> location which is not in same data center where Netbackup servers
> reside. As a result, full backups take long time (5+ hours) for our
> current database which is only 10GB. Now we
> will be setting up a data warehouse (500GB). It is data warehouse, but
> incremental changes will be done daily. I will be doing full backup
> every weekend and incremental backups other days. What I am concerned
> is amount of time it is going to take to do
> 500GB database backup.
>
> For 10GB database, we only use 1 RMAN channel. We are planning to use
> multiple channels for data warehouse backup. I have read database
> administration guide and backup/recovery guides.
>
> Appreciate any ideas you can provide based on your experience or any
> pointers will be helpful.
>
> Thanks a lot

Read the RMAN docs and learn how to do level 1 backups and to use block change tracking.
http://www.psoug.org/reference/block_change_tracking.html

PS: Working with 8i may be beyond your control. Is patching it beyond your control too?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org