9.6. Understanding ASM File Types and Templates

ASM supports all types of files used by the database except for files such as operating system executables. Table 9.3 contains the complete list of ASM file types; File Type and Tag are those presented previously for ASM file-naming conventions.

Table 9.3. ASM File Types
Oracle File TypeFile TypeTagDefault Template
Control filescontrolfilecf (control file) or bcf (backup control file)CONTROLFILE
Datafilesdatafiletablespace name.file#DATAFILE
Online logsonline_loglog_thread#ONLINELOG
Archive logsarchive_logParameterARCHIVELOG
Temp filestemptablespace name.file#TEMPFILE
RMAN datafile backup piecebackupsetClient-specifiedBACKUPSET
RMAN incremental backup piecebackupsetClient-specifiedBACKUPSET
RMAN archive log backup piecebackupsetClient-specifiedBACKUPSET
RMAN datafile copydatafiletablespace name.file#DATAFILE
Initialization parametersinitspfilePARAMETERFILE
Broker configdrcdrcDATAGUARDCONFIG
Flashback logsrlogthread#_log#FLASHBACK
Change tracking bitmapctbbitmapCHANGETRACKING
Auto backupautobackupClient-specifiedAUTOBACKUP
Data Pump dumpsetdumpsetdumpDUMPSET
Cross-platform datafiles  XTRANSPORT

Table 9.4 lists the default ASM file templates referenced in the Default Template column of Table 9.3.

Table 9.4. ASM File Templates
System TemplateExternal RedundancyNormal RedundancyHigh RedundancyStriping
CONTROLFILEUnprotectedTwo-way mirroringThree-way mirroringFine
DATAFILEUnprotectedTwo-way mirroringThree-way mirroringCoarse
ONLINELOGUnprotectedTwo-way mirroringThree-way mirroringFine
ARCHIVELOGUnprotectedTwo-way mirroringThree-way mirroringCoarse
TEMPFILEUnprotectedTwo-way mirroringThree-way mirroringCoarse
BACKUPSETUnprotectedTwo-way mirroringThree-way mirroringCoarse
XTRANSPORTUnprotectedTwo-way mirroringThree-way mirroringCoarse
PARAMETERFILEUnprotectedTwo-way mirroringThree-way mirroringCoarse
DATAGUARDCONFIGUnprotectedTwo-way mirroringThree-way mirroringCoarse
FLASHBACKUnprotectedTwo-way mirroringThree-way mirroringFine
CHANGETRACKINGUnprotectedTwo-way mirroringThree-way mirroringCoarse
AUTOBACKUPUnprotectedTwo-way mirroringThree-way mirroringCoarse
DUMPSETUnprotectedTwo-way mirroringThree-way mirroringCoarse

NOTE

The mirroring options in the High Redundancy column of Table 9.4 are discussed in the next section under "Understanding Disk Group Architecture."

When a new disk group is created, a set of ASM file templates copied from the default templates in Table 9.3 is saved with the disk group. As a result, individual template characteristics can be changed and apply only to the disk group where they reside. In other words, the DATAFILE system template in disk group +DATA1 may have the default coarse striping, but the DATAFILE template in disk group +DATA2 may have fine striping. You can create your own templates in each disk group as needed.

When an ASM datafile is created with the DATAFILE template, by default, the datafile is 100MB, the datafile is autoextensible, and the maximum size is unlimited.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset