I'm using the tips in this page to achieve a similar goal:


Basically, instead of shutting down the server, you use a command to freeze the DB, then copy the files, then unfreeze the DB. The freeze call will block until it is safe to copy the files.

On Tue, Jul 31, 2012 at 5:49 PM, Mo Maison <momaison@yahoo.fr> wrote:
Hello Derby users,

I encounter sometimes a problem during cold backups :
Derby is launched as a server (listening localhost only ) ;
I stop the network server with standard command :
  java -cp ... \
  org.apache.derby.drda.NetworkServerControl shutdown \
  -h localhost -p 1527

Right after command has returned, I perform a tar of the
database files.
However, I have observed that, on a slow filesystem, somes
files get deleted while tar is reading them. Which let me think
that server is not fully stopped when process returns
(and thus backup may be corrupted).

Is that expected ?
How can I be sure that everything is quiescent before performing
the cold backup ?
I use Derby 10.6.2 on 32 bits Linux.

Thank you for your advices,

 M. Maison