Veritas-bu

Re: [Veritas-bu] Can RMAN be configured to use a limited number of tape drives?

2012-05-14 14:41:35
Subject: Re: [Veritas-bu] Can RMAN be configured to use a limited number of tape drives?
From: Peacock Dennis - dpeaco <Dennis.Peacock AT acxiom DOT com>
To: "Lightner, Jeff" <JLightner AT water DOT com>, "veritas-bu AT mailman.eng.auburn DOT edu" <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Mon, 14 May 2012 18:41:29 +0000

I can help you with this if you need it.

Your RMAN script will need to allocate multiple channels to use multiple drives. We backup over 3 PB of Oracle databases every month via RMAN and Netbackup.

We do normal FS type backups of everything EXCEPT for the Oracle table spaces and workspace. We leave those for each RMAN backup. Overall performance will depend on multiple things like CPU, memory, disk performance, tape performance and such as that…but on dedicated systems, we normally see over 200 MB / sec per tape drive via RMAN backup to LTO-4 / 5 tape drives.

 

DENNIS PEACOCK
EDP

Systems & Data Protection Engineer
Acxiom Corporation
EML   dennis.peacock AT acxiom DOT com
TEL    501-342-6232

CELL 501-343-3366
301 E. Dave Ward Drive, Conway, AR, 72032, U.S.A.
WWW.ACXIOM.COM

 

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Lightner, Jeff
Sent: Monday, May 14, 2012 1:35 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Can RMAN be configured to use a limited number of tape drives?

 

Currently we do RMAN backups for a small DB which essentially uses a single stream with multiple jobs kicked off (i.e. it would only use one tape drive if it were still going to tape).

 

We also do full filesystem backups for a couple of very large DBs after shutting down the DBs completely.    For those we allocate 4 streams which go to 4 tape drives.

 

There is a question from DBAs about whether we could move do an RMAN backup rather than filesystem so as to avoid the downtime on the DB.   My main question is how would we setup an RMAN policy so that it uses the 4 tape drives (and only 4)?  

 

For existing RMAN there are no streams listed so my assumption is that this is all controlled in the RMAN config scripts rather than at NetBackup policy level.

 

Also does anyone have an idea how much time difference an RMAN backup of a live database might take as compared to the cold backup of filesystems for a quiesced database? 

 

Please don’t suggest doing Mirror BCV or filesystem snapshot instead.   We’re already aware of such options but are currently looking at the RMAN question.

 

 

 

 

Athena®, Created for the Cause

Making a Difference in the Fight Against Breast Cancer

 

 

How and Why I Should Support Bottled Water!
Do not relinquish your right to choose bottled water as a healthy alternative to beverages that contain sugar, calories, etc. Your support of bottled water will make a difference! Your signatures count! Go to http://www.bottledwatermatters.org/luv-bottledwater-iframe/dswaters and sign a petition to support your right to always choose bottled water. Help fight federal and state issues, such as bottle deposits (or taxes) and organizations that want to ban the sale of bottled water. Support community curbside recycling programs. Support bottled water as a healthy way to maintain proper hydration. Our goal is 50,000 signatures. Share this petition with your friends and family today!

 

---------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------

 

***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
****************************************************************************

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<Prev in Thread] Current Thread [Next in Thread>