Database Files layout

Recommendation to store the files of the
database system on different physical disks. In this example, the control file
is mirrored twice:

Disk
Number

Directory

Contents of
Directory

1

origlogA

Online redo log
files from the first and third group (Set A)

2

origlogB

Online redo log
files from the second and fourth group (Set B)

3

mirrlogA

Mirrored online
redo log files from the first and third group (Set A)

4

mirrlogB

Mirrored online
redo log files from the second and fourth group (Set B)

5

sapdata1

Database files,
mirror of the control file

6

sapdata2

Database files,
mirror of the control file

7

sapdata<n>

Other database
files in sapdata3 up to
sapdata<n>, each on separate disks when
possible

For performance reasons, it is recommended to distribute the online redo log groups to four disks

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: