Sample database volume layouts
Suggest changes
PDFs
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 |