ving 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.
>
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
Why would we need any kind of power backup if every thing is directly
written to disk, write cache being off. Only risk would be of losing last
transaction data.
On Jul 16, 2017 7:58 PM, "Rick Hillegas" <rick.hille...@gmail.com> wrote:
> On 7/15/17 10:12 PM, Shreyans Jain wr
If we have write cache off, do we need a ups or some other power backup ?
On Sat, Jul 15, 2017 at 8:02 PM, Rick Hillegas <rick.hille...@gmail.com>
wrote:
> On 7/14/17 6:21 PM, Shreyans Jain wrote:
>
>> If we have a ups and we properly shutdown the OS, will then we have to
>
If we have a ups and we properly shutdown the OS, will then we have to
disable write cache for the hard-disk in order to prevent data corruption.
Are there any chances left for the data to be corrupted by power failure
with write cache on?
Regards,
Shreyans Jain
rite cache that we can disable via OS on windows 10 from
Device Manager > Properties of Disk Drive > Policies tab or it has to be
disabled from somewhere in BIOS.
Regards,
Shreyans Jain
On Thu, Jul 13, 2017 at 12:32 AM, Kristian Waagan <krist...@apache.org>
wrote:
> Hi Shreyans,
&g
no effect.
Regards,
Shreyans Jain
I was reading https://wiki.apache.org/db-derby/DatabaseCorruption and i
found prevention of corruption which states
"Switch off the machine's write caching" . now the article is written in
2013. Is it still application to derby database corruption or now it has no
effect.
Regards,
Shreyans Jain