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

2012-05-14 Thread Lightner, Jeff
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.
--


___
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu


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

2012-05-14 Thread Peacock Dennis - dpeaco
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.peac...@acxiom.com
TEL501-342-6232
CELL 501-343-3366
301 E. Dave Ward Drive, Conway, AR, 72032, U.S.A.
WWW.ACXIOM.COMhttp://WWW.ACXIOM.COM

From: veritas-bu-boun...@mailman.eng.auburn.edu 
[mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Lightner, Jeff
Sent: Monday, May 14, 2012 1:35 PM
To: veritas-bu@mailman.eng.auburn.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@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu