Fully Qualified ASM File Names

Every file created in ASM gets a system-generated file name, known as the fully qualified file name. You cannot set the fully qualified file name. The fully qualified file name represents a complete path name in the ASM file system. An example of a fully qualified file name is:

+DATA/racdb/DATAFILE/SYSTEM.262.676172197

You can use the fully qualified file name to reference (read or retrieve) an ASM file.

You can also use other abbreviated file name formats, such as an alias ASM file name to reference an ASM file.

You can find the fully qualified file name in database views displaying Oracle Database file names, such as V$DATAFILE and V$LOGFILE.

A fully qualified file name has the following form:

+group/dbname/file_type/file_type_tag.file.incarnation

where:

• +group is the disk group name preceded by a plus sign. You can think of the plus sign as the root of the ASM file system, similar to the slash (/) on UNIX or Linux file systems.
• dbname is the DB_UNIQUE_NAME of the database to which the file belongs.
• file_type is the Oracle Database file type.
• file_type_tag is type-specific information about the file.
• file.incarnation is the file/incarnation pair, used to ensure uniqueness.

Examples

+DATA/ORA11g/DATAFILE/SYSTEM.262.676172197
+DATA/ORA11g/PARAMETERFILE/spfile.268.676172697
+DATA/ORA11g/CONTROLFILE/Current.257.676172363
+DATA/ORA11g/ONLINELOG/group_1.256.676172371
+FRA/ORA11g/CONTROLFILE/Backup.275.676172942


Other ASM File Names

In addition to the fully qualified file name, the following other ASM file names can be used in various different situations:

Numeric ASM file name

Format: <+group>.<file>.<incarnation>
Example: +DATA.262.676172197

Alias ASM file name

Format: <+group>/<alias>
Example: +DATA/my_dir/my_other_dir/my_file_name.dbf

Alias ASM file name with template

Format: <+group>(<template>)/<alias>
Example: +DATA(my_template)/my_dir/my_other_file_name.dbf

Incomplete ASM file name

Format: <+group>

Incomplete ASM file name with template

Format: <+group>(<template>)
Example: +DATA(my_template)