Hot Backup Question

From: Ernst Renner <QAFT97A_at_prodigy.com>
Date: 1996/07/09
Message-ID: <4ru0fc$109u_at_usenetz1.news.prodigy.com>#1/1


Hello All!

I am performing hot backups on an HP-UX system. After putting a tablespace in backup mode, I copy the datafiles over to a near-line device. At this time I perform a check sum of the two files to ensure the same size and gain a sense of comfort o f the backup status. Now, it was my understanding that when a tablespace is in backup that transactions are NOT written to the physical file until the tablespace is taken out of backup mode. When I do my check summing, on the more volatile tablespaces, the check fails because it looks like the file has changed since I copied it.
Does anyone have any idea on what to check, if my theory is incorrect, or basically any idea on this topic? This has just started recently, as my OLTP users have increased their online durations to 24/7. I had had about 5 hrs/night to do this where there were no transactions ongoing or outstanding.

Thanks!

-
  ERNST RENNER erenner_at_itthartford.com Received on Tue Jul 09 1996 - 00:00:00 CEST

Original text of this message