Re: OFA Compliant database

On 1 Sep 1998 23:28:02 GMT, Flemming Nielsen <brydning_at_image.dk> wrote:
>Hi
>
>No problems - Oracle is recommending 4 disk drived (or more) for security
>and performance reasons.
>
>If your disk is crashing ALL your executables, datafiles, redofiles,
>controlfiles and archive files is lost.
>
>When using more than one disk you have parallel access to datafiles,
>indexfiles and redologs - if your bus allows this. (SCSII does)

Besides that, it would not be useful to have 4 partitions on the same disk. You might as well put everything on the same partition, so you don't have wasted unused partitioned space, with disk heads wasting a lot of time searching over empty space. The point is to have things in different directories, so when performance becomes an issue, you can move things to different drives. This is less of an issue if you have "one" drive because it is actually an array, so things are spread out across disk drives anyways. If you really just have one big disk, relax, people do it all the time. Just don't expect maximum performance, it will thrash.

The other reason for partitions is backups, so the limitation there is if you want to have hot backups, you need to have an extra partition big enough to hold your largest tablespace set, so you can put the tablespace into hot backup mode, copy and/or compress it to the partition, take the ts out of hot backup, then copy the partition to tape at your leisure. The archive log handling is also important, all I'll say about that is get the backups handbook. If you are using cold backups, you have to backup all the stuff anyways, so partitioning just slows you down (although it could speed up a restore, depending on your circumstances).

>
>
>Praveen Khurana <pkk_at_inpart.com> skrev i artiklen
><35EC47BD.F1A5EA09_at_inpart.com>...
>> Hi
>>
>> Iam planning to install Oracle 8.0.4 on Sun OS 5.5.1. I want to make
>> it OFA compliant. All the installation manuals say that I should have
>> four disk drives, one for Oracle Software and 3 for database.
>>
>> Can I have four volumes(partitions) on one drive and still make the
>> database OFA compliant ?

In short, yes, but that misses the point. OFA compliance can seem like a pain with a simple system, but as the system grows and becomes more complex it really helps.

>>
>> Thanks
>>
>> Praveen
>>
>>

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Sep 03 1998 - 16:47:15 CDT