Changes the attributes of a asm template

chtmpl -G diskgroup { [--striping {coarse|fine}]
 [--redundancy {high|mirror|unprotected} ] [--primary {hot|cold}] 
 [--secondary {hot|cold}]} template

SQL> SELECT dg.name AS diskgroup, t.name, t.stripe, t.redundancy, t.primary_region, t.mirror_region 
  2    FROM V$ASM_DISKGROUP dg, V$ASM_TEMPLATE t 
  3    WHERE dg.group_number = t.group_number and dg.name = 'EDG' ORDER BY t.name;

DISKGROUP                      NAME                 STRIPE REDUND PRIM MIRR
------------------------------ -------------------- ------ ------ ---- ----
EDG                            ARCHIVELOG           COARSE UNPROT COLD COLD
EDG                            ASMPARAMETERFILE     COARSE UNPROT COLD COLD
EDG                            AUTOBACKUP           COARSE UNPROT COLD COLD
EDG                            BACKUPSET            COARSE UNPROT COLD COLD
EDG                            CHANGETRACKING       COARSE UNPROT COLD COLD
EDG                            CONTROLFILE          FINE   UNPROT COLD COLD
EDG                            DATAFILE             COARSE UNPROT COLD COLD
EDG                            DATAGUARDCONFIG      COARSE UNPROT COLD COLD
EDG                            DUMPSET              COARSE UNPROT COLD COLD
EDG                            FLASHBACK            COARSE UNPROT COLD COLD
EDG                            FLASHFILE            COARSE UNPROT COLD COLD

DISKGROUP                      NAME                 STRIPE REDUND PRIM MIRR
------------------------------ -------------------- ------ ------ ---- ----
EDG                            OCRFILE              COARSE UNPROT COLD COLD
EDG                            ONLINELOG            COARSE UNPROT COLD COLD
EDG                            PARAMETERFILE        COARSE UNPROT COLD COLD
EDG                            TEMPFILE             COARSE UNPROT COLD COLD
EDG                            XTRANSPORT           COARSE UNPROT COLD COLD

16 rows selected.

ASMCMD> chtmpl -G EDG --primary hot ARCHIVELOG
ASMCMD> exit
->sqlplus / as sysasm

SQL*Plus: Release 11.2.0.2.0 Production on Fri Jun 24 14:31:20 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> SELECT dg.name AS diskgroup, t.name, t.stripe, t.redundancy, t.primary_region, t.mirror_region 
  2    FROM V$ASM_DISKGROUP dg, V$ASM_TEMPLATE t 
  3    WHERE dg.group_number = t.group_number and dg.name = 'EDG' ORDER BY t.name;

DISKGROUP                      NAME                 STRIPE REDUND PRIM MIRR
------------------------------ -------------------- ------ ------ ---- ----
EDG                            ARCHIVELOG           COARSE UNPROT HOT  COLD
EDG                            ASMPARAMETERFILE     COARSE UNPROT COLD COLD
EDG                            AUTOBACKUP           COARSE UNPROT COLD COLD
EDG                            BACKUPSET            COARSE UNPROT COLD COLD
EDG                            CHANGETRACKING       COARSE UNPROT COLD COLD
EDG                            CONTROLFILE          FINE   UNPROT COLD COLD
EDG                            DATAFILE             COARSE UNPROT COLD COLD
EDG                            DATAGUARDCONFIG      COARSE UNPROT COLD COLD
EDG                            DUMPSET              COARSE UNPROT COLD COLD
EDG                            FLASHBACK            COARSE UNPROT COLD COLD
EDG                            FLASHFILE            COARSE UNPROT COLD COLD

DISKGROUP                      NAME                 STRIPE REDUND PRIM MIRR
------------------------------ -------------------- ------ ------ ---- ----
EDG                            OCRFILE              COARSE UNPROT COLD COLD
EDG                            ONLINELOG            COARSE UNPROT COLD COLD
EDG                            PARAMETERFILE        COARSE UNPROT COLD COLD
EDG                            TEMPFILE             COARSE UNPROT COLD COLD
EDG                            XTRANSPORT           COARSE UNPROT COLD COLD

16 rows selected.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/46907/viewspace-700670/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/46907/viewspace-700670/