Query On Steps To Refresh A QA Environment From Production
(Doc ID 2484252.1)
Last updated on SEPTEMBER 16, 2022
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.0.9 and laterInformation in this document applies to any platform.
Goal
OUA - Oracle Utilities Analytics
QA - Quality Assurance
NMS - Oracle Network Management System
ETL - Extract, Transform, Load
OGG/GG - Oracle GoldenGate
On : 2.7.0.0.9 version, Install / Upgrade
Query on Steps to Refresh a QA Environment from Production
We are implementing OUA 2.7.0.0.9, and we need steps to refresh QA Environment with data from Production.
Every time client wants to test a data scenario or a functionality change in NMS and its impact on OUA data, it has been hard with previous Installation customer had with problems related to sequences, session time outs etc. So they would like appropriate instructions from Product team to copy
NMS1REP, DWADM, MDADM data from Production. We need instructions such that all data is copied and we will start GG replication from that point on.
The idea is to create transportable table spaces as selective schemas Import will be too hard once data warehouse becomes really huge in size.
So looking at separating Master Repo, Work Repo schemas , NMS1REP, DWADM , DWSTAGE, MDADM.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |