Re: oracle on sun solaris

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sat, 17 Jun 2006 02:45:33 GMT
Message-Id: <pan.2006.06.17.02.46.52.549200@gmail.com>

On Sat, 17 Jun 2006 00:56:26 +0000, Bob Jones wrote:

> 
> "Connor McDonald" <connor_mcdonald_at_yahoo.com> wrote in message 
> news:4492BA03.525C_at_yahoo.com...
>> Bob Jones wrote:

>>>
>>> >
>>> > I'm an fan of raw - not just because it gives the best performance
>>> > (since you can the same with file systems if done properly), but it
>>> > instils a lovely discipline with datafile management.
>>> >
>>>
>>> I think it is more harsh than lovely.
>>>
>>> > You'll still need a file system for archive logs anyway - a decent CFS
>>> > makes handling failover and RAC easier to look after
>>>
>>> Why is this only the case for failover or RAC?
>>>
>>> > Connor McDonald
>>> > Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
>>> > Co-author: "Oracle Insight - Tales of the OakTable"

>>
>> Because for things like recovery, a node may need access to an archive
>> log that it did not write...so a CFS can assist.
>>
> 
> Sure, but in general filesystems are easier to manage than raw, not just in 
> the case of failoever or RAC. In fact you cannot use raw for archive logs.

Ease of use is relative - often to experience. I happen to be comfortable with such comands as 'dd' and 'cpio' in the environments in which I work regularily. Therefore I do not find raw to be an issue. In fact I have far more problems with NTFS than with raw.

Your mileage may vary based on your experience.

2) Generalized filesystem often have utilties that make administration and access to individual files easier. This is not a function of the filesystem as much as a function of the utilities that people or companies have developed.

Therefore, the comparison should not be between filesystem and raw, but between the utilities supporting filesystems and raw devices.

For utilities supporting raw that are relevant to an Oracle environment look at RMAN, ASM and Flash Recovery Area as well as the native support such as as cpio and dd.

3) Flash Recovery Area can handle Archive Log Files. As can RMAN. Both can deal with raw devices (most easily using ASM). RMAN adds tape capability.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Fri Jun 16 2006 - 21:45:33 CDT