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.2E.+DG2A/datafile/dev19.users.02.701.2
答案：（B）
解析：
生成格式为：+diskgroup/dbname/file_type/file_type_tag.file.incarnation，
? +diskgroup：磁盘组名称；
? dbname：数据库的DB_UNIQUE_NAME参数值；
? file_type：创建的文件类型，比如CONTROLFILE/DATAFILE/ONLINELOG/ARCHIVELOG/TEMPFILE/BACKUPSET/FLASHBACK等等；
? 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 |