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