Re: standby database

As long as you plan and configure everything correctly, NFS can be just
fine.

That means using a "supported" NFS server, supported mount options, a sane
network configuration, etc.  Do your homework, be prepared to spend an
appropriate amount of money, and you will be fine.

Like Bradd, I have seen Oracle-on-NFS work swimmingly when done well, but I
have seen it work very poorly indeed when under-provisioned or
misconfigured.  From at least Oracle9, the database software will refuse to
open an instance (or to do backups) when you have the mount options wrong,
but nobody (except maybe your customers) is going to prevent you from trying
to run your NFS over a congested 10 Mbit network.

Cheers,
-- Mark.



On Wed, May 12, 2010 at 4:14 PM, K R <kp0773@xxxxxxxxx> wrote:

> Thanks Bradd,
>
> concern is on  trying to find if  any bugs or any performance issues . It
> is going to be on both 9i and 11g
>
>
> On Wed, May 12, 2010 at 3:06 PM, Bradd Piontek <piontekdd@xxxxxxxxx>wrote:
>
>> What types of issues?
>>
>> I have seen clients running primary and standby (9i managed standby) on
>> NFS (NetApp Filers) and getting good IO performance (directIO and
>> dbwr_io_slaves are  mandatory).
>>
>> Bradd Piontek
>> Pythian - Love Your Data
>>
>>
>> On Wed, May 12, 2010 at 4:01 PM, K R <kp0773@xxxxxxxxx> wrote:
>>
>>> All,
>>>
>>> Is there any issues setting up a standby database on a NFS filesystem...
>>>
>>> Please let me know
>>>
>>> appreciate any suggestion
>>>
>>> TIA
>>> kart
>>>
>>
>>
>


-- 
Cheers,
-- Mark Brinsmead
  Senior DBA,
  The Pythian Group
  http://www.pythian.com/blogs

Other related posts: