General
cancel
Showing results for 
Search instead for 
Did you mean: 

Preferred SAPDB filesystem layout

SOLVED
Go to solution
Klaas D. Eenkhoorn
Regular Advisor

Preferred SAPDB filesystem layout

Dear all,

Who can tell me from experience what filesystem layout is the best for a SAPDB database ?
The database will be used in combination with SAP Content Server 6.3 on HPUX 11.11 and will be small to medium of size.
Is the basic layout from sap the best like ;

sapdata1
sapdata2
sapdata3
sapdata4
sapdata5
mirrorloga
mirrorlogb
etc.

or is there an other layout better ?

Greetzzzz,

Klaas Eenkhoorn
2 REPLIES
Eric Antunes
Honored Contributor
Solution

Re: Preferred SAPDB filesystem layout

Hi Klaas,

You should ensure effective mirroring of redolog files for EACH redolog GROUP and this is the doubt I have with this basic SAP layout. What you should have:

- 2 (minimum) or 3 redolog groups
- Each redolog should have 2 multiplexed redolog files: each redolog file on a separate logical volume. For example:

GROUP 1:
/disc1/sap/log1a.dbf
/disc2/sap/log1b.dbf
GROUP 2:
/disc1/sap/log2a.dbf
/disc2/sap/log2b.dbf

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Klaas D. Eenkhoorn
Regular Advisor

Re: Preferred SAPDB filesystem layout

Thanks !