It is possible to use the RDBSyncForward feature to replicate history data to a second Oracle database.<\/p>\n
WinCC OA primarily writes the history data to the first database. Values are replicated from the first database to the second database by Oracle-Packages (part of WinCC OA). When the first database goes down then WinCC OA will continue to write history data to the second database. When the first database gets up and running again then WinCC OA will switch back to the first database and the history data which was written to the second database will be replicated from the second database to the first database.<\/p>\n
The bi-directional replication is done asynchronously (periodically)! If one database crashes some history data may be lost.<\/p>\n
Prepare two RDB configuration files <\/strong><\/p>\n RDB_config_DB1.sql and RDB_config_DB2.sql.<\/p>\n Use RDB_config_template.sql: C:\\Siemens\\Automation\\WinCC_OA\\3.12\\data\\RDBSetup\\ora\\RDB_config_template.sql<\/p>\n Example configuration file with ASM is shown at the end. RDB_config_DB1.sql: RDB_config_DB2.sql: Prepare the TNSNAMES.ORA<\/strong> Change to RDBSetup directory<\/strong> Execute the RDB-Manager-Setup-Script for the first Oracle-Database.<\/strong> Execute the RDB-Manager-Setup-Scriptfor the second Oracle-Database.<\/strong> Change to sync subdirectory<\/strong> C:\\Siemens\\Automation\\WinCC_OA\\3.12\\data\\RDBSetup\\ora\\sync<\/p>\n Execute the sync setup for database 1<\/strong> Execute the sync setup for database 2<\/strong> Check arc_log table for (error)messages<\/strong> Adapt WinCC OA config file<\/strong> RDB archive group configuration<\/strong> WinCC OA config file<\/strong> [ValueArchiveRDB] [ctrl] [ui] TNSNAMES.ORA<\/strong> DB2 = RDB_config_DB1.sql<\/strong> define whatpackage = 'fwd' RDB_config_DB2.sql<\/strong> define whatpackage = 'fwd' It is possible to use the RDBSyncForward feature to replicate history data to a second Oracle database. WinCC OA primarily writes the history data to the first database. Values are replicated from the first database to the second database by … Continue reading
\nThe following lines are important for the data replication.<\/p>\n
\n
\ndefine whatpackage = 'fwd'
\ndefine connect_first = '&connect_identifier'
\ndefine connect_second = 'DB2'
\ndefine whatinstall = '3'
\ndefine syncjob_intval = 1
\n<\/code><\/p>\n
\n
\ndefine whatpackage = 'fwd'
\ndefine connect_first = '&connect_identifier'
\ndefine connect_second = 'DB1'
\ndefine whatinstall = '3'
\ndefine syncjob_intval = 1
\n<\/code><\/p>\n
\nIt must contain both databases and must be deployed to the WinCC OA server(s) and to the database servers!
\nAn TNSNAMES.ORA example you will find below.<\/p>\n
\nC:\\Siemens\\Automation\\WinCC_OA\\3.12\\data\\RDBSetup\\ora<\/p>\n
\n> win_install.bat\/unix_intall.sh _DB1<\/code><\/p>\n
\n> win_install.bat\/unix_intall.sh _DB2<\/code><\/p>\n
\n> sync_setup _DB1 ..\\<\/code><\/p>\n
\n> sync_setup _DB2 ..\\<\/code><\/p>\n
\nselect * from arc_log order by arc_log_id desc<\/code><\/p>\n
\nImportant for the data replication is the following configuration:
\n[ValueArchiveRDB]
\nDb = “DB1,DB2”<\/p>\n
\nIn WinCC OA go to system management \/ database \/ RDB archive groups and set the check box “forwarding” for the archive groups you wanna sync.<\/p>\n
\n
\n[general]
\nuseRDBArchive = 1
\nuseRDBGroups = 1<\/p>\n
\nDbUser = \"RDBSYNC\"
\nDbPass = \"manager\"
\nDbType = \"ORACLE\"
\nDb = \"DB1,DB2\"
\nwriteWithBulk = 1<\/p>\n
\nqueryRDBdirect = 1
\nCtrlDLL = \"CtrlADO\"
\nCtrlDLL = \"CtrlRDBArchive\"
\nCtrlDLL = \"CtrlRDBCompr\"<\/p>\n
\nqueryRDBdirect = 1
\nCtrlDLL = \"CtrlADO\"
\nCtrlDLL = \"CtrlRDBArchive\"
\nCtrlDLL = \"CtrlRDBCompr\"
\n<\/code><\/p>\n
\n
\nDB1 =
\n(DESCRIPTION =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = Linux-DB-01)(PORT = 1521))
\n(CONNECT_DATA = (SERVICE_NAME = DB1))
\n)<\/p>\n
\n(DESCRIPTION =
\n(ADDRESS = (PROTOCOL = TCP)(HOST = Linux-DB-02)(PORT = 1521))
\n(CONNECT_DATA = (SERVICE_NAME = DB2))
\n)
\n<\/code><\/p>\n
\n
\ndefine connect_identifier = 'DB1'
\ndefine sysdba_user = 'SYS'
\ndefine yesno_newuser = 'yes'
\ndefine schema_user = 'RDBSYNC'
\ndefine app_user = 'RDBSYNCAPP'
\ndefine use_rman = 'rman'
\ndefine os_sys = 'unix'
\ndefine zip_backup = 'no'
\ndefine sequence_start = 100000
\ndefine sequence_maxvalue = 199999
\ndefine path_dbfile = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine path_tempdbfile = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine path_oraclebin = '\/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/bin\/'
\ndefine instance_name = 'DB1'
\ndefine host_name = 'linux-db-01'
\ndefine path_backup = '\/u01\/app\/oracle\/fast_recovery_area\/DB1\/winccoa\/'
\ndefine path_alert = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine path_event = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine mytimezone = 'Europe\/Vienna'
\ndefine asm_instance = '+ASM'
\ndefine service_name = 'DB1'
\ndefine number_db_storage = 1<\/p>\n
\ndefine connect_first = '&connect_identifier'
\ndefine connect_second = 'DB2'
\ndefine whatinstall = '3'
\ndefine syncjob_intval = 1
\n<\/code><\/p>\n
\n
\ndefine connect_identifier = 'DB2'
\ndefine sysdba_user = 'SYS'
\ndefine yesno_newuser = 'yes'
\ndefine schema_user = 'RDBSYNC'
\ndefine app_user = 'RDBSYNCAPP'
\ndefine use_rman = 'rman'
\ndefine os_sys = 'unix'
\ndefine zip_backup = 'no'
\ndefine sequence_start = 100000
\ndefine sequence_maxvalue = 199999
\ndefine path_dbfile = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine path_tempdbfile = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine path_oraclebin = '\/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/bin\/'
\ndefine instance_name = 'DB2'
\ndefine host_name = 'linux-db-02'
\ndefine path_backup = '\/u01\/app\/oracle\/fast_recovery_area\/DB1\/winccoa\/'
\ndefine path_alert = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine path_event = '+DATA\/WINCCOA\/RDBSYNC\/'
\ndefine mytimezone = 'Europe\/Vienna'
\ndefine asm_instance = '+ASM'
\ndefine service_name = 'DB2'
\ndefine number_db_storage = 1<\/p>\n
\ndefine connect_first = '&connect_identifier'
\ndefine connect_second = 'DB1'
\ndefine whatinstall = '3'
\ndefine syncjob_intval = 1
\n<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"