ASM Disk Group Template
一、template定義、作用
Templates are used to set redundancy (mirroring) and striping attributes of files created in an ASM disk group. When a file is created, redundancy and striping attributes are set for that file based on an explicitly named template or the system template that is the default template for the file type.
When a disk group is created, ASM creates a set of default templates for that disk group. The set consists of one template for each file type (data file, control file, redo log file, and so on) supported by ASM. For example, a template named ONLINELOG provides the default file redundancy and striping attributes for all redo log files written to ASM disks.
Default template settings depend on the disk group type. For example, the default template for datafiles for a normal redundancy disk group sets 2-way mirroring, while the corresponding default template in a high redundancy disk group sets 3-way mirroring.You can modify these default templates.
The V$ASM_TEMPLATE view lists all of the templates known to the ASM instance.
二、Adding Templates to a Disk Group
To add a new template for a disk group, you use the ADD TEMPLATE clause of the ALTER DISKGROUP statement. You specify the name of the template, its redundancy attribute, and its striping attribute.
語法:
ALTER DISKGROUP disk_group_name ADD TEMPLATE template_name
ATTRIBUTES ([{MIRROR|HIGH|UNPROTECTED}] [{FINE|COARSE}]);
Both types of attribute are optional. If no redundancy attribute is specified, the value defaults to MIRROR for a normal redundancy disk group, HIGH for a high redundancy disk group, and UNPROTECTED for an external redundancy disk group. If no striping attribute is specified, the value defaults to COARSE.
If the name of your new template is not one of the names listed in Table below, it is not used as a default template for database file types. To use it, you must reference its name when creating a file.如:+dgroup(template_name)/alias --Alias ASM Filename with Template;
+dgroup1(my_template) --Incomplete ASM Filename with Template
ASM System Default Templates Attribute Settings
Template Name |
Striping |
Mirroring, Normal Redundancy Disk Group |
Mirroring, High Redundancy Disk Group |
Mirroring, External Redundancy Disk Group |
CONTROLFILE |
FINE |
HIGH |
HIGH |
UNPROTECTED |
DATAFILE |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
ONLINELOG |
FINE |
MIRROR |
HIGH |
UNPROTECTED |
ARCHIVELOG |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
TEMPFILE |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
BACKUPSET |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
PARAMETERFILE |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
DATAGUARDCONFIG |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
FLASHBACK |
FINE |
MIRROR |
HIGH |
UNPROTECTED |
CHANGETRACKING |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
DUMPSET |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
XTRANSPORT |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
AUTOBACKUP |
COARSE |
MIRROR |
HIGH |
UNPROTECTED |
三、Modifying a Disk Group Template
The ALTER TEMPLATE clause of the ALTER DISKGROUP statement enables you to modify the attribute specifications of an existing system default or user-defined disk group template. Only specified template properties are changed. Unspecified properties retain their current value.
例如:ALTER DISKGROUP dgroup2 ALTER TEMPLATE reliable
ATTRIBUTES (COARSE);
四、Dropping Templates from a Disk Group
Use the DROP TEMPLATE clause of the ALTER DISKGROUP statement to drop one or more templates from a disk group. You can only drop templates that are user-defined; you cannot drop system default templates.
如:ALTER DISKGROUP dgroup2 DROP TEMPLATE unreliable;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25744374/viewspace-731418/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle ASM spfile in a disk groupOracleASM
- Oracle ASM ACFS disk group rebalanceOracleASM
- Oracle ASM Disk Group AttributesOracleASM
- ASM disk group mount fails with ORA-15036ASMAI
- ORA-15260: permission denied on ASM disk groupASM
- How to move ASM spfile to a different disk group [ID 1082943.1]ASM
- ASM disk group mount fails with ORA-15036: disk is truncated [ID 1077175.1]ASMAI
- 移動ASM的spfile到一個新的disk groupASM
- drop asm disk、撤銷drop asm diskASM
- 規劃ASM DISK GROUP、檢視asm 磁碟當前狀態、mount or dismount 磁碟組ASM
- 手工建立ASM Disk Groups、為 ASM Disk Groups 新增 diskASM
- Asm disk managerASM
- ASM DISK Group載入ORA-15183錯誤一例ASM
- Oracle ASM Template DirectoryOracleASM
- Oracle ASM Disk DirectoryOracleASM
- Oracle ASM Disk PartnerOracleASM
- ASM: Device is already labeled for ASM diskASMdev
- Oracle ASM Disk HeaderOracleASMHeader
- asm中template特性測試!ASM
- Oracle ASM Disk Used Space DirectoryOracleASM
- ASM DISK HEADER CORRUPTION & REPAIRASMHeaderAI
- ASM Normal需要3個disk ?ASMORM
- asm disk 的結構(1)ASM
- oracleasm createdisk ASM: Device is already labeled for ASM diskOracleASMdev
- ASM 翻譯系列第十彈:ASM Internal ASM DISK headerASMHeader
- Using ASMLIB Management ASM DiskASM
- [Oracle Script] ASM Disk Groups UsedOracleASM
- ASM磁碟組刪除DISK操作ASM
- Identify If A Disk/Part Is Still Used By ASM,Used by ASM Or Used by ASM_603210.1IDEASM
- Mount ASM Disk Group Fails : ORA-15186, ORA-15025, ORA-15063_1384504.1ASMAI
- Oracle ASM User Directory and Group DirectoryOracleASM
- RAC關鍵資訊(OCR/VOTE DISK/ASM DISK HEADER)備份ASMHeader
- ASM 11g New Features - How ASM Disk Resync WorksASM
- Oracle ASM disk誤被格式化OracleASM
- V$ASM_DISK 檢視含義ASM
- 11g ASM asm_preferred_read_failure_groupASMAI
- ASM Failure Group的一點理解ASMAI
- 使用KFOD模擬ASM DISK DISCOVERY過程ASM