oracle11g - Replication advice Oracle 11g -


we have requirement implement replication (of transactions) production database test database (across db link). we're using 11g enterprise edition.

this because it's not production data that's needed, intention code releases in test database tested against real-world transactions prod system, without need transactions done manually. if transaction fails in test system worked in prod system, wrong release.

it doesn't have in real-time however, delay acceptable.

there must 0 risk though on production transactions failing, due issue replication.

what options here? believe streams deprecated in 12c, should of concern? goldengate additional ££, i'm afraid rules out in case. kind of custom trigger-based solution... risk on prod system far can see.

any advice appreciated!

as of oracle release 12c (12.1.x), oracle advanced replication , oracle streams being discontinued. oracle golden gate going replace features of oracle advanced replication , oracle streams.

please review list of possible alternatives (to name few):

shareplex dbvisit dbconvert 

Comments

Popular posts from this blog

magento2 - Magento 2 admin grid add filter to collection -

Android volley - avoid multiple requests of the same kind to the server? -

Combining PHP Registration and Login into one class with multiple functions in one PHP file -