User`s guide
Basic Structures
2-4 Oracle Database Installation and Administration Guide
2.2.3 Oracle-Managed Files
The following is a list of the
INIT.ORA
parameters for oracle-managed files:
■
DB_CREATE_FILE_DEST
for data files, temp files, and block change tracking files
■
DB_CREATE_ONLINE_LOG_DEST_n
for redo log files and control files
■
DB_RECOVERY_FILE_DEST
for backups, archive log files, and flashback log files
On BS2000, these parameters are used as a prefix for file names.
Oracle tablespace names can be up to 30 characters long. To associate an OMF-created
fi
le name with its tablespace, you must use tablespace names that are distinct in the
first eight characters. Oracle allows underscores(_) in tablespace names, and any
underscores(_) that are present are changed to hyphens(-) for use in the generated file
name.
File names for Oracle-managed files have
the following format on BS2000:
File type Format
control files destOMC.tttttttt
log files destOMLlll.tttttttt
permanent tablespace files, data file copies destOMD.tsn.tttttttt
temporary tablespace files destOMT.tsn.tttttttt
archive log files destOMA.Tnnn.Snnnnnn.tttttttt
data file or archivelog backup piece destOMB.Lnnn.tttttttt
rman autobackup piece destOMX.xnnnnnnn.tttttttt
block change tracking files destOMR.tttttttt
flashback log files destOMF.tttttttt
where:
■ dest is the destination string (_DEST) in the OMF parameter
■ tttttttt is the encoded timestamp (which looks like a random mix of letters and
numerals)
■ lll is a three-digit log-group number
■ tsn is up to eight characters for the tablespace name
■ Tnnn is the letter "T" followed by a three-digit thread number
■ Snnnnnn is the letter "S" followed by a six-digit sequence number
■ Lnnn is the letter "L" followed by a three-digit incremental level
■ x is the letter P, if the database has an
SPFILE
, or the letter T if the database does
not have an
SPFILE
■ nnnnnnn is a seven-byte timestamp
Given the 54 character limit on BS2000 file names
, the preceding file name formats
impose a limit of 39 characters on
DB_CREATE_ONLINE_LOG_DEST_n
and
DB_CREATE_
FILE_DEST
, 29 characters on
DB_RECOVERY_FILE_DEST
. This file name character limit
includes the
catid
and
userid
, that may occupy up to 16 characters.