VMS Help  —  RMU72  Using LogMiner for Rdb
    Oracle Rdb after-image journal (.aij) files contain a wealth
    of useful information about the history of transactions in a
    database. After-image journal files contain all of the data
    needed to perform database recovery. These files record every
    change made to data and metadata in the database. The LogMiner
    for Rdb feature provides an interface to the data record contents
    of Oracle Rdb after-image journal files. Data records that are
    added, updated, or deleted by committed transactions may be
    extracted (unloaded) from the .aij files in a format suitable
    for subsequent loading into another database or for use by user-
    written application programs.

    Oracle Rdb after-image journaling protects the integrity of your
    data by recording all changes made by committed transactions to a
    database in a sequential log or journal file. Oracle Corporation
    recommends that you enable after-image journaling to record your
    database transaction activity between full backup operations
    as part of your database restore and recovery strategy. The
    after-image journal file is also used to enable several database
    performance enhancements (such as the fast commit, row cache, and
    hot standby features).

    See the Oracle Rdb7 Guide to Database Maintenance for more
    information about setting up after-image journaling.

    To use LogMiner for Rdb, follow these steps:

    1. Enable the database for LogMiner operation using the RMU Set
       Logminer command. See Set Logminer for additional information.

    2. Back up the after-image journal file using the Quiet_Point
       qualifier to the RMU Backup command.

    3. Extract changed records using the RMU Unload After_Journal
       command. See the Unload After_Journal help topic for
       additional information.
Additional Information: explode extract
Restrictions and Limitations Information Returned Record Definition Prefix SQL Table Definition Prefix Segmented String Columns Maintenance OpenVMS Pipe
Close Help