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
<A
href="http://www.proligence.com">www.proligence.com <BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED] To: <A [EMAIL PROTECTED] href="mailto:[EMAIL PROTECTED]">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 <FONT   face=sans-serif size=2>be approximately 4.5 Terabytes in size.  Yikes !!    I have a RAID5 array that I'll be using for <FONT   face=sans-serif size=2>all of the data files (except the typical System, Rbs,   etc which are going to be on RAID 0+1). <FONT face=sans-serif   size=2>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. <FONT   face=sans-serif size=2>Thanks in advance, <FONT face=sans-serif   size=2>Carol Legros <FONT face=sans-serif size=2> Received on Fri Jun 20 2003 - 14:34:17 CDT