Sample database volume layouts

Contributors Download PDF of this page

You can refer to sample database volume layouts for help in configuring your database.

Single-instance databases

File types Volume names Dedicated volume for file types Automatic Snapshot copies

Oracle binaries

orabin_host name

Yes

On

Data files

oradata_sid

Yes

Off

Temporary data files

oratemp_sid

Yes

Off

Control files

oracntrl01_sid (Multiplexed)

oracntrl02_sid (Multiplexed)

Yes

Off

Redo logs

oralog01_sid (Multiplexed)

oralog02_sid (Multiplexed)

Yes

Off

Archive logs

oraarch_sid

Yes

Off

Real Application Clusters (RAC) databases

File types Volume names Dedicated volume for file types Automatic Snapshot copies

Oracle binaries

orabin_host name

Yes

On

Data files

oradata_dbname

Yes

Off

Temporary data files

oratemp_dbname

Yes

Off

Control files

oracntrl01_dbname (Multiplexed)

oracntrl02_dbname (Multiplexed)

Yes

Off

Redo logs

oralog01_dbname (Multiplexed)

oralog02_dbname (Multiplexed)

Yes

Off

Archive logs

oraarch_dbname

Yes

Off

Cluster files

oracrs_clustername

Yes

On

Single instance of an Automatic Storage Management (ASM) database

File types Volume names LUN names Dedicated volume for file types Automatic Snapshot copies

Oracle binaries

orabin_host name

orabin_host namelun

Yes

On

Data files

oradata_sid

oradata_sidlun

Yes

Off

Temporary data files

oratemp_sid

Oratemp_sidlun

Yes

Off

Control files

oracntrl01_sid (Multiplexed)

oracntrl02_sid (Multiplexed)

oracntrl01_sidlun (Multiplexed)

oracntrl02_sidlun (Multiplexed)

Yes

Off

Redo logs

oralog01_dbname (Multiplexed)

oralog02_dbname (Multiplexed)

oralog01_dbnamelun (Multiplexed)

oralog02_dbnamelun (Multiplexed)

Yes

Off

Archive logs

oraarch_sid

Oraarch_sidlun

Yes

Off

ASM RAC databases

File types Volume names LUN names Dedicated volume for file types Automatic Snapshot copies

Oracle binaries

orabin_host name

orabin_host namelun

Yes

On

Data files

oradata_sid

oradata_sidlun

Yes

Off

Temporary data files

oratemp_sid

Oratemp_sidlun

Yes

Off

Control files

oracntrl01_sid (Multiplexed)

oracntrl02_sid (Multiplexed)

oracntrl01_sidlun (Multiplexed)

oracntrl02_sidlun (Multiplexed)

Yes

Off

Redo logs

oralog01_dbname (Multiplexed)

oralog02_dbname (Multiplexed)

oralog01_dbnamelun (Multiplexed)

oralog02_dbnamelun (Multiplexed)

Yes

Off

Archive logs

oraarch_sid

Oraarch_sidlun

Yes

Off

Cluster files

oracrs_clustername

oracrs_clusternamelun

Yes

On