If you run duplicacy without -vss flag, it will read files sequentially. If they are changing while it’s reading you may end up with a file backed up in inconsistent state.
This is why you shall use -vss flag. On windows it will use VSS, and on macOS tmutil to create the filesystem snapshot, and then backup that snapshot, instead of live filesystem. Then all your files will be in the state they were at the time the snapshot was taken
This does not help with databses: you shall exclude database files from duplicacy backup usign filters. To backup database content you need to use database vendor tools to export the database contentent, and then have duplicacy backup that export.