ASMCMD [+DATA/dummy/parameterfile] > help chtmpl
chtmpl [--striping ] [--redundancy ] [--primary ] [--secondary ] name
更改已存在的模版的属性
-G disk group to place the template in
[--striping ] striping (Coarse|Fine)
[--redundancy ] redundancy (Unprotected|Mirror|High)
[--primary ] primary region (Hot|Cold)
[--secondary ] secondary region (Hot|Cold)
name name of the template
实验演示更改ARCHIVELOG 的 primary 属性由cold到hot。其他一次类推。
SQL> col diskgroup for a10
SQL> col name for a20
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 = 'DATA' ORDER BY t.name;
DISKGROUP NAME STRIPE REDUNDANCY PRIMARY_ MIRROR_R
---------- -------------------- ------------ ------------ -------- --------
DATA ARCHIVELOG COARSE MIRROR COLD COLD
DATA ASMPARAMETERBAKFILE COARSE MIRROR COLD COLD
DATA ASMPARAMETERFILE COARSE MIRROR COLD COLD
DATA ASM_STALE COARSE HIGH COLD COLD
DATA AUTOBACKUP COARSE MIRROR COLD COLD
DATA BACKUPSET COARSE MIRROR COLD COLD
DATA CHANGETRACKING COARSE MIRROR COLD COLD
DATA CONTROLFILE FINE HIGH COLD COLD
DATA DATAFILE COARSE MIRROR COLD COLD
DATA DATAGUARDCONFIG COARSE MIRROR COLD COLD
DATA DUMPSET COARSE MIRROR COLD COLD
11 rows selected.
进行更改。
ASMCMD [+DATA/rac] > chtmpl -G DATA --primary hot ARCHIVELOG
ASMCMD [+DATA/rac] >
ASMCMD [+DATA/rac] >
再次查询
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 = 'DATA' ORDER BY t.name;
DISKGROUP NAME STRIPE REDUNDANCY PRIMARY_ MIRROR_R
---------- -------------------- ------------ ------------ -------- --------
DATA ARCHIVELOG COARSE MIRROR HOT COLD
DATA ASMPARAMETERBAKFILE COARSE MIRROR COLD COLD
DATA ASMPARAMETERFILE COARSE MIRROR COLD COLD
DATA ASM_STALE COARSE HIGH COLD COLD
DATA AUTOBACKUP COARSE MIRROR COLD COLD
DATA BACKUPSET COARSE MIRROR COLD COLD
DATA CHANGETRACKING COARSE MIRROR COLD COLD
DATA CONTROLFILE FINE HIGH COLD COLD
DATA DATAFILE COARSE MIRROR COLD COLD
DATA DATAGUARDCONFIG COARSE MIRROR COLD COLD
DATA DUMPSET COARSE MIRROR COLD COLD
11 rows selected.
SQL>
