Tuesday, November 6, 2012

Oracle file types and Oracle ASM file type tags


Oracle file types and Oracle ASM file type tags
Oracle ASM File Type
Description
Oracle ASM File Type Tag
Comments
CONTROLFILE
Control files and backup control files
Current
Backup
Archive
Backup
DATAFILE
Data files and data file copies
tblspname
Name of the tablespace into which the file is added
ONLINELOG
Online logs
group_loggroup#

ARCHIVELOG
Archive logs
thread_thread#_seq_sequence#

TEMPFILE
Tempfiles
tsname
Name of the tablespace into which the file is added
BACKUPSET
Data file and archive log backup pieces; data file incremental backup pieces
spfile?_timestamp
spfile? can take one of two values: s indicates that the backup set includes the spfile; n indicates that the backup set does not include the spfile.
timestamp is the time that the backup is started.
PARAMETERFILE
Persistent parameter files
spfile
Name of the SPFILE
DATAGUARDCONFIG
Data Guard configuration file
db-unique-name
Data Guard uses the value of the DB_UNIQUE_NAME initialization parameter.
FLASHBACK
Flashback logs
log_flashbacklog#

CHANGETRACKING
Block change tracking data
ctf
Used during incremental backups
DUMPSET
Data Pump dumpset
user_obj#_file#
Dump set files encode the user name, the job number that created the dump set, and the file number as part of the tag.
XTRANSPORT
Data file convert
tblspname
Name of the tablespace where the Oracle ASM metadata is added
AUTOBACKUP
Automatic backup files
spfile?_timestamp
spfile? can take one of two values: s indicates that the backup set includes the spfile; n indicates that the backup set does not include the spfile.
timestamp is the time that the backup is started.
ASMPARAMETERFILE
Oracle ASM persistent parameter files
spfile
Name of the Oracle ASM SPFILE
OCRFILE
Oracle Clusterware Registry files
ocrfile
Name of the OCR files

No comments:

Post a Comment