 |
When spooling is enabled, the spool file maximum size before it is flushed to the disk/tape can be set. Can a "commit point" easily introduced at that flush time? |
|
|
Hello pmarques, you can already restore from a partial backup by selecting the jobid of the failed job: restore jobid=<jobid> Of course that can only restore data that was already backed up in the failed job. To set a failed job to have terminated successful, you could update the job table column jobstatus form 'E' to 'T'. If you do so, you will still not backup the missing data on the next incremental backup, because the determinatino of what has to be backed up is based on the timestamp. The only possibility I see to backup the missing files would be to use accurate backup. You could try to use accurate and see if the next incremental backup really gets all data that was not backed up during the first full backup. I hope this info helps. best regards, Philipp |
|
|
Philipp Thank you for your answer. The problem for me is not as much as to be able to recover the partial data than to be able to have the partial backup consolidated on the database as is, enabling the normal selection and recovery of individual files from that failed backup instance. Also, if you have spooling enable, as I do, if the backup fails for whatever reason the partial backup will be deleted for good and it will never make it to the database or to the tapes. Regards Pablo |
|
|
We are not planning to implement that until we find some sponsor for it. |
- Anonymous
