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

来源:互联网 发布:二维数组的几种定义 编辑:程序博客网 时间:2024/06/06 12:59

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

原创粉丝点击