ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Changes the attributes of a asm template

Changes the attributes of a asm template

原创 Linux操作系统 作者:nokilled 时间:2011-06-24 14:59:36 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ASM manage script
下一篇: awk -f ass109.awk
请登录后发表评论 登录
全部评论

注册时间:2007-12-30

  • 博文量
    108
  • 访问量
    286703