Backing up large database

From: <dbaplusplus_at_hotmail.com>
Date: 18 Mar 2007 19:24:57 -0700
Message-ID: <1174271097.939882.294220@o5g2000hsb.googlegroups.com>

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 Received on Sun Mar 18 2007 - 21:24:57 CDT