Analyzing and Recovering Journaled Transactions
Journal Analyzer
The Journal Analyzer is a utility that allows you to view and analyze journaled transactions and individual underlying statements. It also enables you to create SQL scripts, which are used to recover or redo individual row operations without redoing or rolling back the whole database or table.
In the Journal Analyzer, you can:
• View past transactions and their begin/end timestamps, duration, LSN, and user, and the number of insert, update, and delete statements within the transaction
• View tables and rows involved in the transaction
• View before and after images and corresponding LSN for row changes within the transaction
• View rolled back transactions
• View some types of statements, such as create table or create index, inserts, updates, and deletes, and recover or redo journaled insert, update, and delete statements
• Recover and redo transactions immediately or generate scripts to do it at another time or in another database
• Recover and redo multiple transactions at one time, allowing, for example, the replaying of whole sequences of journal files on a remote node/database
• Recover and redo individual row changes
For detailed instructions on using the Journal Analyzer, see the Journal Analyzer online help.