Replication Agent 15.5 lets you analyze Replication Agent failures that occur when processing Oracle log operations, so that you can determine a resolution to resume replication without losing data. You can now obtain detailed information for Oracle transactions and operations that cause Replication Agent failures, and rectify the problem in a timely manner. The new troubleshooting aid displays the original SQL statement that caused the error, and provides a recommendation on how to make the Replication Agent skip the transaction or operation, to keep the Replication Agent running. You can then apply the erroneous SQL statement to the replicate database for keeping it in sync with the primary database after the Replication Agent skips the operation or transaction.
Two new commands for Oracle, ra_helpop and ra_dumptran, enable you to obtain troubleshooting information pertaining to an operation or database transaction. See “Troubleshooting Oracle transactions and operations” in Chapter 1, “Replication Agent for Oracle,” of the Replication Agent 15.5 Primary Database Guide.
