Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  OVERWRITE
    Syntax options:

    OVERWRITE IS ENABLED | OVERWRITE IS DISABLED

    Specifies whether the overwrite option is enabled or disabled.

    After-image journal files are used for database recovery in case
    of media failure and for transaction recovery as part of the
    fast commit feature. In some environments, only the fast commit
    feature is of interest and a small set of journal files can be
    used as a circular fast commit log with no backup of the contents
    required. The OVERWRITE option instructs Oracle Rdb to write over
    journal records that would normally be used for media recovery.
    The resulting set of journal files is unable to be used by the
    RMU Recover command for media recovery.

    The OVERWRITE option is ignored when only one after-image journal
    (.aij) file exists. Adding subsequent journal files activates the
    OVERWRITE option.

    The default is DISABLED.
Close Help