Ah, the transaction logger. Here's the problem (unless it got fixed somehow) with that:
When you're running uvrolf to roll forward the logs on the DR box, you have the "last transaction" problem. The last update in the transaction log can span over to the next transaction log. If this happens (and it effectively always does), when you go to roll forward, if you don't have the next log, that last update is seen as a failed transaction, and is dropped. You can do a workaround, but if you're just shipping tlogs across & using uvrolf to update, you're 99.9999% sure to be losing one transaction per tlog. When you do the fail over, unless you can recover that in-process tlog to the DR box, you'll lose whatever's in there, as well. -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Manu Fernandes Sent: Wednesday, March 18, 2009 5:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Does anybody have a hot backup server? Hi, Under Universe/Linux we use Data Replication Block Device. www.drbd.com (open source linux product) A low level software called between logical partition and hdd partition. Cluster over LAN. We define it on partitions where Universe db is installed (including universe himself). On the hot-standby server, the same partition is created and not mounted (universe is not started ~ for this raison, we don't need IBM's license) On fail-over, we switch the ip adress to the hot-standby server, we mount the partition, we boot uv and users can work ... 2 minutes. One restriction, we don't use DYNAMIC files because the headers are not permanently flushed when write occurs files. Coupled with Universe Transaction Logger set on strategic files to ensure "record update integrity". My two pence. Manu > -----Message d'origine----- > De : owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- > us...@listserver.u2ug.org] De la part de Jeff Powell > Envoyi : mercredi 18 mars 2009 20:07 > @ : u2-users@listserver.u2ug.org > Objet : [U2] Does anybody have a hot backup server? > > I am trying to put together a backup strategy that involves keeping a > standby server within two data hours of the primary. The idea is to be > able to have users log into the backup server and keep the business > running in the event of a crash. > > I'd like to hear what solutions others have found for this. > > I've been trying to contact IBM for the last 6 months but they haven't > answered and my ERP vendor doesn't know how to do this. > > Any ideas are appreciated. > > TIA > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
