db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondru...@kaibo.eu>
Subject Re: Incremental Online Backup
Date Sat, 16 Sep 2017 12:54:38 GMT
Depends what you mean by incremental. Should you want to minimize data
created by backup (and increase time to recover) enable log arching and
protect full database backup and log files created after that. There is no
such thing as backing up "incrementally" i.e. only those blocks that
changed since last backup.

I would recommend running with log archiving anyway and doing online backup
(SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE) frequently
enough (daily) avoiding applying many log files for recovery.

See https://db.apache.org/derby/docs/10.0/manuals/admin/hubprnt46.html and
documentation on the procedures used in that page.

p.

On 16 September 2017 at 14:32, Shreyans Jain <shreyans2799@gmail.com> wrote:

> Is it possible in any way (may be a workaround or hack) to do online
> incremental backup of anything (logs, data files etc) by which database can
> be restored using that backup.
>
> Regards,
> Shreyans Jain
>



-- 
Peter Ondruška

-- 
kaibo, s.r.o., ID 28435036, registered with the commercial register 
administered by the Municipal Court in Prague, section C, insert 141269.
Registered office and postal address: kaibo, s.r.o., Kališnická 379/10, 
Prague 3, 130 00, Czech Republic.
https://www.kaibo.eu

Mime
View raw message