Naming filesystems example
                                                 Last update (2008-02-21 13:02:45)
                                                                                                                   Date added (2008-02-21 12:47:30)

Summary
We said for the example of 1TB OLTP Unix database the following Filesystems
Oracle software: 1 filesystem(30GB is enough)
For the datafiles: 10 filesystems (100GB each) is good enough. Don't use for instance less than 5, it won't be good for Disk I/O performance
For redologs: 5 filesystems, very small (10GB each) is good enough
For controlfiles: 3 filesystems, very small (use the same for redologs)
For archives: 1 filesystem (100GB) setting Rman backup every 6 hours with delete input.
For trace files, exports, scripts, etc: 1 filesystem (200GB)

A more detailed analyses with names follows
Software
/filesystem01/oracle/product/10gr2/

Datafiles
/filesystem02/oradata/sid/datafiles/
/filesystem03/oradata/sid/datafiles/
/filesystem04/oradata/sid/datafiles/
/filesystem05/oradata/sid/datafiles/
/filesystem06/oradata/sid/datafiles/
/filesystem07/oradata/sid/datafiles/
/filesystem08/oradata/sid/datafiles/
/filesystem09/oradata/sid/datafiles/
/filesystem10/oradata/sid/datafiles/
/filesystem11/oradata/sid/datafiles/

Redologs 5 groups, 2 members each
/filesystem12/oradata/sid/redo_control/redologs/
/filesystem13/oradata/sid/redo_control/redologs/
/filesystem14/oradata/sid/redo_control/redologs/
/filesystem15/oradata/sid/redo/redologs/
/filesystem16/oradata/sid/redo/redologs/

Controlfiles 3 controlfiles
/filesystem12/oradata/sid/redo_control/controlfiles/
/filesystem13/oradata/sid/redo_control/controlfiles/
/filesystem14/oradata/sid/redo_control/controlfiles/

Archives
/filesystem17/oradata/sid/archives/

Trace, dmp for exports, other programs
/filesystem18/oradata/sid/other/trace/bdump/
/filesystem18/oradata/sid/other/trace/udump/
/filesystem18/oradata/sid/other/trace/cdump/
/filesystem18/oradata/sid/other/dmp/
/filesystem18/oradata/sid/other/programs/
Reviews
Filters
Search