Re: standby archivelogs

Jim,
 
Modify the parameter log_archive_dest_2 to <FONT face="Times New Roman" size=3>"service=XXXXX optional reopen=300". Note the keyword "optional". This will ensure that even if the archive has not created the file at the standby location, the primary will not hang.  
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: Jim Neugebauer

  To: <A [EMAIL PROTECTED]
  href="mailto:[EMAIL PROTECTED]">Multiple recipients of list ORACLE-L   

  Sent: Friday, June 13, 2003 12:14
PM
  Subject: standby archivelogs   

  I would like to pose a question to the group in hopes of saving some   testing time.   I am reconfiguring an 8.1.7 managed standby server   after moving it to a new data center.  The network link between the   primary and standby is now 1/4 of what it used to be and I think this is going   to be an issue.  During periods of intense activity we can generate a LOT   of archive logs very quickly. 
 

  relevent parameters:
  log_archive_max_processes       = 
  5log_archive_dest_1             

• 'LOCATION=/oradata/xxx/arch MANDATORY REOPEN=120'log_archive_dest_2             
• "service=XXXXX reopen=300"log_archive_min_succeed_dest   
• 1
   
  my question is this.. will the primary database hang if all the redo logs are full and the archive process cannot keep up due to the sloooow network connection to the standby?  i.e. will all 5 archive processes get tied up writing to the standby and be unavailable to archive local logs?  do archivers give priority to local logs somehow?   Is there a way to separate local archive processes vs. remote archive processes?  I do not want to increase the number of archivers because this will only saturate the network more...
   
  Thanks!
   
  Jim Jim NeugebauerOracle DBAAmeritrade Holding Corp

  Do you Yahoo!?<A
  href="http://us.rd.yahoo.com/search/mailsig/*http://search.yahoo.com">The New   Yahoo! Search - Faster. Easier. Bingo. Received on Fri Jun 13 2003 - 11:14:28 CDT