It can be up to eight characters and
must begin with an alphanumeric character. Once set, it can only be changed with the Oracle
DBNEWID utility (nid); the DB_NAME is recorded in each datafile, redo log file, and control file
in the database. At database startup, the value of this parameter must match the value of DB_
NAME recorded in the control file.
DB_DOMAIN
DB_DOMAIN specifies the name of the network domain where the database will reside. The
combination of DB_NAME and DB_DOMAIN must be unique within a distributed database
system.
DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE
When database recovery operations occur, either due to an instance failure or a media failure,
it is convenient to have a flash recovery area to store and manage files related to a recovery or
backup operation. Starting with Oracle 10g, the parameter DB_RECOVERY_FILE_DEST can be a
directory location on the local server, a network directory location, or an ASM (Automatic Storage
Management) disk area. The parameter DB_RECOVERY_FILE_DEST_SIZE places a limit on how
much space is allowed for the recovery or backup files.
These parameters are optional, but if they are specified, Recovery Manager (RMAN) can
automatically manage the files needed for backup and recovery operations. The size of this
recovery area should be large enough to hold two copies of all datafiles, incremental RMAN
backups, online redo logs, archived log files not yet backed up to tape, the SPFILE, and the
control file.
Pages:
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133