| Data Integrator [message #648544] |
Thu, 25 February 2016 02:19  |
 |
deceneu
Messages: 4
Registered: February 2016
|
Junior Member |
|
|
Hi,
on project, that our company should start, raised a discussion regarding solution to use, for the following problem:
- we have a big database (1T/month - window) that scale very good on real-time data collecting project,
- was requested to build some reports, based on this database.
To meet this requirement was decided to replicate data from primary database into another one, because of performance reasons.
For this requirement I'm asking what is the best way to do it?
Our way was to use:
1. Data Gard to replicate primary database, but this solution is not applicably, because secondary database should be fully functional in read/write mode.
2. Data Pump partial, what is not applicable because, offline time for database is not accepted.
3. CDC - not applicable because of many problems that we have in the past and also is deprecated.
4. last one, to develop custom scripts for data transfers, that is not accepted from maintenance costs.
Please Help with best solution !
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
