Backup strategy

I assume it’s important that a database is closed, when doing a backup with timemachine, arq etc (or am I wrong?)

It’s not necessary since these two mechanisms use a snaphot-style backup, ie. they ”take a picture” of your machine at the scheduled time and only back those things up.