arch slow and standby.

  • From: "Ankur Godambe" <agodambe@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 6 Apr 2007 13:20:33 -0700

Hi,

In a 9i managed standby database with primary and secondary in maximum
performance mode if arch is not able to archive to remote destination
due to n/w issues etc, it will retry archiving to remote destination
depending upon REOPEN and MAX_FAILURES parameter. But what if the n/w is
slow (not dead and arch is actively archiving redo log) and by the time
it's archiving to the remote destination all the log groups on primary
are filled and lgwr comes back to the group being archived currently for
reuse. Will the database hang? Or it will stop archiving to remote with
error message somewhere in dictionary?  I tried simulating but since I
have the test databases on lan couldn't simulate.

I think it will wait till it's archived to the remote. Anyone who has
faced similar situation or knows what might happen?

 

Thanks,

Ankur

Other related posts: