Re: standby database
- From: Mark Brinsmead <pythianbrinsmead@xxxxxxxxx>
- To: kp0773@xxxxxxxxx
- Date: Wed, 12 May 2010 19:42:36 -0600
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:
