My Oracle Support Banner

Query On Steps To Refresh A QA Environment From Production (Doc ID 2484252.1)

Last updated on JUNE 22, 2021

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.7.0.0.9 and later
Information in this document applies to any platform.

Goal

**Disclaimer:** This KM article may include the following abbreviations:

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.