db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bergquist, Brett" <BBergqu...@canoga.com>
Subject Question about online backup
Date Fri, 02 Dec 2011 19:14:25 GMT
We currently use the SYSCS_UTIL.SYSCS_BACKUP_DATABASE procedure to perform an online backup
of the database.  This has been working well.  We are wondering however, if we can control
the relative priority of this backup to have less of an impact on the normal concurrent operation
of the database.

Here is the use case.   The system is being accessed and updated 24/7 and there is no down
time.   The customer wants to create a backup once a day.  There is no specific point in time
that they are trying to capture so knowing exactly which transactions are included or excluded
from the backup is not that important.  They would use the backup only for a catastrophic
failure to get "close" to what something was on a day and a higher level system interacting
with this one would replay anything necessary after restoral of one of these backups.  In
the 5 years that the system has been running a restoral of a backup has never been necessary.

What is important is that the online backup being performed does not adversely affect the
normal operation of the system.   There are plenty of CPU cycles and should be plenty of I/O
bandwidth.  This is an Oracle M5000 system with 32 cores and 32 Gb of memory with mirrored
 drives using ZFS as the file system.

So what I was wonder is, is it possible to perform the backup at a lower relative priority
than normal database operations.  It is okay if the backup takes longer, that is not a problem.

Any guidance will be greatly appreciated.

Brett

Mime
View raw message