Question: I need to know the standard
conventions for naming Oracle data files? Does Oracle
have suggested data file naming suggestions?
Answer: Yes, Oracle has the Optimal Flexible
Architecture for data file naming standards. There are
different naming methods for Automatic Storage Management
(ASM) vs. plain Oracle data files:
Non
ASM Data Files
For non-ASM
data file naming standards and conventions, see
my notes on Oracle file naming conventions
ASM
Files
ASM will create the required files. ASM assigns each file
a fully qualified name ending in a dotted pair of numbers.
More user-friendly alias names can be created for the
Automated Storage Management filenames by using ASM aliases.
For example, here we create an alias for an ASM file
name:
--
Create an alias doe an ASM datafile
alter diskgroup disk_group_1
add alias
'+DISK_GROUP_1/oratst1/datafile/my_system_dbf'
for
'+DISK_GROUP_1/oratst1/datafile/system.1122.764387443';
Once you have defined an alias for an ASM data file
name, the file name will appear in the
Also see below, the
names of the v$ASM views.
and
Oracle ASM Parameters.
[http://www.dba-oracle.com/include_tuning_book3.htm]
