实时普遍存在的数据库丢失数据的复制和备份 [英] Duplicati and Backup of live Pervasive Database Missing Data

问题描述

我们最近开始使用Duplicati来备份某些数据系统.我们运行使用Pervasive(v10)的ERP解决方案.

We have recently started using Duplicati for backup of some of our data systems. We run an ERP solution that uses Pervasive (v10).

据我所知，Duplicati开始备份过程时，它是使用文件日期或文件字节大小来确定要备份的内容.

When Duplicati begins its backup process, to the best of my understanding, it's using either the file date, and or the file byte size to determine what to back up.

我看到的该解决方案的问题是表中缺少某些数据.例如，我们确定工作单​​模块在服务器(源计算机)上有新的数据行，这些行没有复制到新文件中.

The problem that I see with that solution is that some of the data is missing from the table. For example, the workorders module we are certain had new rows of data on the server (source machine) that were NOT copied over to the new file.

昨晚，我们备份了ERP平台，然后将其还原到新位置，以便将晚上备份的内容与源计算机的内容进行比较.我们注意到，还原的备份中的一个表中缺少源表中的行.

Last night we backed up our ERP platform then restored to a new location so as to do a compare of what was backed up during the evening against what the source machine had. We noticed that there are rows missing from one table in the restored backup, that are there in the source table.

正在从数据目录创建备份.我们没有使用ERP套件随附的集成备份.

The backup is being created from the data directory. We are NOT using the integrated backup that came with the ERP suite.

我个人认为正在发生的事情是，直到最后一个客户端与ERP软件断开连接，数据库才将数据写到表中.另外，即使源文件中包含更多数据，文件丢失数据的字节大小也与源计算机相同.

What I personally believe is happening is that the database isn't writing out the data to the table until the last client disconnects from the ERP software. Also, the byte size of the file missing data and the source machine are the same, even though the source file holds more data.

上周，我们进行了与昨晚相同的测试，当我关闭ERP套件时，我注意到文件更新了其修改过的图章并将新行添加到表中，但是没有在客户端断开连接之前.

Last week we did the same test that we did last night and I noticed when I closed the ERP suite, the file updates its modified stamp and the new rows are added to the table, but not before the client disconnects.

有人可以阐明为什么会发生这种情况吗?

Can someone shed some light on why this is happening?

推荐答案

备份发生时，是否根据Pervasive打开了数据文件?如果是这样，则应该使用某种代理程序关闭文件或将其放入

Are the data files open according to Pervasive when the backup occurs? If so, you should be using some sort of agent to close the files or put them into Continuous Operation mode or Backup Agent. From the docs:

连续操作提供了在备份数据文件的同时 数据库应用程序正在运行并且用户已连接.

Continuous Operations provides the ability to backup data files while database applications are running and users are connected.

启动连续操作"模式时，将创建一个增量文件(.^^^)，并且原始数据文件被关闭"，因此备份程序可以访问该文件并对其进行备份.

When Continuous Operation mode is started, a delta file (.^^^) is created and the original data file is 'closed' so backup programs can access the file and back it up.

Backup Agent将GUI前端置于连续操作"模式，但仅在PSQL v11和更高版本中受支持.

Backup Agent puts a GUI front end to Continuous Operation mode but is only supported with PSQL v11 and newer.

这篇关于实时普遍存在的数据库丢失数据的复制和备份的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！