Re: NFS mounted stale redo log
Date: Tue, 12 Feb 2008 15:57:40 -0800
Message-ID: <1202860636.346317@bubbleator.drizzle.com>
rjlolli wrote:
> We have come across a strange situation concerning redo logs that are
> NFS mounted. We have an Oracle database with 4 redo log groups with 3
> members in each group. Of the 3 members, one of those member is NFS
> mounted remotely. From time to time, Oracle will mark the NFS mounted
> redo log member stale for a split second and then it's status will go
> back to normal. I had always thought once Oracle marks a redo log
> stale it remains stale until Oracle cycles back around through log
> switches. Why is Oracle doing this? Is there a parameter that will
> assure us the member remains stale? My theory is that the NFS mounted
> redo log is marked stale for such a short period of time that Oracle
> is re-synching it with the remaining 2 local members and moving on.
> Please help if you have any ideas. Thanks.
>
> BTW. This is on Oracle 9.2
Joel Garry's questions but, specifically, whose NFS mount. Name the vendor and the NFS version and provide the fstab entry.
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Tue Feb 12 2008 - 17:57:40 CST