OCP-1Z0-053-V12.02-535题

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