9. Analyzing and Recovering Journaled Transactions
 
Share this page                  
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.