Re: NFS mounted stale redo log

From: DA Morgan <damorgan_at_psoug.org>
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.org
Received on Tue Feb 12 2008 - 17:57:40 CST

Original text of this message