lvm snapshot

[Cédric Briner]

Hi,

We are using a h2 database in one of our product integrated at our organisation. We are not able to order a dump every hour as the application does not allow this.

We were thinking to use a snapshot done by the OS to help us. We will use the "lvm" command on linux. As defined on the "lvcreate" man page. This snapshot is coherent and hapenning as an atomic wax (frozen). This means that that db will be in the same state as if the system crashes.

Is there a way to verify that the db is coherent and able to play de redo logs ?

Thanks in advance.

cED

[Noel Grandin]

On 5/19/2026 9:12 AM, Cédric Briner wrote:
>
> Is there a way to verify that the db is coherent and able to play de redo logs ?
>

Use the dump tool and dump it to the null device should be a good test, because that will cause the code to read and
parse the entire contents.

[Cédric Briner]

Hi

As I do not know at all h2 databases, what bash command should I use to do this dump in /dev/null ?

Regards,

cED 

[Andrei Tokar]

Something like: 

java -classpath h2.jar org.h2.mvstore.MVStoreTool -dump /path/to/database/test.mv.db >/dev/null