Datasheet

16 Chapter 1

Using Oracle ASM
You can see the templates associated with a given disk group by querying the V$ASM_
TEMPLATE
view, as shown in this example:
SQL> select * from v$asm_template
2 where group_number=2;
GROUP_NUMBER ENTRY_NUMBER REDUND STRIPE S NAME
------------ ------------ ------ ------ - --------------------
2 0 MIRROR COARSE Y PARAMETERFILE
2 1 MIRROR COARSE Y DUMPSET
2 2 HIGH FINE Y CONTROLFILE
2 3 MIRROR COARSE Y ARCHIVELOG
2 4 MIRROR FINE Y ONLINELOG
2 5 MIRROR COARSE Y DATA FILE
2 6 MIRROR COARSE Y TEMPFILE
2 7 MIRROR COARSE Y BACKUPSET
2 8 MIRROR COARSE Y AUTOBACKUP
2 9 MIRROR COARSE Y XTRANSPORT
2 10 MIRROR COARSE Y CHANGETRACKING
2 11 MIRROR FINE Y FLASHBACK
2 12 MIRROR COARSE Y DATAGUARDCONFIG
2 13 MIRROR COARSE N NEW_TEMPLATE
In this output, you can see that our new template (new_template) has been created and is
ready for use. You can drop a template with the
alter diskgroup command using the drop
template
parameter, as shown in this example:
ALTER DISKGROUP sp_dgroup2
DROP TEMPLATE new_template;
And you can alter a user-defined template with the alter template parameter of the
alter diskgroup command. Notice in this example that we are actually changing one of
the attributes of the default templates. You cannot drop the default templates, but you can
modify them, as shown here:
ALTER DISKGROUP sp_dgroup2
ALTER TEMPLATE datafile
ATTRIBUTES (coarse);
ASM Disk Group Attributes
We have discussed ASM templates that define a set of attributes to the disk group assigned
to them. Oracle Database 11g also allows you to define specific disk group attributes. Disk
95134c01.indd 16 1/28/09 9:43:42 AM