Refreshing a Dev database in an Oracle Golden Gate Environment
Hello all,
I have an environment where I refresh the data in the development environment from data in production. This is done on a quarterly basis. We have recently installed and set up Golden Gate replication in dev for about 400 tables. What is the recommended method of refreshing the development database from production in this environment?
Production:
1/4 Rack Exadata (2 node RAC) and ASM. There are two databases in production that are of concern. We have a JD Edwards database JDEP and a reporting database RPTP. The data must be kept in sync between the two databases. There are about 400 or so tables that we use Golden Gate to replicate from the JDEP database to the RPTP database.