Incremental Online Backup

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Incremental Online Backup

Shreyans Jain
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
Reply | Threaded
Open this post in threaded view
|

Re: Incremental Online Backup

Peter Ondruška-4
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 <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: Incremental Online Backup

Shreyans Jain
yes, i meant small backups like differential backup from previous backup.

On Sat, Sep 16, 2017 at 6:24 PM, Peter Ondruška <[hidden email]> wrote:
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 <[hidden email]> 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