How to avoid data loss during patch installation when using RDB (including Oracle schema upgrade)

Find and share HowTos to various installations / configurations!
1 post • Page 1 of 1
eivanovic
Posts:78
Joined: Wed Sep 03, 2014 2:35 pm

How to avoid data loss during patch installation when using RDB (including Oracle schema upgrade)

Post by eivanovic »

The customer was in the need of performing an patch upgrade with Redu and RDB, without loosing data during the upgrade.

Here is a short instruction how this could be done.

1) Node A Active + RDB running
2) Node B Project (passive ) --> Stop project
3) Upgrade Node B with new WinCC OA patch.
4) Node A - Disconnect DB - by setting the internal dp "_RDBArchive.dbConnection.closeDBConnection = TRUE"
5) Node B - Upgrade DB-schema with the new patch.
6) Node A - Connect DB - set the internal dp "_RDBArchive.dbConnection.openDBConnection = TRUE" .Flush/Write Bufferfiles with old OA to new DB Schema. Wait until the buffer files are written.
7) Startup Node B (with new OA version) --> Recovery from node A.
8) Switch node B to active.
9) Stop Node A and Upgrade Node A with the new WinCC OA patch.
10) Startup Node A

1 post • Page 1 of 1