Re: VLDB (oltp) and RMAN

Thanks for the response Arup !

"Arup Nanda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/20/2003 03:40 PM
Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        cc:        
        Subject:        Re: VLDB (oltp) and RMAN

Carol,
 

We use a 7.1 Terabytes (double Yikes!) database - Sun 15K server, Hitachi Storage Array, RAID-5 (all except redo logs which are RADI 0+1), 8.1.74. Some of thetables are more than 100 GB in size. However, the datafiles are smaller, just 4 GB each. This is done to facilitate the recovery process if a datablock is corrupted. It's esier to rcover 4G than 100G.
 

We use RMAN to back up to tape using Tivoli Storage Manager. No problems there. Backs up in 8 hours (full), with 16 channels.
 

If it may help - we have a standby database; the backups go from standby, not primary - to conserve the CPU cycles. and it certainly helps.
 

HTH.
 

Arup Nanda
www.proligence.com
----- Original Message -----
From: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L Sent: Friday, June 20, 2003 9:54 AM
Subject: VLDB (oltp) and RMAN

Hi Listers,

I've just finished a sizing exercise for a Production OLTP.   At the one-year mark, it should be approximately 4.5 Terabytes in size.  Yikes !!  I have a RAID5 array that I'll be using for all of the data files (except the typical System, Rbs, etc which are going to be on RAID 0+1).

I plan on using RMAN to do backups, naturally, however, I'm wondering whether anyone has run into any size limitations (from an RMAN perspective) when attempting to backup database files that are over 100Gig in size.  (I have the situation where I expect a single table tol be over 100Gig in size).  I'm aware of the fact that I may bump into hardware limitations, and I'm going to discuss the hardware and tape limitations (if there are any) with my Sun server sys admin.

Thanks in advance,
Carol Legros

Received on Mon Jun 23 2003 - 09:43:40 CDT