Add=(keyword, ...)
Adds an .aij file to the after-image journal file configuration.
You can add an .aij file while users are attached to the
database. If you specify the Suppress, Drop, or Alter qualifiers
in the same RMU Set After_Journal command, they are processed
before the Add qualifier. The Add qualifier can appear several
times in the same command.
Specify an .aij file to add by using the following keywords:
o Name=name
Specifies a unique name for the after-image journal object
to be added. An after-image journal object is the .aij file
specification plus all of its attributes, such as allocation,
extent, and backup file name.
This keyword is required.
o File=file
Specifies the file for the journal to be added. This keyword
is required. If you do not provide a full file specification,
and only the file name, the file is placed in your current
directory. If more than one journal resides in the same
directory, each journal must have a unique file name. However,
each fixed-size journal file should be located on a separate
device. This minimizes risks associated with journal loss or
unavailability should a device fail or be brought off line.
For example, if two or more journal files reside on the same
failed device, the loss of information or its unavailability
is far greater than that of a single journal file.
o Backup_File=file
Specifies the file to be used for automatic backup operations.
This keyword is optional. If you specify a file name, but
not a file extension, the .aij file extension is used by
default. If you supply only a file name (not a complete file
specification), the backed up .aij file is placed in the
database root file directory.
o Edit_Filename=(option)
Specifies an edit string to apply to the backup file
when an .aij is backed up automatically. This keyword is
optional. However, if it is specified, the Backup_File=file
keyword must be specified also. When you specify the Edit_
Filename=(options) keyword, the .aij backup file name is
modified by appending the options you specify.
See the description of the Edit_Filename keyword for the
Backups qualifier for a list of the available keyword options.
This keyword and the options you specify affect the backup
file name of the .aij file specified with the associated Name
keyword only. If you want the same edit string applied to all
backed up .aij files, you might find it more efficient to use
the Backups qualifier with the Edit_Filename keyword instead
of the Add qualifier with the Edit_Filename keyword.
If you use a combination of the Edit_Filename keyword with the
Add qualifier and the Edit_Filename keyword with the Backups
qualifier, the Add qualifier keyword takes precedence over the
Backups qualifier keyword for the named .aij file. In other
words, the options you specify with Edit_Filename keyword
to the Backups qualifier are applied to all backed up .aij
files except those for which you explicitly specify the Edit_
Filename keyword with the Add qualifier. See Example 6.
This keyword is useful for creating meaningful file names for
your backup files and makes file management easier.
o Allocation=number-blocks
Sets the initial size, in disk blocks, of the .aij file. If
this keyword is omitted, the default allocation is used.
The minimum valid value is 512, the maximum value is eight
million. The default is 512.
See the Oracle Rdb Guide to Database Maintenance for guidance
on setting the allocation size.
o Extent=number-blocks
Specifies the maximum size to extend an .aij file if it is,
or becomes, an extensible .aij file (in blocks). (If the
number of available after-image journal files falls to one,
extensible journaling is employed.)
If there is insufficient free space on the .aij file device,
the journal is extended using a smaller extension value than
specified. However, the minimum, and default, extension size
is 512 blocks.
See the Oracle Rdb Guide to Database Maintenance for guidance
on setting the extent size.