REOPEN does *not* mean re-ship logs. It means 'try and start sending new
archives to the same destination after X seconds'. Any archives that get
created during the time that the destination is 'closed' are missed, and
it's up to you to ship them to that destination yourself, using manual
methods.
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Sean M" <smckeownNO_at_BACKSIESearthlink.net> wrote in message
news:3C90C433.6240B87B_at_BACKSIESearthlink.net...
> Chuck wrote:
> >
> > Is there an easy solution to
> > have Oracle automatically retry to ship the log? Upgrading to 9i is
> > not an option.
>
> Yes, you can set the REOPEN clause in your LOG_ARCHIVE_DEST_n init.ora
> parameter to retry after a set amount of time. Without the REOPEN
> clause, the database defaults to not retrying a failed archive attempt.
> Note that this can also burn you if you use LOG_ARCHIVE_DEST_n for your
> mandatory local disk without REOPEN - if the local disk fills and halts
> archiving, the database won't automatically retry the failed archive
> even after you've freed up space.
>
> Regards,
> Sean
Received on Thu Mar 14 2002 - 13:46:06 CST
