Prev | Current Page 196 | Next

Richard Niemiec

"Oracle Database 10g Performance Tuning Tips & Techniques"


Even though we are creating a tablespace in the following example, the striping and mirroring
characteristics of an online log file (fine striping) are used for the new tablespace instead as the
attributes for the datafile (coarse striping):
SQL> create tablespace users6 datafile '+data1(onlinelog)';
Tablespace created.
ASM File Types and Templates
ASM supports all types of files used by the database except for operating system executables.
Table 4-4 contains the complete list of ASM file types; the ASM File Type and Tag columns are
those presented previously for ASM filenaming conventions.
106 Oracle Database 11g DBA Handbook
Oracle File Type ASM File
Type
Tag Default Template
Control files controlfile cf (control file)
or bcf (backup
control file)
CONTROLFILE
Data files datafile tablespace
name.file#
DATAFILE
Online logs online_log log_thread# ONLINELOG
Archive logs archive_log parameter ARCHIVELOG
Temp files temp tablespace
name.file#
TEMPFILE
RMAN datafile
backup piece
backupset Client specified BACKUPSET
RMAN incremental
backup piece
backupset Client specified BACKUPSET
RMAN archive log
backup piece
backupset Client specified BACKUPSET
RMAN datafile copy datafile tablespace
name.file#
DATAFILE
Initialization
parameters
init spfile PARAMETERFILE
Broker config drc drc DATAGUARDCONFIG
Flashback logs rlog thread#_log# FLASHBACK
Change tracking
bitmap
ctb bitmap CHANGETRACKING
Auto backup autobackup Client specified AUTOBACKUP
Data Pump dumpset dumpset dump DUMPSET
Cross-platform data
files
XTRANSPORT
TABLE 4-4 ASM File Types
The default ASM file templates referenced in the last column of Table 4-4 are presented in
Table 4-5.


Pages:
184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208
elektroenergetyka24.bieszczady.pl Wczasy nad morzem szafy buchsbaum hotele londyn