How To Determine Secondary Database State With RDBSyncForward?

Find and share HowTos to various installations / configurations!
Search

Post Reply
3 posts • Page 1 of 1
jimtaylor
Posts: 25
Joined: Tue Jun 11, 2013 8:18 am

How To Determine Secondary Database State With RDBSyncForward?

Post by jimtaylor » Tue Dec 03, 2019 10:30 am

Hi,

We are using redundant Oracle databases using RDBSyncForward, setup as per the ETM White Paper "Oracle Historian Replication EN".

My question is: how can I tell if the connection to the secondary Oracle database is healthy?

I see we have the internal DPEs _RDBArchive.dbConnection.connected to let us know that WInCC OA has a connection to Oracle, and _RDBArchive.dbConnection.usedHost to let us know which database is currently active. However, say we have connected = TRUE and usedHost = HOST_A, which DPE(s) can tell me whether HOST_B is healthy or not?

Thanks.

User avatar
eivanovic
Posts: 69
Joined: Wed Sep 03, 2014 12:35 pm

Re: How To Determine Secondary Database State With RDBSyncForward?

Post by eivanovic » Thu Dec 05, 2019 9:09 am

Hi Jim,

There is no indication in WinCC OA dpes, because the connection to the daatabase is not establisched. What you can do is to preiodically check if the link working. This can be done with an SQL statement from the primary server to the secondary server. There is always a DB link between the two Oracle server.

the SQL would look like following:

select * from dual@<YOURDBLINK>;

you can run this SQL with direct SQL commands periodically out of WinCC OA then (using our built in control functions).

BR
Emanuel
Attachments
image.png

jimtaylor
Posts: 25
Joined: Tue Jun 11, 2013 8:18 am

Re: How To Determine Secondary Database State With RDBSyncForward?

Post by jimtaylor » Thu Dec 05, 2019 1:47 pm

Thanks Emanuel, I will give this a go.

Jim

Post Reply
3 posts • Page 1 of 1