Database Disk Partitions

Specification for a minimal installation or testing platform

With 8 * 146Gb drives in a Raid 5 configuration, there is approximately 800GB of usable space. The server disks should be configured as a RAID 5 array and partitioned as follows:

Partition	Approx. Size	Purpose	Mount point
1	20 GB	Operating System
2	20 GB	Paging
3	400 GB	Database files	/u01 or c:/u01 Referred to below as $database
4	200 GB	Application installations and file data	/u02 or c:/u02 Referred to below as $app
5	100 GB	Archive Log space	/archive or c:/archive

Notes: All file system path names are written using a forward slash ‘/’ directory separator. On Windows forward and back slashes are considered to be equivalent, though there are still a few areas where back slashes must be used.

Specification for a medium installation

Three Disk groups will have the following usable space:

Disk Group	Nbr Drives	Raid	Approx Usable Space
Disk Group 1	8 * 300GB	5 (7+1)	1900GB
Disk Group 2	4 * 146GB	1+0	270GB
Disk Group 3	2 * 146GB	1+0	135GB

Disk Group 1

With 8 * 300Gb drives in a Raid 5 configuration, there is approximately 1900GB of usable space. The server disks should partitioned as follows:

Partition	Approx. Size	Purpose	Mount point
1	20 GB	Operating System
2	20 GB	Paging
3	1400 GB	Database files	/u01 or c:/u01 Referred to below as $database
4	200 GB	Application installations and file data	/u02 or c:/u02 Referred to below as $app
5	100GB	Archive Log	/archive or C:/archive

Disk Group 2

With 4 * 146Gb drives in a Raid 1+0 configuration, there is approximately 270GB of usable space. The server disks should be partitioned as follows:

Partition	Approx. Size	Purpose	Mount point
1	200 GB	Oracle Redo	/redo1
2	200 GB	Oracle Redo	/redo2

Disk Group 3

With 2 * 146Gb drives in a Raid 1+0 configuration, there is approximately 135GB of usable space. The server disks should be partitioned as follows:

Partition	Approx. Size	Purpose	Mount point
1	130 GB	Oracle Undo	/undo