（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.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

ITPub博客

Oracle 11G OCP 1Z0-053 535

最新文章