This content has been marked as final. Show 2 replies
Golden Gate works as intended unless you encounter some bugs. I would suggest the following (may not be in order though)
--Scenarios involving Insert/update/deletes on all tables being replicated and verify the same on replicated side.
--Perform total row counts on replicated databases.
--Regression testing on all replicated databases with same scenarios
--Scenarios involving DDL changes like CREATE , ALTER , TRUNCATE, DROP of database objects like tables , views , indexes if DDL is being replicated and if applicable
--Abort sessions during transactions i.e kill a transaction
--Abort(shutdown) database during transactions
adding to it
u can test splitting the heavy loaded tables handling multiple extract and replicates.
u can diable the pump and execute some heavyload transactions, after finishing the load u can start the pump to find the time taken to apply in the target.