VMS Help  —  RMU72  Show  After Journal, Description
    The output of the RMU Show After_Journal command appears in the
    form shown in Output from the RMU Show After_Journal Command.
    This is the form required by the Aij_Options qualifier for the
    RMU Copy_Database, Move_Area, and Restore commands. When you
    issue the RMU Show After_Journal command, you may see fewer items
    than shown in Output from the RMU Show After_Journal Command;
    some options do not appear unless you specified them when you
    created your after image journal file configuration (for example,
    with the RMU Set After_Journal command).

    Figure 1  Output from the RMU Show After_Journal Command

  (B)0Journal [Is] {Enabled | Disabled} -
          [Reserve n] -
          [Allocation [Is] n] -
          [Extent [Is] n] -
          [Overwrite [Is] {Enabled|Disabled}] -
          [Shutdown_Timeout [Is] n] -
          [Notify [Is] {Enabled|Disabled}] -
          [Backups [Are] {Manual|Automatic} -
          [[No]Quiet_Point] [File filename]] -
          [Cache [Is] {Enabled File filename|Disabled}]
  Add [Journal] journal-name -
  ! File file-specification
          File filename -
          [Allocation [Is] n] -
          [Backup_File filename] -
          [Edit_String [Is] (edit-string-options)]

    When you use the output from the Show After_Journal command as a
    template for the Aij_Options qualifier of the RMU Copy_Database,
    Move_Area, and Restore commands, note the following regarding the
    syntax:

    o  As shown in Output from the RMU Show After_Journal Command,
       you can use the DCL continuation character (-)  at the
       end of each line in the Journal and Add clauses. Although
       continuation characters are not required if you can fit each
       clause (Journal or Add clause) on a single line, using them
       might improve readability.

    o  The Journal Is clause must precede the Add clause.

    o  Because the Journal clause and the Add clause are two separate
       clauses, a continuation character should not be used between
       the last option in the Journal clause and the Add clause (or
       clauses).

    o  The journal options file can contain one Journal clause only,
       but it can contain several Add clauses. However, the number of
       Add clauses cannot exceed the number of reservations made for
       .aij files. In addition, if you are enabling journaling, you
       must add at least one journal.

    o  You can specify only one of each option (for example, one
       Extent clause, one Cache clause, and so on) for the Journal Is
       clause.

    The clauses and options have the following meaning:

    o  Journal Is Enabled

       Enables after-image journaling. At least one Add clause must
       follow. If this option is omitted, the current journaling
       state is maintained.

    o  Journal Is Disabled

       Disables after-image journaling. You can specify other options
       or Add clauses but they do not take effect until journaling
       is enabled. The Add clause is optional. If this option is
       omitted, the current journaling state is maintained.

    o  Reserve n

       Allocates space for an .aij file name for a maximum of n .aij
       files. By default, no reservations are made. Note that you
       cannot reserve space in a single-file database for .aij files
       by using this option with the RMU Move_Area command with the
       Aij_Options qualifier. After-image journal file reservations
       for a single-file database can be made only when you use the
       RMU Convert, RMU Restore, or RMU Copy_Database commands.

    o  Allocation Is n

       Specifies the size (in blocks) of each .aij file. If this
       option is omitted, the default allocation size is 512 blocks.
       The maximum allocation size you can specify is eight million
       blocks.

       See the Oracle Rdb Guide to Database Maintenance for guidance
       on setting the allocation size.

    o  Extent Is n

       Specifies the maximum size to extend an .aij journal if it is,
       or becomes, an extensible .aij journal (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 journal
       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.

    o  Overwrite Is Enabled

       Enables overwriting of journals before they have been backed
       up. If this option is omitted, overwriting is disabled.

       This option is ignored if only one .aij file is available.
       When you specify the Overwrite Is Enabled option it is
       activated only when two or more .aij files are, or become,
       available.

    o  Overwrite Is Disabled

       Disables overwriting of journals before they have been backed
       up. If this option is omitted, overwriting is disabled.

    o  Shutdown_Timeout Is n

       Sets the delay from the time a journal failure is detected
       until the time the database aborts all access and shuts itself
       down. The value n is in minutes.

       If this option is omitted, the shutdown timeout is 60 minutes.
       The maximum value you can specify is 4320 minutes.

    o  Notify Is Enabled

       Enables operator notification when the journal state changes.
       If this option is omitted, operator notification is disabled.

    o  Notify Is Disabled

       Disables operator notification when the journal state changes.
       If this option is omitted, operator notification is disabled.

    o  Backups Are Manual

       Automatic backup operations are not enabled. This is the
       default behavior.

    o  Backups Are Automatic [File filename]

       Automatic backup operations are triggered by the filling of
       a journal. The backup file will have the specified file name
       unless a different file name or an edit string is specified in
       the Add clause. If this option is omitted, backup operations
       are manual.

    o  Edit String Is (edit-string-options)

       Specifies a default edit string to apply to the backup file
       when an .aij is backed up automatically. See the description
       of the Edit_Filename keyword in Set After_Journal for a
       description of the available options. An Edit_String that
       appears with the definition of an added journal takes
       precedence over this edit string.

    o  Quiet_Point

       Specifies that the after-image journal backup operation is
       to acquire the quiet-point lock prior to performing an .aij
       backup operation for the specified database.

    o  Noquiet_Point

       Specifies that the after-image journal backup operation will
       not acquire the quiet-point lock prior to performing an .aij
       backup operation for the specified database.

    o  Cache Is Enabled File filename

       Specifies that a journal cache file should be used. The cache
       file must reside on a nonvolatile solid-state disk. If it
       does not, caching is ineffectual. See Set After_Journal
       for information on what happens if the cache file becomes
       inaccessible.

       By default, caching is disabled.

    o  Cache Is Disabled

       Specifies that a journal cache file should not be used. This
       is the default behavior.

    o  The Add clause or clauses specify the name and location of the
       journal file and the backup file generated by automatic backup
       operations as follows:

       -  Add [Journal] journal-name

          Specifies the name for the after-image journal file
          described in the Journal clause. The journal-name is the
          name of the journal object. A journal object is the journal
          file specification plus all the attributes (allocation,
          extent, and so on) given to it in the journal clause.

       -  ! File file-specification

          Provides the full file specification and version number of
          the .aij file named in the Add clause. This line of output
          is provided because the next line (File filename) provides
          the string that the user entered when he or she created
          the .aij file. For example, if the user entered a file name
          only, and this line of output was not provided, you would
          have to issue the RMU Dump command to determine in which
          directory the file resides.

       -  File filename

          Specifies the file name for the .aij file being added. This
          option is required.

       -  Allocation Is n

          Specifies the size of the .aij file (in blocks). If this
          option is omitted, the default allocation size is 512
          blocks.

          See the Oracle Rdb Guide to Database Maintenance for
          guidance on setting the allocation size.

       -  Backup_File filename

          Specifies the backup file name for automatic backup
          operations. Note that it is not valid to specify a Backup_
          File clause in the Add clause if you have specified Backups
          Are Manual in the Journal clause; Oracle RMU returns an
          error if you attempt to do so.

       -  Edit String Is (edit-string-options)

          Specifies an edit string to apply to the backup file when
          the .aij is backed up automatically. See the description
          of the Edit_Filename keyword in Set After_Journal for a
          description of the available keywords.
Close Help