OraFAQ Forum: Backup & Recovery » rman tuning

Home » RDBMS Server » Backup & Recovery » rman tuning - one question (11.g.r1)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

rman tuning - one question [message #529186]

Sat, 29 October 2011 08:49

piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

hi,

could you please help me with answering on this question. i am confused, because one sources tells different than other.
thanks in advance.

---------------------------------
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.
What could be a solution to make tape streaming happen during the backup?

A.
Configure backup optimization

B.
Configure the channel to increase MAXOPENFILES

C.
Configure the channel to increase the capacity with the RATE parameter

D.
Configure the channel to adjust the tape buffer size with the BLKSIZE option

Report message to a moderator

Re: rman tuning - one question [message #529190 is a reply to message #529186]

Sat, 29 October 2011 09:57

Michel Cadot
Messages: 54195
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is your opinion and why?

Regards
Michel

Report message to a moderator

Re: rman tuning - one question [message #529202 is a reply to message #529190]

Sat, 29 October 2011 12:30

piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

Michel Cadot wrote on Sat, 29 October 2011 16:57

What is your opinion and why?

Regards
Michel

i read somewhere, that if we have problem with tape streaming we should increase level of multiplexing and definition of multiplexing says:

-----------------------
RMAN multiplexing is the number of files in a backup read simultaneously and then written to the same backup piece. The degree of multiplexing depends on the FILESPERSET parameter of the BACKUP command as well as the MAXOPENFILES parameter of the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands.
-----------------------

so my answer is B (MaxOpenFiles)

but i found many sites where they answered D or C. im confused.

Report message to a moderator

Re: rman tuning - one question [message #529204 is a reply to message #529202]

Sat, 29 October 2011 12:39

Michel Cadot
Messages: 54195
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

i read somewhere

I read somewhere that all what is said in all Oracle books is wrong.

Quote:

but i found many sites

But I found many sites that say this is not correct.

Regards
Michel

[Updated on: Sat, 29 October 2011 12:40]

Report message to a moderator

Re: rman tuning - one question [message #529216 is a reply to message #529204]

Sat, 29 October 2011 14:48

piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

so what is the right answer?

Report message to a moderator

Re: rman tuning - one question [message #529227 is a reply to message #529216]

Sun, 30 October 2011 01:32

Michel Cadot
Messages: 54195
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What I meant is ALWAYS post a link or a clear reference (book title, author, chapter, page) of what you quote or refer otherwise its value is NULL.

Regards
Michel

Report message to a moderator

Re: rman tuning - one question [message #529230 is a reply to message #529216]

Sun, 30 October 2011 01:48

John Watson
Messages: 3109
Registered: January 2010
Location: Global Village

Senior Member

I thought that RATE was deprecated in 11g, you are meant to use the DURATION...MINIMIZE LOAD | TIME clause instead.

Report message to a moderator

Re: rman tuning - one question [message #529239 is a reply to message #529227]

Sun, 30 October 2011 03:11

piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

Michel Cadot wrote on Sun, 30 October 2011 07:32

What I meant is ALWAYS post a link or a clear reference (book title, author, chapter, page) of what you quote or refer otherwise its value is NULL.

Regards
Michel

ok MIchael, I will take that under consideration during my future posting. Thanks.

Report message to a moderator

Previous Topic:	how catalog BACKUPPICE in Oracle9i
Next Topic:	My question about incremental backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 23:50:13 CDT 2013

Total time taken to generate the page: 0.14920 seconds