Can you explain more about what this will results in? I am not so familiar
with oracle. Will it backup more often or more seldom but with bigger
?chunks??

 

Should we do these changes in the archive log scripts on each oracle client?

 

Hampus Lind
Rikspolisstyrelsen
National Police Board
Tel dir: +46 (0)8 - 401 99 43
Tel mob: +46 (0)70 - 217 92 66
E-mail: hampus.lind at rps.police.se

-----Ursprungligt meddelande-----
Fr?n: john_rickus at dofasco.ca [mailto:john_rickus at dofasco.ca] 
Skickat: den 14 februari 2007 20:58
Till: hampus.lind at rps.police.se; jlightner at water.com
Kopia: Veritas-bu at mailman.eng.auburn.edu
?mne: RE: [Veritas-bu] Serious master issue...

 

2 changes with regards to archive logs:

 - set the filesperset parameter back to 20

 - changed the format parameter to "oracle_arch_%p_%s_%t"

 

  _____  

From: Hampus Lind [mailto:hampus.lind at rps.police.se] 
Sent: Wednesday, February 14, 2007 2:50 PM
To: Rickus John; jlightner at water.com
Cc: Veritas-bu at mailman.eng.auburn.edu
Subject: SV: [Veritas-bu] Serious master issue...

We run 4 channels four our oracle archive log backups.. It backups 1000-2000
transactions a day


 

How did you solve your problems?

 

Thanks,

 

 

Hampus Lind
Rikspolisstyrelsen
National Police Board
Tel dir: +46 (0)8 - 401 99 43
Tel mob: +46 (0)70 - 217 92 66
E-mail: hampus.lind at rps.police.se

-----Ursprungligt meddelande-----
Fr?n: john_rickus at dofasco.ca [mailto:john_rickus at dofasco.ca] 
Skickat: den 14 februari 2007 20:43
Till: hampus.lind at rps.police.se; jlightner at water.com
Kopia: Veritas-bu at mailman.eng.auburn.edu
?mne: RE: [Veritas-bu] Serious master issue...

 

We had a similar problem with our master server ( rp4440) that backs up
oracle databases.  Found that the rman script *.rcv had the filesperset set
too low ( we had turned it down from 20 to 5 for the archive logs), causing
hundreds of backup images.  This resulted in the disk I/O being high when
the cleanup ran, and loads of bpdbm processes.

 

John Rickus 
Storage Analyst 
Dofasco Inc. 
905-548-7200 ext. 6004 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070214/e9bfdc0e/attachment-0001.html