Re: Standby database problem

From: Sean M <smckeownNO_at_BACKSIESearthlink.net>
Date: Thu, 14 Mar 2002 15:39:05 GMT
Message-ID: <3C90C433.6240B87B@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 - 09:39:05 CST