SQL> alter diskgroup data
2 add alias '+data/purch/users.dbf'
3 for '+data/dw/datafile/users.259.627432977';
Diskgroup altered.
SQL>
Alias with Template Names
An alias with a template can only be used when creating a new ASM file. Templates provide a
shorthand for specifying a file type and a tag when creating a new ASM file. Here??™s an example
of an alias using a template for a new tablespace in the +DATA disk group:
SQL> create tablespace users2 datafile '+data(datafile)';
Tablespace created.
The template datafile specifies COARSE striping, MIRROR for a normal-redundancy group,
and HIGH for a high-redundancy group; it is the default for a datafile. Because we did not fully
qualify the name, the ASM name for this diskgroup is as follows:
+DATA/dw/datafile/users2.267.627782171
I??™ll talk more about ASM templates in the section ???ASM File Types and Templates??? later in this
chapter.
Incomplete Names
An incomplete filename format can be used either for single-file or multiple-file creation operations.
Only the disk group name is specified, and a default template is used depending on the type of
file, as shown here:
SQL> create tablespace users5 datafile '+data1';
Tablespace created.
Incomplete Names with Template
As with incomplete ASM filenames, an incomplete filename with a template can be used either
for single-file or multiple-file creation operations. Regardless of the actual file type, the template
name determines the characteristics of the file.
Pages:
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207