How to record historical data to both HDB and RDB?

[AngusETM]

Hi all,

We need to store data to both the local HDB and a remote Oracle database - 1 year to local HDB and 7 years to the Oracle. This is so that if the Oracle database is unavailable, the customer will still be able to access 1 year of data.


At a high level, what setup do we need to perform (and where) to do this? The reason for my question is because I hold two contradictory understandings about how to set up logging to Oracle in WinCC OA.

1. My training notes on the HDB suggest that it's possible to set up archiving to only the HDB, or both the HDB and RDB, but not just the RDB. They suggest that the normal HDB archive should be set up as normal, then if Oracle is desired, check the "Forward to RDB" option in the HDB archive Configure -> Special Options tab. They also say to set the external write path to be Oracle, but I'm not sure where to do this. Then, to create an RDB manager.

2. However, when an RDB manager is created, RDB Archive Manager and RDB Archive Groups are created as separate Database options in the System Management. In addition, the RDB archive group(s) are presented as a separate list in a datapoint element's archive config, separated by a dashed line (----------). So, when the RDB archive group is selected on a datapoint element, the point is not configured for an HDB.

I'm assuming that my notes are wrong somehow.

So to ask my question with a bit more detail:
- Edit: Is it possible to store data to both HDB and RDB?
- To store data to Oracle do we create the RDB Manager, set up the RDB Archive Manager Configuration then select the RDB Archive in the datapoint element archive config? (I think yes.)
- If so, how do we also get an an HDB archive at the same time?


Regards,

Angus Heyworth

[mkerk]

Hello,

To have HDB/RDB parallel you have to configure a ValueArchive (HDB) COnfig on the DPE and to activate the ForwardToRDB flag in the ValueArchive parameteritation panel. Some configs- entries have also to be added. please refer to the WInCC OA documentation "System management --> Database --> RDB Archiving --> RDB Parallel" for detailed information about how to configure HDB-RDB Parallel correctly. Please note that both ValueArchive (HDB)- and RDB- Manager(s) must be configured correctly in your project before activating the HDB/RDB parallel feature. Please refer also to the documentation for detailed information how to configure RDB and also HDB correctly.


Just a remark:
In WinCC OA you have following methods to archive values and alerts:

1- HDB (= History Database, used to save value changes)

2- RAIMA (Alert database, used to save alerts)

3- RDB (= Relational Database, used to save value changes as well as alerts)


And you have the possibility to configure your system to have:
1- HDB + RAIMA
2- or only RDB
3- or HDB/RDB parallel
4- or RAIMA/RDB parallel
5- or HDB/RDB + RAIMA/RDBparallel




BR,
Mousser

[AngusETM]

Thanks Mousser, that answers the question quite thoroughly. Appreciate the quick response.

Regards,
Angus