db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5508) Improve backup/restore documentation visibility and content to encourage proper backups and restore procedures
Date Wed, 18 Apr 2012 20:46:42 GMT

     [ https://issues.apache.org/jira/browse/DERBY-5508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Kim Haase updated DERBY-5508:

    Attachment: DERBY-5508.zip

Attaching DERBY-5508.diff, DERBY-5508.stat, and DERBY-5508.zip, with changes to 18 files:

M       src/devguide/tdevcsecurenewbootpw.dita
M       src/devguide/tdevcsecurenewextkey.dita
M       src/devguide/tdevcsecureunencrypteddb.dita
M       src/getstart/cwwdsummary.dita
M       src/getstart/cgsquck19524.dita
M       src/adminguide/cadminbckupdb.dita
M       src/adminguide/cadminconsist01.dita
M       src/adminguide/cadminhubbkup01.dita
M       src/adminguide/cadminhubbkup12677.dita
M       src/adminguide/cadminhubbkup63476.dita
M       src/adminguide/cadminhubbkup67525.dita
M       src/adminguide/cadminhubbkup98797.dita
M       src/ref/rrefbackupdbenablelogproc.dita
M       src/ref/rrefbackupdbproc.dita
M       src/ref/rrefdisablelogproc.dita
M       src/ref/rreffreezedbproc.dita
M       src/ref/rrefsyscschecktablefunc.dita
M       src/ref/rrefunfreezedbproc.dita

I hope I have provided some overviews and links in the Admin Guide that guide users in the
right directions.

One of the Developer's Guide topics I mentioned earlier turned out to be more about authorization
than backups, so I added Admin Guide cross-references to only 3 topics in that book.

The changes to the "What next with Derby?" topic in Getting Started really have nothing to
do with the backup issues except that the topic now points to the Derby documentation. It
was just a good chance to clean it up.

I also took advantage of the opportunity to correct a typo and update some very old dates
in some reference topics.

More suggestions are welcome. Thanks!
> Improve backup/restore documentation visibility and content to encourage proper backups
and restore procedures
> --------------------------------------------------------------------------------------------------------------
>                 Key: DERBY-5508
>                 URL: https://issues.apache.org/jira/browse/DERBY-5508
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:,
>            Reporter: Kathey Marsden
>            Assignee: Kim Haase
>         Attachments: DERBY-5508.diff, DERBY-5508.stat, DERBY-5508.zip
> In a very large percentage of cases where users  need to restore their backup, I have
found that they don't have a usable backup to restore.  It is often difficult to determine
the root cause, so I am not sure of all of these, but my experience and suspicions are:
> 1) They relied on a operating system backup while the database was not shutdown or frozen.
> 2) They unknowingly backed up a corrupt database over their good backup because  there
was corruption that was not readily apparent at the time of the backup.
> 3) They relied on incremental backups (even when the database was shutdown) that did
not properly track deletes.
> 4) They restored to an existing database directory without removing the old one first.
> 5) They didn't backup because the Derby backup was not included in the embedding application''s
backup procedure.
> 6) The embedding application's did have a backup/restore procedure but it made one of
the mistakes above.
> It would be good to think about our backup and restore documentation to make it more
visible to users and developers and include tips for good backup procedures. Two things I
can think of that might help are.
> 1) Encourage SYSCS_UTIL.SYSCS_CHECK_TABLE  on all the tables of the database before backing
up to help flag existing corruption before potential existing issues before overwriting a
> 2) Put pointers in the Getting Started Guide and the Developers guide to the backup instructions
in the Administration manual.
> I am sure others have ideas on how to improve the doc. Kim suggested I log this issue
and track the various ideas so she can document them for the next release.  
> The relevant doc references are:
> http://db.apache.org/derby/docs/10.8/adminguide/cadminbckupdb.html
> http://db.apache.org/derby/docs/10.8/adminguide/radminconsist24642.html 

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message