535.To reference existing ASM files, you need to use a fully qualified ASM filename. Your development
database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to
reference is a datafile for the USERS02 tablespace.
Which of the following is a valid ASM filename for this ASM file?
A. dev19/+DG2A/datafile/users02.701.2
B. +DG2A/dev19/datafile/users02.701.2
C. +DG2A/dev19/users02/datafile.701.2
D. +DG2A.701.2
E. +DG2A/datafile/dev19.users.02.701.2
Answer: B
答案解析：
参考：http://blog.csdn.net/rlhua/article/details/12972983
生成格式为：+diskgroup/dbname/file_type/file_type_tag.file.incarnation ，
• +diskgroup ：磁盘组名称；
• dbname ：数据库的DB_UNIQUE_NAME参数值；
• file_type ：创建的文件类型，比如CONTROLFILE/DATAFILE/ONLINELOG/ARCHIVELOG/TEMPFILE/BACKUPSET/FLASHBAC
K等等；
• file_type_tag ：文件类型的标签，比如表空间对应的通常为该表空间名称；
• file.incarnation ：文件序号+incarnation，用来确保文件的唯一；
sys@TEST0924> alter tablespace INVENTORY add datafile '+DATA';
Tablespace altered.
ASMCMD> pwd
+data/test0924/datafile
ASMCMD> ls
INVENTORY.266.829658135
sys@TEST0924> alter tablespace INVENTORY add datafile '+DATA/test0924/datafile/inventory03.dbf' SIZE 10m;
Tablespace altered.
ASMCMD> ls
INVENTORY.264.829668701
INVENTORY.266.829658135
inventory03.dbf