 |
|
Oracle Tips by Burleson |
Easy Oracle Automation
Chapter 5 -
Automatic Storage Management
Internal Consistency of Disk Groups
ALTER DISKGROUP dskgrp01 CHECK ALL;
File Types Supported by ASM
ASM supports most file types in a database. But
some administrative file types
such as audit files,
alert log, backup files, binaries, export file, and trace files
cannot be supported on an ASM disk group. The following table lists
the different file types, whether
ASM supports it, and
system default templates for their file creation.
|
File Type |
ASM Supported |
Default Templates |
|
Archive Log Backup |
YES |
BACKUPSET |
|
Archive Log |
YES |
ARCHIVELOG |
|
Change Tacking File |
YES |
CHANGETRACKING |
|
Control File |
YES |
CONTROLFILE |
|
Data Pump Dump |
YES |
DUMPSET |
|
Data File Backup |
YES |
BACKUPSET |
|
Data File Copy |
YES |
DATAFILE |
|
Data file |
YES |
DATAFILE |
|
Disaster Recovery Configurations |
YES |
DATAGUARDCONFIG |
|
Flashback Log |
YES |
FLASHBACK |
|
Operating System File |
NO |
NOT APPLICABLE |
|
SPFILE |
YES |
PARAMETERFILE |
|
Redo Log |
YES |
ONLINELOG |
|
Temporary File |
YES |
TEMPFILE |
|
Trace File |
NO |
NOT APPLICABLE |
Table 5.4 - File types, ASM support, and
system default templates
The above text is
an excerpt from:
Easy Oracle Automation
Oracle10g Automatic
Storage, Memory and Diagnostic Features
ISBN 0-9745993-6-0
by Dr. Arun Kumar R.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
