Ajcody-Backup-Restore-Issues: Difference between revisions
| (48 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
{| | {{BC|Zeta Alliance}} <!-- Note, this will also add [[Category: Zeta Alliance]] to bottom of wiki page. --> | ||
__FORCETOC__ <!-- Will force a TOC regards of size of article. __NOTOC__ if no TOC is wanted. --> | |||
<div class="col-md-12 ibox-content"> | |||
=Ajcody Backup & Restore Issues= <!-- Normally will reflect page title. Is listed at very top of page. --> | |||
= | {{KB|{{ZETA}}|{{ZCS 8.5}}|{{ZCS 8.0}}|{{ZCS 7.0}}|}} <!-- Can only handle 3 ZCS versions. --> | ||
{{WIP}} <!-- For pages that are "work in progress". --> | |||
===Actual Backup & Restore Issues Homepage=== | ===Actual Backup & Restore Issues Homepage=== | ||
Please see [[Ajcody-Backup-Restore-Issues]] | Please see [[Ajcody-Backup-Restore-Issues]] | ||
====Update - May, 2017==== | |||
I'll be updating this page after the ZCS 8.8 release is done to only reflect what is true in that version and future versions. It will also include information about the [[Zimbra_Suite_Plus]] modules where appropriate. If you currently are using the backup module for ZSP, please see [[Zimbra_Suite_Plus/Zimbra_Backup_Plus]] for now. | |||
====Backup-Restore Training Material Rough Drafts I Wrote==== | |||
* [[Ajcody-Troubleshooting-Recover_Missing_Data_-_Server]] | |||
* [[Ajcody-Troubleshooting-Recover_Missing_Data_-_User]] | |||
====Bug/RFE's I Filed Against ZCS 8.6==== | |||
* [story] Ability to search data within backup and do "item" restores or identify locations of search results | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97551 | |||
* admin console backup label view doesn't list accounts in the all accounts tab | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97555 | |||
* admin console restore - doesn't autocomplete / suggest account matches when filling out email address box | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97556 | |||
* document new restore functions / options with ZCS 8+ for admin console restore | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97558 | |||
* admin console restore - rename "Selected Servers" panel to "Restore Options" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97559 | |||
*admin console restore - if only one mailstore in env. then state such in second panel of restore about "server for the restored accounts" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97560 | |||
*admin console restore - expand restore To options - To full backup label, To incremental target | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97561 | |||
*admin console restore - "restore to the latest backup" incorrectly described / broken | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97562 | |||
* admin console restore - unable to restore individual accounts [sort of] | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97564 | |||
* admin console restore - reuse GAL/Contact Picker Window for "restore individual accounts" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97565 | |||
====Miscellaneous Bugs & RFE's==== | ====Miscellaneous Bugs & RFE's==== | ||
| Line 17: | Line 50: | ||
*** "add backup/restore for HSM only" [marked as duplicate of above] | *** "add backup/restore for HSM only" [marked as duplicate of above] | ||
**** http://bugzilla.zimbra.com/show_bug.cgi?id=28200 | **** http://bugzilla.zimbra.com/show_bug.cgi?id=28200 | ||
=====RFE For Live DR Restore Option===== | |||
* zmrestore / zmrestoreoffline have options to --skipDeleteMailboxes - Provides Live DR option | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=94368 | |||
=====Backups And Upgrades And Prior Versions===== | =====Backups And Upgrades And Prior Versions===== | ||
| Line 41: | Line 79: | ||
======Trend Data====== | ======Trend Data====== | ||
If there is concerns about disks/partitions getting full, this command would be helpful for trending data on your server. Send support the resulting df.tar file . | If there is concerns about disks/partitions getting full, this command would be helpful for trending data on your server. Send support the resulting df.tar file . Note - adjust the tail command if you want more than 20 day's worth of trending data, the -n 20 option. | ||
<pre> | <pre> | ||
[zimbra@zcs806 | [zimbra@zcs806 tmp]$ /tmp | ||
[zimbra@zcs806 tmp]$ tar cvf /tmp/df.tar `find /opt/zimbra/zmstat -name df.cs\* | sort | tail -n 20` | |||
tar: Removing leading `/' from member names | tar: Removing leading `/' from member names | ||
/opt/zimbra/zmstat/2014-03-10/df.csv.gz | |||
/opt/zimbra/zmstat/2014-03-11/df.csv.gz | |||
[cut - Ajcody] | |||
/opt/zimbra/zmstat/2014-03-27/df.csv.gz | |||
/opt/zimbra/zmstat/2014-03-28/df.csv.gz | |||
/opt/zimbra/zmstat/df.csv | /opt/zimbra/zmstat/df.csv | ||
[zimbra@zcs806 | [zimbra@zcs806 tmp]$ ls -lah /tmp/df.tar | ||
-rw-r----- 1 zimbra zimbra | -rw-r----- 1 zimbra zimbra 80K Mar 29 06:44 /tmp/df.tar | ||
[zimbra@zcs806 | [zimbra@zcs806 tmp]$ tar tvf /tmp/df.tar | ||
-rw-r----- zimbra/zimbra | -rw-r----- zimbra/zimbra 2566 2014-03-11 00:00 opt/zimbra/zmstat/2014-03-10/df.csv.gz | ||
-rw-r----- zimbra/zimbra | -rw-r----- zimbra/zimbra 2553 2014-03-12 00:00 opt/zimbra/zmstat/2014-03-11/df.csv.gz | ||
[cut - Ajcody] | |||
-rw-r----- zimbra/zimbra 2513 2014-03-28 00:00 opt/zimbra/zmstat/2014-03-27/df.csv.gz | -rw-r----- zimbra/zimbra 2513 2014-03-28 00:00 opt/zimbra/zmstat/2014-03-27/df.csv.gz | ||
-rw-r----- zimbra/zimbra 2531 2014-03-29 00:00 opt/zimbra/zmstat/2014-03-28/df.csv.gz | |||
-rw-r----- zimbra/zimbra | -rw-r----- zimbra/zimbra 8013 2014-03-29 06:40 opt/zimbra/zmstat/df.csv | ||
-rw-r----- zimbra/zimbra | |||
</pre> | </pre> | ||
| Line 71: | Line 111: | ||
* [[Ajcody-Server-Misc-Topics#Faster_Way_To_Get_Directory_Size_On_Filesytem_-_find_vs_du]] | * [[Ajcody-Server-Misc-Topics#Faster_Way_To_Get_Directory_Size_On_Filesytem_-_find_vs_du]] | ||
=====The | ======Adjusting The Disk Alert Threshold====== | ||
'''Note''' - zmlocalconfig smtp_notify must return yes if you want to receive the notifications. | |||
If you just need to adjust the disk alert threshold, then see the following: | |||
See current values: | |||
zmlocalconfig | grep zmdisklog | |||
Example adjustment: | |||
<pre> | |||
su - zimbra | |||
zmlocalconfig -e zmdisklog_critical_threshold=98 | |||
zmlocalconfig -e zmdisklog_warn_threshold=95 | |||
zmstatctl | |||
</pre> | |||
To exclude a partition from the checks [example of two being excluded]: | |||
<pre> | |||
su - zimbra | |||
zmlocalconfig -e zmstat_df_excludes="/mount/point:/mount/point2" | |||
zmstatctl | |||
</pre> | |||
They might be a bug on this, where you'll keep getting email until a logrotate happens [zimbra.log?]. | |||
= | * Changing Zmstat-df values do not take affect until logrotate | ||
** https://bugzilla.zimbra.com/show_bug.cgi?id=79148 | |||
Some things to do to confirm and share with support or in bug. As zimbra | |||
<pre> | |||
su - zimbra | |||
ls -la /var/log/zimbra.log | |||
df -h | |||
/dev/mapper/vg_rhel664-lv_root | |||
5.5G 3.5G 1.7G 68% / | |||
tmpfs 939M 0 939M 0% /dev/shm | |||
/dev/sda1 485M 79M 381M 18% /boot | |||
/dev/sdb1 30G 6.2G 23G 22% /opt | |||
date | |||
= | zmlocalconfig | grep zmdisklog | ||
zmdisklog_critical_threshold = 80 | |||
zmdisklog_warn_threshold = 85 | |||
zmlocalconfig -e zmdisklog_critical_threshold=95 | |||
- | zmlocalconfig -e zmdisklog_warn_threshold=90 | ||
zmlocalconfig | grep zmdisklog | |||
zmdisklog_critical_threshold = 95 | |||
zmdisklog_warn_threshold = 90 | |||
zmstatctl restart | |||
date | |||
ps -eaf | grep zmstat-df | |||
ls -la /var/log/zimbra.log | |||
date ; grep "Disk warning" /var/log/zimbra* ; zmmailbox -z -m admin@`zmhostname` s -l 100 -t message "Subject: Disk and after:yesterday" | |||
##Note - Emails by default go out every 10 minutes - for example: | |||
[zimbra@zcs803 ~]$ date ; grep "Disk warning" /var/log/zimbra* ; zmmailbox -z -m admin@`zmhostname` s -l 100 -t message "Subject: Disk and after:yesterday" | |||
Thu May 22 09:40:08 PDT 2014 | |||
/var/log/zimbra.log:May 22 08:30:00 zcs803 zimbramon[18826]: 18826:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82% | |||
/var/log/zimbra.log:May 22 08:40:00 zcs803 zimbramon[22970]: 22970:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82% | |||
/var/log/zimbra.log:May 22 08:50:00 zcs803 zimbramon[22970]: 22970:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82% | |||
/var/log/zimbra.log:May 22 09:00:00 zcs803 zimbramon[22970]: 22970:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82% | |||
## Note - I had readjusted the variable to not warn during this time segment ## | |||
/var/log/zimbra.log:May 22 09:20:00 zcs803 zimbramon[8322]: 8322:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82% | |||
/var/log/zimbra.log:May 22 09:30:00 zcs803 zimbramon[8322]: 8322:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82% | |||
/var/log/zimbra.log:May 22 09:40:00 zcs803 zimbramon[8322]: 8322:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82% | |||
num: 7, more: false | |||
Id Type From Subject Date | |||
---- ---- -------------------- -------------------------------------------------- -------------- | |||
1. 328 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:40 | |||
2. 327 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:30 | |||
3. 326 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:20 | |||
## Note - I had readjusted the variable to not warn during this time segment ## | |||
4. 325 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:00 | |||
5. 324 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 08:50 | |||
6. 323 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 08:40 | |||
7. 320 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 08:31 | |||
</pre> | |||
Continue to monitor your zmmailbox search results for an hour. | |||
=====The Basic Information Support Needs===== | |||
as root: | |||
* cat /etc/fstab | |||
** Shows us what is mounted upon boot | |||
* cat /proc/mounts | |||
** Shows us what is currently mounted and its status - you can see if a mount is read-only here. | |||
* df -hT | |||
** Lists current mounts using human-readable size information and also notes the filesystem type. | |||
as zimbra: | |||
This is the | * zmprov -l gs `zmhostname` | egrep 'Back|Redo' | ||
** Will show us a number of variables related to backup and redologs. Also tell us if your using auto-group or the default method. | |||
* du -sh /opt/zimbra/redolog | |||
** Will might notice your redolog logs aren't rolling over, causing a possible issue. | |||
* ls -latr /opt/zimbra/backup | |||
** This is the default backup target, please adjust this path here and below if you are using a different zimbraBackupTarget value. | |||
** zmprov gs `zmhostname` zimbraBackupTarget | |||
** We'll be able to confirm permissions are right. | |||
* ls -latr /opt/zimbra/backup/tmp | |||
** This will show us if you have failed backup jobs and confirm tmp is being cleaned appropriately after the backup is done. | |||
* ls -latr /opt/zimbra/backup/sessions | |||
** This will show us what backup sessions are available and confirm permissions are correct. | |||
** Adjust path if your zimbraBackupTarget value is not the default path. | |||
*** su - zimbra | |||
*** zmjava com.zimbra.cs.backup.util.GetVersion | |||
*** cd /opt/zimbra/backup/sessions/full-[YOUR MOST RECENT FULL]/ | |||
*** head -n6 session.xml | |||
*** cd /opt/zimbra/backup/sessions/incr-[YOUR MOST RECENT INCREMENTAL]/ | |||
*** head -n6 session.xml | |||
* Some directory sizes in the backup directory: | |||
** Default path first | |||
*** du -sh `find /opt/zimbra/backup -maxdepth 2 -type d` | |||
** If your using a different backup target, check that directory also. Replace /opt/zimbra/backup above with your backup path. | |||
* zmbackupquery | |||
** This should match what's in the sessions directory and it will also tell us if status of each backup and how many accts were done. | |||
* crontab -l | grep -i back | |||
** This will show use when backups are support to run and with what options they are running with. | |||
* zmlocalconfig | grep -i back | |||
** This is useful to see a number of backup options not exposed in the crontab, things related to the zip options. | |||
* zmvolume -l | |||
** This is useful to see how many volumes are being used, if HSM is being used, and if compression is being done at the volume level. | |||
=====Additional Log Files Support Might Need===== | |||
And send the following logs: | |||
* | * /var/log/messages | ||
* | ** Filesystem issues often times are noted here and also in syslog. This might explain an interruption in the backup process. Server restarts, filesystem going full, filesystem going read-only, etc. | ||
* /var/log/syslog | |||
* | * /opt/zimbra/log/mailbox.log | ||
** The backup activity is logged here. | |||
** | ** And any other mailbox.log file that would cover the event | ||
==== | ====Additional Checks For Performance Specific Issues==== | ||
=====If Your Using a SAN or NFS For Your Backup Target - Please Check Your IOWait===== | |||
Ideally, you would compare iowait and performance data from the target backup host as well as the stats available on the ZCS servers. To get graphs and stats on this from ZCS, please see [[Ajcody-Testing-Debugging#zmstat_and_zmstat-chart]] . You should submit this data and iowait conclusions if you still need to submit a support case about backup performance issues. | |||
=====Is HSM Running During Your Backup Window===== | |||
* Are you running HSM? HSM should not be ran during your backup window. | |||
** "RFE: HSM and backup should not run at the same time if initated." | |||
*** https://bugzilla.zimbra.com/show_bug.cgi?id=33452 | |||
=====Are You Using --zipStore===== | |||
--zipStore zips the blobs vs. keeping the blobs as individual files. --zipStore does not use compression either. For most circumstances, this will give the best performance, especially with NFS. This should be the default behavior of the backups, the following RFE is when it became the default [ZCS6+] : | |||
* "backup: default to the zip option" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=31836#c6 | |||
*** Link to comment that explains options and default behavior. | |||
To see if zip's are being used for backups for example, in the backup/session directory you'll know if it is by seeing .zip files: | |||
mail:~/backup/sessions/full-20080820.160003.770/accounts/115/988/11598896-a89b-4b9d-bedb-1ed1afcb6c87/blobs | |||
zimbra$ ls blobs-1.zip blobs-2.zip blobs-3.zip blobs-4.zip | |||
To see if the zip file is using compression [-Z option for unzip will indicate whether or not the archive is actually compressed] : | |||
unzip -Z blobs-4.zip | |||
293 files, 5982984 bytes uncompressed, 5982984 bytes compressed: 0.0% | |||
Also, if your zmvolume has compression enabled the blobs will remain compressed within the zip also upon backup. The point being, they are uncompressed to be then put into a zip file when the backup is using --zipStore. | |||
=== | ===Restore Compatibility Between ZCS Versions=== | ||
Please see the following for details. In summary, user level restores should work against older ZCS backup data. | |||
* "support for restore across major versions" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=15750#c18 | |||
* | |||
Other related bug/rfe's: | |||
==== | * support for restore across major versions | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=15750 | |||
* Restore across multiple versions | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=25761 | |||
* Restore across multiple versions | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=25764 | |||
* Backups must be compatible across patch releases | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=16239 | |||
* write ZCS version into backup | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=27819 | |||
* Restore should deal with database schema changes that add columns with defined default value | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=26804 | |||
* Incorrect upgrade documentation regarding backups | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=30218 | |||
===NFS Use For Backups=== | |||
Please see this RFE: | |||
* "Need clarity on supporting nfs mounted zimbra directories - report error/msg if nfs mount is present" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=33221 | |||
This is the proposed statement to be included in the release notes following the RFE: | |||
: ZCS & NFS: | |||
: Zimbra will support customers that store backups (e.g. /opt/zimbra/backup) on an NFS-mounted partition. Please note that this does not relieve the customer from the responsibility of providing a storage system with a performance level appropriate to their desired backup and restore times. In our experience, network-based storage access is more likely to encounter latency or disconnects than is equivalent storage attached by fiber channel or direct SCSI. | |||
:Zimbra continues to view NFS storage of other parts of the system as unsupported. Our testing has shown poor read and write performance for small files over NFS implementations, and as such we view it unlikely that this policy will change for the index and database stores. We will continue to evaluate support for NFS for the message store as customer demand warrants. | |||
:When working with Zimbra Support on related issues, the customer must please disclose that the backup storage used is NFS. | |||
====Things To Check==== | |||
* Check the /var/log/messages on both the zimbra server and the nfs server for nfs related errors during the time frame of your backup. | |||
* Check /opt/zimbra/log/mailbox.log for error messages about folders/files not being able to be written or missing directory errors. | |||
* Is root_squash configured on the nfs server? If it's changed to no_root_squash , does the behavior of the backup change? | |||
* Is the */backup directory owned by zimbra:zimbra with at least 750 or 755 permissions? | |||
** This parent directory as given in: | |||
*** zmprov gs `zmhostname` zimbraBackupTarget | |||
* Does zimbraBackupTarget have at least the subdirectories of : sessions and tmp : and are owned by zimbra:zimbra with 750 or 755 permissions? | |||
** If not, try manually creating them and then running a test backup. | |||
* '''IF USING A NAS - MAKE SURE YOUR NOT USING EXTENDED ACLS OR THAT YOU HAVE THEM CONFIGURED PROPERLY''' | |||
** If your backup session directory shows something like : drwxrwx---+ 2 zimbra zimbra 4096 Sep 14 00:00 TO_DELETE-full-XXXXXX , that '''+''' sign indicated extended acls are in use. | |||
====Debugging Example==== | |||
Steps I wrote for one customer, where saving out the information as you walk through all the commands would give enough information [hopefully] to submit a good rfe/bug: | |||
<pre> | |||
1. make a test partition on nfs server - /nfs-test | |||
2. mount on zimbra server | |||
2A. mkdir /nfs-test | |||
2B. chmod 755 /nfs-test | |||
2C. mount nfs-server:/nfs-test /nfs-test | |||
2D. ls -la /nfs-test | |||
2E. mkdir /nfs-test/backup | |||
2F. chown zimbra:zimbra /nfs-test/backup | |||
2G. chmod 755 /nfs-test/backup | |||
2H. su - zimbra ; touch /nfs-test/backup/testfile | |||
2I. ls -laR /nfs-test/ | |||
2J. rm /nfs-test/backup/testfile | |||
3. Set zimbraBackupTarget | |||
3A. zmprov ms `zmhostname` zimbraBackupTarget /nfs-test/backup | |||
4. Run a full backup against one account | |||
4A. ex. zmbackup -f -a user@domain.com | |||
5. ls -laR /nfs-test/ | |||
6. If you again, run into the same problem. You could also repeat the backup after increasing the backup | |||
logging variable for the account your trying to backup. If you didn't run into the same problem, it might | |||
had to do with the initial setup of the nfs mount and permissions being used during the directory creation. | |||
6A. zmprov aal user@domain.com zimbra.backup debug | |||
6B. logging will show up in /opt/zimbra/log/mailbox.log | |||
6C. Remove account logging when your done. zmprov ral user@domain.com zimbra.backup | |||
8. Change zimbraBackupTarget back to your production path. | |||
</pre> | |||
====Setup A Fast Test NOT Using NFS==== | |||
A way to "avoid" the NFS issues for testing purposes would be to setup a new zimbraBackupTarget to try doing a full backup of a couple of user accounts. I DON'T recommend this if your using auto-group for zimbraBackupMode [ zmprov gs `zmhostname` zimbraBackupMode ] , only if your using Standard mode. | |||
<pre> | |||
[as root] | |||
** adjust your new "backup" directory path as needed - mine is just an example** | |||
mkdir /mnt/usb1/backup-test | |||
chown zimbra:zimbra /mnt/usb1/backup-test | |||
chmod 750 /mnt/usb1/backup-test | |||
*- | su - zimbra | ||
** | **confirm backup mode as standard** | ||
** | zmprov gs `zmhostname` zimbraBackupMode | ||
* | **if not stand, please stop** | ||
** | zmprov ms `zmhostname` zimbraBackupTarget /mnt/usb1/backup-test | ||
*** | **Find a couple of test accounts to do a full for. Make sure you'll have space to do the backup regards to need free space.** | ||
*- | zmbackup -f -a user1@domain.com user2@domain.com user3@domain.com | ||
**Watch and confirm status of backup you just started.** | |||
zmbackupquery | |||
**Confirm files were backed up in right location** | |||
ls /mnt/usb1/backup-test/sessions/ | |||
**Failed backups would most likely results in left over directory in tmp directory** | |||
ls /mnt/usb1/backup-test/tmp/ | |||
</pre> | |||
===Restore For Disaster Recovery=== | |||
====For Full Single ZCS Server DR Restores==== | |||
Please see [[Network_Edition_Disaster_Recovery]] | |||
Some additional notes I have on it - [[Ajcody-Disaster-Recovery-Specific-Notes]] | |||
====For Multi-Server DR Restore Specifics==== | |||
Along with the above references, please see [[Ajcody-Notes-Multi-Server-Restore-DR]] | |||
==== | ====To Restore Just The LDAP Date==== | ||
Let's say your ldap data was 'lost/destoyed' but everything else was intact, you should look at the zmrestoreldap command. | |||
This section should have more precaution and background information to handle this section. | |||
The basics: | |||
* To find the LDAP session labels type -lbs. | |||
** zmrestoreldap -lbs | |||
* Restore the complete LDAP directory server | |||
** zmrestoreldap -lb full20061130135236 | |||
* Restore LDAP data for specific accounts | |||
** zmrestoreldap -lb full20061130135236 -a tac@DOMAIN.com jane@DOMAIN.com | |||
==== | ====To Restore Just The Mysql DB==== | ||
Option available from the following RFE work: | |||
* | * "Allow backup of only primary message volume" | ||
** | ** https://bugzilla.zimbra.com/show_bug.cgi?id=35278 | ||
*-- | *** Options '''''to exclude types of data''''' as described in the 6.0.6 Admin Guide: | ||
** | **** '''Search index''' : If you do not restore the search index data, the mailbox will have to be reindexed after the restore. | ||
*-- | ***** zmrestore <all or account> --exclude-search-index | ||
** | **** '''Blobs''' : This is a useful option when all blobs for the mailbox being restored already exists. | ||
***** zmrestore <all or account>|--exclude-blobs | |||
**** '''HSM-blobs''' : This is useful when all HSM blobs for the mailbox being restored already exists. | |||
***** zmrestore <all or account> --exclude-hsm-blobs | |||
Let's say your mysql data was 'lost/destoyed' but everything else was intact. This might be the solution for the situation: | |||
'''Caution''' | The steps below are to REPRODUCE A DR situation to test. | ||
# zmcontrol stop | |||
# '''Caution''' - step to reproduce DR situation to test against | |||
## mv ~/db/data ~/db/data.OLD | |||
# Getting old mysql passwords | |||
#* zmlocalconfig -s mysql_root_password | |||
= | #* zmlocalconfig -s zimbra_mysql_password | ||
# [as zimbra] /opt/zimbra/libexec/zmmyinit | |||
#* Most likely your mysql passwords will change. | |||
#* See the following article to set them back: | |||
#** [[Resetting_LDAP_%26_MySQL_Passwords]] | |||
#** [[Issues_with_mysql_and_logmysql_passwords#For_Mysql_Database]] | |||
# ldap start | |||
# zmconvertctl start | |||
# mysql is already running per the zmmyinit - mysql.server status - to check. | |||
# zmrestoreoffline -a all -br --systemData --excludeSearchIndex --excludeBlobs --excludeHsmBlobs | |||
#* Note - you most likely will want to use the -br or -rf option for this situation. | |||
#** -br,--backedupRedologsOnly : Replays the redo logs in backup only, which excludes archived and current redo logs of the system | |||
#** -rf,--restoreFullBackupOnly : Restores to last full backup only, which excludes incremental backups. | |||
#* -sys,--systemData : Restores global tables and local config. | |||
#** This restores the 'zimbra' mysql data - this stuff [[Ajcody-Mysql-Topics#zimbra_Database_Default_Example_for_ZCS5]] | |||
#** '''Important''' - the zimbra db holds information about the volumes. This needs to be restored/existing prior to user db restoration. | |||
#* Note the use of -a all , you could also do this for one account first to confirm operation is successful for your circumstances. | |||
# If you used -rf or -br with your zmestoreoffline, you might also need to use zmplayredo to finish it up to get the most complete restore. | |||
#* Improve zmrestore & zmrestoreoffline performance | |||
#*** http://bugzilla.zimbra.com/show_bug.cgi?id=33606 | |||
#* [[Ajcody-Backup-Restore-Issues#zmplayredo_-_Replaying_Content_From_Any_Redolog_File]] and other 'redolog' sections on that page. | |||
=== | ===Performance Issues And Time To Complete=== | ||
Please see [[Ajcody-Notes-BackupPlans#What_About_Backups.3F_I_Need_A_Plan]] | |||
Also created an RFE for increase backup performance: | |||
* "Improve zmrestore & zmrestoreoffline performance" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=33606 | |||
* "Improvement to backup performance" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=36220 | |||
** Above marked as a dupe of "Reduce duration of maintenance mode during backup" | |||
*** http://bugzilla.zimbra.com/show_bug.cgi?id=33583 | |||
For | ===Understanding Option Flags For zmbackup & zmrestore=== | ||
First, they don't make sense if your just reading from the help output - I will not argue this point at all. | |||
The biggest problem with the options I point out below is that you can often include them in the command and they do nothing or you include them for a particular situation and they don't apply. Why is this a problem? Because they are silent and give no output telling you that it's not necessary, it's redundant, or it will actually cause your intended results to fail simply because you included the option. | |||
====zmrestore Options==== | |||
Problems mostly revolve around these options. | |||
==== | =====To Times In The Past (If -lb Isn't Used, Implies Your Using Times/Incr/RedoSeq AFTER Last Full)===== | ||
*-restoreToIncrLabel | |||
**<arg> Replay redo logs up to and including this incremental backup | |||
*** Requires: --label or -lb | |||
*-restoreToTime | |||
**<arg> Replay rodo logs until this time | |||
*** Requires: --label or -lb | |||
*-restoreToRedoSeq | |||
**<arg> Replay up to and including this redo log sequence | |||
=====Redolog Variables===== | |||
* | *--backedupRedologs or -br | ||
** | **Replays the redo logs in backup only, which excludes archived and current redo logs of the system | ||
*** Only useful when restoring against latest full backup (NOT using the -lb option). | |||
*** Will restore using incremental backup data after the last full backup as well but NOT including any redolog activity. | |||
*--restorefullBackup or -rf | |||
**Restores to the full backup only, not any incremental backups since that backup. | |||
*** The default behavior of zmrestore in general is to always play from a "full" and "incrementals" that are associated with it UNLESS you state otherwise. | |||
**** If you do: <pre>zmrestore -a user@domain.com -lb full6monthsago</pre> | |||
**** It will playback the incremental data associated with that full from 6 months ago. | |||
**** If you do: <pre>zmrestore -a user@domain.com -lb full6monthsago -rf</pre> | |||
**** It will ONLY playback the data in the full from 6 months ago. | |||
*** Will not progress past the data that's in the last full backup, no incremental backups after it in other words. | |||
*** Implies NO redolog play, so there's no need to use -br. | |||
===== | =====Targets And Labels===== | ||
*--label or -lb | |||
**<arg> The label of the full backup to restore. Restores to the latest full backup if this is omitted. | |||
*--target or -t | |||
**<arg> Specifies the backup target location. The default is <zimbra_home>/backup. | |||
=====Impact Of AutoGroup Option Being Used===== | |||
Place for notes about how autogroup backup option might impact or limit command options. | |||
==== | ====zmbackup Options==== | ||
Problems mostly revolve around these options: | |||
*--target or -t | |||
**<arg> Specifies the target backup location. The default is <zimbra_home>/backup. | |||
*--zip or -z | |||
**Zips email blobs in backup - using compression | |||
*--zipStore | |||
**Zips email blobs in backup - does '''NOT''' use compression | |||
=====Deleting Old Backups -del===== | |||
'''Caution''' You want to delete from the oldest label to newest. The -del option will automatically purge all older sessions prior to the label you used. To find out the label names, use zmbackupquery. | |||
Format example: | |||
zmbackup -del <oldest_backup_label> | |||
=====Impact Of AutoGroup Option Being Used===== | |||
Place for notes about how autogroup backup option might impact or limit command options. | |||
====Changing Default Backup Target==== | |||
To find out what the current backup target is, do: | |||
<pre> zmprov gacf | grep zimbraBackupTarget | |||
zimbraBackupTarget: /opt/zimbra/backup</pre> | |||
This is also configurable at the "server" level: | |||
<pre> zmprov gs `zmhostname` | grep zimbraBackupTarget | |||
zimbraBackupTarget: /opt/zimbra/backup</pre> | |||
For example: | |||
<pre> zmprov ms `zmhostname` zimbraBackupTarget /san/mount/backup</pre> | |||
= | Issues of changing the default path in regards to the admin web console. Please see: | ||
* "Work backup path if it was changed in admin interface" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=28235 | |||
Another way to change the backup path is described at [[Changing_Backup_directory_and_General_Information]]. I recommend reviewing it as well. | |||
See [[Ajcody-Backup-Restore-Issues#Change_.22Location.22_For_Backup_Or_Restore_Source_Data|Change Location For Backup Or Restore Source Data]] for non-default adjustments to CLI commands in regards to a non-default path for backups. | |||
====RFE & Bugs Concerning Option Flags For Restore And Backup==== | |||
=====Setting Account Status After Restore Is Done===== | |||
I filed an RFE for this: | |||
= | * "RFE: zmrestore & zmrestoreoffline have option to set account status" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=52460 | |||
=====Use DL COS Status To Generate User List Of Accounts===== | |||
I filed an RFE for this: | |||
= | * "RFE: backup/restore should allow -a option to use DL's COS Status" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=52489 | |||
An | ===An Overview Of Some Backup/Restore Items=== | ||
====Shared Blobs (messages)==== | |||
I believe we are a little light on describing the shared blobs situation. Shared blobs can cause different corrections to a problem as compared to a normal message issue that isn't shared. I'll start some notes on this here. | |||
From [http://www.zimbra.com/docs/ne/latest/administration_guide/10_Backup_Restore.17.01.html Backup and Restore] | |||
*''"When backing up shared messages, the backup process looks to see whether a Binary Large Object file (BLOB) representing a message already exists in the backup. If it does, it simply flags this object as such and does not copy its content again."'' | |||
*''"Keeping the same backup target saves disk space, because shared binary large object files (BLOB) and other files do not have to be duplicated every time the backup process runs.'' | |||
Bugs/RFE's | |||
* "Use zip files for shared blobs of a full backup made with --zip option" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=26624 | |||
====Remote copies of backup data for DR use==== | |||
You will want to copy over /opt/zimbra/redolog/archive/* and /opt/zimbra/redolog/redo.log frequently in order to stay current. The redo.log file being open is not a problem since the crash recovery step can work with redo.log file in any state. | |||
The redolog/archive/ contains logs that have not yet been backed up by an incremental (or by a full in auto-grouped mode) | |||
The redo.log rolls over when it reaches zimbraRedoLogRolloverFileSizeKB (by default 100MB prior to ZCS 5.0.11 and 1GB after). When ZCS restarts after a crash, it seems to work through the current redo.log ok regardless of its state, if the current log really must be copied." | |||
=====My Initial Thoughts On This===== | |||
Start of process: | |||
*Weekend full on prod | |||
* | *rsync full-xxx on prod > remote sessions/ | ||
** | *rsync redolog/* > remote redolog/ | ||
** through non-full and incremental times every x about of minutes | |||
*weekday nights 10pm incre-xxx on prod | |||
*rsync incr-xxx on prod > remote sessions/ | |||
*rsync redlog/* > remote redolog/ | |||
Created three separate rsync cron rules. | |||
* Full - once a week | |||
** Confirms full is done and then looks for latest full-xxxx and rsyncs that specific directory | |||
* Incre - once a night except for full schedule night | |||
** Confirms incre is done and then looks for latest incr-xxx and rsyncs that specific directory | |||
* Redolog/ - every x amount of minutes (outside of full and incr backups sessions) | |||
** Soes full rsync of redolog/ - probably want delete/remove option? | |||
** lsof will report /opt/zimbra/redolog/redo.log is open. | |||
Somewhere we need to account for accounts.xml in this process. And also confirm what else might be missing. Also, steps on the actually restore process depending on when/where the DR event took place. | |||
====What's Needed For Later Restores==== | |||
In regards to what is moved and what is needed for later restores, you must remember this "flow" of the backups: | |||
* Full backup files that contains all the information needed to restore mailboxes (to that point in time) | |||
* | * Incremental backup files that contains the LDAP directory server files and all the redo log transactions written since the last backup (to that point in time) | ||
* | * Redo logs that contains current and archived transactions processed by the Zimbra server since the last incremental backup (to that point in time - more about this topic is above) | ||
* | |||
Variables to be aware of in regards to backup/restore [ viewed with - zmprov gs [server-name] | grep Backup ]: | |||
* This is that gui path option - note, it doesn't change default to redo file path [see below] | |||
<pre> | |||
zimbraBackupTarget | |||
* | |||
zimbraBackupMode | |||
zimbraBackupAutoGroupedInterval | |||
zimbraBackupAutoGroupedNumGroups | |||
zimbraBackupAutoGroupedThrottled | |||
zimbraBackupReportEmailSubjectPrefix | |||
zimbraBackupReportEmailSender | |||
zimbraBackupReportEmailRecipients | |||
</pre> | |||
* Variables to be aware of in regards to redo files [ viewed with - zmprov gs [server-name] | grep Redo ]: | |||
<pre> | |||
zimbraRedoLogArchiveDir | |||
zimbraRedoLogDeleteOnRollover | |||
zimbraRedoLogEnabled | |||
zimbraRedoLogFsyncIntervalslMS | |||
zimbraRedoLogLogPath | |||
zimbraRedoLogRolloverFileSizeKB | |||
</pre> | |||
====Mysql Table That References Most Recent Backup Session Of Users (AutoGroup Backup Mode)==== | |||
During the backup we update the zimbra.mailbox table for each mailbox to record the most recent backup time. This is in the "last_backup_at" column within Mysql. | |||
This data is used by auto-grouped backup to figure out which mailboxes to backup. | |||
=====Creating A List Of Last Backup Of Users===== | |||
Remove the , | head , below to get a full listing of all your accounts. Note, this reports on the users that exist on the mailstore your running the command. | |||
<pre> | <pre> | ||
[zimbra@zcs806 tmp]$ mysql zimbra -NBe 'select from_unixtime(last_backup_at), comment from mailbox' | sort | head | |||
2014-06-05 01:00:24 dluser558@zcs806.DOMAIN.com | |||
2014-06-05 01:00:26 dluser557@zcs806.DOMAIN.com | |||
2014-06-05 01:00:28 dluser556@zcs806.DOMAIN.com | |||
2014-06-05 01:00:30 dluser555@zcs806.DOMAIN.com | |||
2014-06-05 01:00:31 dluser554@zcs806.DOMAIN.com | |||
2014-06-05 01:00:32 dluser551@zcs806.DOMAIN.com | |||
2014-06-05 01:00:32 dluser552@zcs806.DOMAIN.com | |||
2014-06-05 01:00:32 dluser553@zcs806.DOMAIN.com | |||
2014-06-05 01:00:33 dluser550@zcs806.DOMAIN.com | |||
2014-06-05 01:00:34 dluser549@zcs806.DOMAIN.com | |||
</pre> | </pre> | ||
I include also below the results from the zmbackupquery for the first user: | |||
<pre> | |||
[zimbra@zcs806 tmp]$ date ; zmbackupquery -a dluser558@zcs806.DOMAIN.com | |||
Wed Jun 11 14:29:48 PDT 2014 | |||
Account: dluser558@zcs806.DOMAIN.com | |||
Label: full-20140605.080023.296 | |||
Type: full | |||
Started: Thu, 2014/06/05 01:00:23.296 PDT | |||
Ended: Thu, 2014/06/05 01:02:37.739 PDT | |||
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555 | |||
Label: full-20140529.080016.546 | |||
Type: full | |||
Started: Thu, 2014/05/29 01:00:16.546 PDT | |||
Ended: Thu, 2014/05/29 01:02:51.556 PDT | |||
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555 | |||
Label: full-20140522.080015.818 | |||
Type: full | |||
Started: Thu, 2014/05/22 01:00:15.818 PDT | |||
Ended: Thu, 2014/05/22 01:02:42.126 PDT | |||
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555 | |||
Label: full-20140515.080016.160 | |||
Type: full | |||
Started: Thu, 2014/05/15 01:00:16.160 PDT | |||
Ended: Thu, 2014/05/15 01:02:34.204 PDT | |||
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555 | |||
</pre> | |||
==== | =====Possible Issue That A Failed Or Interrupted Backup Causes===== | ||
An interrupted backup can cause an issue because the table currently gets updated right off the bat rather than waiting for backup to be successfully completed. | |||
Possible RFE: To update zimbra.mailbox.last_backup_at column for successfully backed-up mailboxes to the very end of the backup process, to either just before or just after renaming the /opt/zimbra/backup/tmp/<backup label> directory to /opt/zimbra/backup/sessions/<backup label>. | |||
=== | ======Setting To Null To Cause A New Backup For User====== | ||
To undo what was done by an interrupted backup for example, you need to clear this column (set it to null) for the affected mailboxes. By clearing the column, you're forcing the next AG backup to choose these mailboxes because they look like they have never been backed up. If you don't clear this column, you have to wait until the next cycle. (7 days) | |||
Example syntax to view: | |||
mysql zimbra -e "select last_backup_at from mailbox where id=27" | |||
Example syntax to change data of the last_backup_at to NULL" | |||
mysql zimbra -e "UPDATE mailbox SET last_backup_at = NULL WHERE id = 27" | |||
' | ======Related Bugs RFE's====== | ||
http:// | * "In auto-grouped backup, delay the update of mailboxes' last_backup_at timestamp to the very end of backup" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=33275 | |||
* "Partial backup should be able to finish successfully when backup volume runs out of space" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=33276 | |||
====Restore Requires accounts.xml File==== | |||
http:// | * "accounts.xml file dependency needed for zmrestore" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=30979 | |||
Also, see: | |||
http:// | * "accounts.xml file improperly updated when a full backup is deleted" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=31591 | |||
====Change "Location" For Backup Or Restore Source Data==== | |||
Remember that zmbackup and zmrestore can take flags as well in regards to the location of items. | |||
* zmrestore & zmbackup can both take : -t,--target (default <zimbra_home/backup) | |||
'''''You can't state a different location with redo logs though'''''. There's a command called '''zmplayredo''' [for newer versions of ZCS] and it has a variable to point to the redologs to play from [ --logfiles ]. It will replay into the default redolog directory or redolog file. The mailbox has to be stop to run zmplayredo . This is a command to manual kick off a replay of a redo log. This is normally done with the zmrestore when options about to a specific time aren't included. | |||
====Manual Removal Of Older Backup Sessions==== | |||
General Situation: | |||
*Keep in mind every restore requires starting with data from a full backup. | |||
*For each account on the server, there must be at least 1 full backup after the deletion is complete. | |||
*You should also make sure all incremental backups made after the oldest of the remaining backups are retained. | |||
**This basically gets reduced to deleting only those backups that are old enough, based on your full/incremental schedule. | |||
* | More Specific Issues: | ||
* | *Does the accounts.xml dependency cause issues with this? | ||
**No. Just don't delete it. | |||
* | *What about the contents of the backup/tmp/ data or shared blobs type references? | ||
**Don't touch this directory either. It is used during backup and restore. You don't want to change its content while an operation is going on, so best to leave it alone. | |||
** | *What if a zimbra server is running some type of restore of backup command while the manual removal is running on the nfs server? | ||
* | **You shouldn't remove the backups that are being used in a restore currently underway. You are responsible for avoiding the race condition. | ||
* | *** Please understand you are responsible for avoiding the race condition. Make sure no backup or restore is happening at the moment, then rename the directories that will be deleted, preferably move them to another subdirectory, e.g. /opt/zimbra/backup/sessions_to_delete. Then delete. | ||
** | ===LDAP Backup Related Items=== | ||
====Backup Schedule On LDAP Only Server [non-Mailstore]==== | |||
If you look at the code in /opt/zimbra/bin/zmschedulebackup : | |||
<pre> | <pre> | ||
if ($BACKUP_MODE eq 'Standard') { | |||
# default schedule: full backup 1am every sunday, incr backup 1am every weekday | |||
# deletes backups older than a month at 12am everyday | |||
if (isLdapOnly()) { | |||
@default = ("0 1 * * 6 /opt/zimbra/bin/zmbackup $target\n", | |||
"0 0 * * * /opt/zimbra/bin/zmbackup -del 1m\n"); | |||
} else { | |||
@default = ("0 1 * * 6 /opt/zimbra/bin/zmbackup -f $account $target $compress \n", | |||
"0 1 * * 0-5 /opt/zimbra/bin/zmbackup -i $compress\n", | |||
"0 0 * * * /opt/zimbra/bin/zmbackup -del 1m\n"); | |||
} | |||
%commandmap = ("f", "/opt/zimbra/bin/zmbackup -f $target $compress $account", | |||
"i", "/opt/zimbra/bin/zmbackup -i $compress", | |||
"d", "/opt/zimbra/bin/zmbackup -del"); | |||
} else { # Auto-Grouped mode | |||
# default schedule: full backup 1am everyday, no incr backup | |||
# deletes backups older than a month at 12am everyday | |||
@default = ("0 1 * * 0-6 /opt/zimbra/bin/zmbackup -f $target $compress\n", | |||
"0 0 * * * /opt/zimbra/bin/zmbackup -del 1m\n"); | |||
%commandmap = ("f", "/opt/zimbra/bin/zmbackup -f $target $compress", | |||
"i", "/opt/zimbra/bin/zmbackup -i $compress", | |||
"d", "/opt/zimbra/bin/zmbackup -del"); | |||
} | |||
</pre> | </pre> | ||
Notice the specific check and then format for ldapOnly: | |||
<pre> | <pre> | ||
if (isLdapOnly()) { | |||
@default = ("0 1 * * 6 /opt/zimbra/bin/zmbackup $target\n", | |||
"0 0 * * * /opt/zimbra/bin/zmbackup -del 1m\n"); | |||
</pre> | </pre> | ||
==== | ====Related Bugs To LDAP Backups==== | ||
Some bugs to be aware of - most are resolved/fixed: | |||
: | |||
= | * "Zmbackup ldap data is not backed up if target server is not hosting it." | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=7420 | |||
* "System LDAP is backuped only when -a all is specified" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=8365 | |||
* "LDAP backup directory format difference between full install and ldap only install" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=9551 | |||
* "backups in the admin console should back up LDAP data" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=14069 | |||
* "LDAP backup failure due to library version mismatch" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=20275 | |||
= | * "ldap backup not kept with rest of backup" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=21753 | |||
* "zmbackup ldap backup is not logged" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=22303 | |||
* "Backup default cronjob is wrong for ldap only install" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=23513 | |||
* "zmbackupldap fails to rename directory on NFS" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=25451 | |||
* "default ldap server only backup schedule is weekly" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=25681 | |||
* "zmbackupldap fails when using month intervals and succeeding month has more days" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=32834 | |||
* "zmbackup on LDAP-only hosts should have help/usage argument, or at least reject invalid arguments" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=32878 | |||
* "corp: ldap backups fail" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=38558 | |||
===A Way To Verify Backup Integrity=== | |||
I filed an RFE for this: | |||
* "A way to verify backup integrity" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=28025 | |||
====Negative Seek Offset Error & RFE==== | |||
Explanation of negative seek offset error during a restore attempt and manual fixes are located here: | |||
= | * "RFE: Monitor/test backup *.zip files for corruption & repair tools" | ||
** https://bugzilla.zimbra.com/show_bug.cgi?id=55148 | |||
===Auto-Group Backups Rather Than Default Method Topics=== | |||
====General Description And Official References==== | |||
Having trouble completing that entire full backup during off-hours? Enter the hybrid auto-grouped mode, which combines the concept of full and incremental backup functions - you’re completely backing up a target number of accounts daily rather than running incrementals. | |||
Auto-grouped mode automatically pulls in the redologs since the last run so you get incremental backups of the remaining accounts; although the incremental accounts captured via the redologs are not listed specifically in the backup account list. This still allows you to do a point in time restore for any account. | |||
'''Administrative manual page:''' | |||
http://www.zimbra.com/docs/ne/latest/administration_guide/10_Backup_Restore.17.01.html | |||
'''Compare the sections called "Standard Backup Method" & "Auto-Grouped Backup Method"''' | |||
http://www.zimbra.com/docs/ne/latest/administration_guide/10_Backup_Restore.17.02.html | |||
'''Configuration details are here on that page:''' | |||
http://www.zimbra.com/docs/ne/latest/administration_guide/10_Backup_Restore.17.08.html | |||
'''Good explanation:''' | |||
http://www.zimbrablog.com/blog/archives/2008/08/recent-admin-tidbits-part-1.html | |||
Simply divide your total accounts by the number of groups you choose (zimbraBackupAutoGroupedNumGroups is 7 by default) and that’s how many will get a full backup session each night. Newly provisioned accounts, and accounts whose last backup is a specified number of days older are picked first. (zimbraBackupAutoGroupedInterval is defaulted to 1d) | |||
Think of auto-grouped mode as a full backup for the scheduled group as well as an incremental (via redologs) for the all other accounts at the same time. | |||
====Bugs - RFE's To Review For Auto-Group==== | |||
Please see: | |||
=== | * "In auto-grouped backup, delay the update of mailboxes' last_backup_at timestamp to the very end of backup" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=33275 | |||
* "improve error reporting to ignore harmless missing sequences" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=34008 | |||
* "unbalanced auto-grouped backups" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=34028 | |||
====Enabling Auto-Group For Backups - Schedule In Crontab==== | |||
* | * You'll need to make the variable changes as listed in the administrative guide and then the following for set the crontab correctly. | ||
* Run zmschedulebackup --help to see a list of options. | |||
* | * Run zmschedulebackup -D , which will now set a new default schedule (crontab) that uses auto-group settings now that your variable are set for it. | ||
* | ** If you want the [[Ajcody-Notes-BackupPlans#Need_To_Write_Fewer_Files_-_Add_The_Zip_Option_To_Your_Backup_Commands|zip option]] to also be used do: | ||
*** <pre>zmschedulebackup -D -z</pre> | |||
*** See this bug about zmschedulebackup not being able to pass -zipStore option. | |||
**** http://bugzilla.zimbra.com/show_bug.cgi?id=30981 | |||
** | * Incremental backups aren't performed as they were. | ||
** You'll see there's no longer the -i option in cron. | |||
** Incrementals are performed, in a manner, but the redologs are just copied into the full backup session | |||
*** | |||
*** | |||
*** | |||
* | |||
* | |||
** | |||
** | |||
Two bugs to look at as well: | |||
* cannot backup using admin ui in autogrouped mode | |||
* | ** http://bugzilla.zimbra.com/show_bug.cgi?id=29421 | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id= | * Expose autogroup backup configuration to admin UI | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=28198 | |||
======Standard Mode Default Cron Setup====== | |||
* Here is a schedule without auto-grouped backups enabled: | |||
** The Default Schedule For Normal Backups [ zmschedulebackup --help ]: | |||
<pre> | |||
f 0 1 * * 6 | |||
i 0 1 * * 0-5 | |||
d 1m 0 0 * * * | |||
</pre> | |||
**To set the backup to standard mode and use the default schedule one would: | |||
***<pre>zmprov mcf zimbraBackupMode Standard</pre> | |||
***<pre>zmschedulebackup -D</pre> | |||
**The crontab would look like: | |||
<pre> | |||
0 1 * * 6 /opt/zimbra/bin/zmbackup -f -a all | |||
0 1 * * 0-5 /opt/zimbra/bin/zmbackup -i -a all | |||
0 0 * * * /opt/zimbra/bin/zmbackup -del 1m | |||
</pre> | |||
======Auto-Group Mode Cron Setup====== | |||
* Here is a schedule with auto-grouped enabled: | |||
** The Default Schedule For Auto-Group Backups [ zmschedulebackup --help ]: | |||
<pre> | |||
f 0 1 * * 0-6 | |||
d 1m 0 0 * * * | |||
</pre> | |||
**To set the backup to auto-group mode and use the default schedule one would: | |||
***<pre>zmprov mcf zimbraBackupMode Auto-Grouped</pre> | |||
***<pre>zmschedulebackup -D</pre> | |||
**The crontab would look like: | |||
<pre> | |||
0 1 * * 0-6 /opt/zimbra/bin/zmbackup -f | |||
0 0 * * * /opt/zimbra/bin/zmbackup -del 1m | |||
</pre> | |||
====Some Variables For Auto-Group==== | |||
The below might not be complete or the defaults, I just wanted to save this before I forget them. Try to get more complete details on these later. | |||
zmprov gacf | grep Backup | |||
:: | zimbraBackupAutoGroupedInterval: 1d | ||
zimbraBackupAutoGroupedNumGroups: 7 | |||
zimbraBackupAutoGroupedThrottled: FALSE | |||
zimbraBackupMode: Auto-Grouped | |||
====Auto-group And Redologs==== | |||
Please see [[Ajcody-Backup-Restore-Issues#Redologs_And_Auto-group_In_Regards_To_Backups]] | |||
====Problems Switching To Auto-Groups Because It Wants To Run A Full Against All Accounts==== | |||
Please see the following bug/rfe made about problems switching over to Auto-group when the first backup run of it tries to backup ALL of he accounts. I have the full how-to within the bug. It basically manipulates the last_backup_at for each account. | |||
* Ability to set last_backup_at to NULL or to the day before for All users, group of users, user | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=87834 | |||
===Backup And Deletion Schedule - zmschedulebackup=== | |||
====How To Adjust The Deletion Schedule==== | |||
For my example below, I first set the backup to the "default" schedule. And I then adjust that "default" to have backups delete with a 14 day interval rather than 1 month. | |||
<pre> | |||
[zimbra@mail3 ~]$ zmschedulebackup -D | |||
Default schedule set | |||
Current Schedule: | |||
f 0 1 * * 6 -a all | |||
i 0 1 * * 0-5 | |||
d 1m 0 0 * * * | |||
[zimbra@mail3 ~]$ zmschedulebackup -q | |||
Current Schedule: | |||
f 0 1 * * 6 -a all | |||
i 0 1 * * 0-5 | |||
d 1m 0 0 * * * | |||
[zimbra@mail3 ~]$ zmschedulebackup -R f "0 1 * * 6" i "0 1 * * 0-5" d 14d "0 0 * * *" | |||
Schedule replaced | |||
Current Schedule: | |||
f 0 1 * * 6 -a all | |||
i 0 1 * * 0-5 | |||
d 14d 0 0 * * * | |||
[zimbra@mail3 ~]$ zmschedulebackup -q | |||
Current Schedule: | |||
f 0 1 * * 6 -a all | |||
i 0 1 * * 0-5 | |||
d 14d 0 0 * * * | |||
[zimbra@mail3 ~]$ crontab -l | grep backup | |||
0 1 * * 6 /opt/zimbra/bin/zmbackup -f -a all | |||
0 1 * * 0-5 /opt/zimbra/bin/zmbackup -i | |||
0 0 * * * /opt/zimbra/bin/zmbackup -del 14d | |||
</pre> | |||
For | ===The Zip - Compression Option For Backups=== | ||
Using the zip option will compress all those thousands of single files that exist under a user's backup, decreasing performance issues that arise from writing out thousands of small files as compared to large ones. This is often seen when one is : | |||
* Using nfs for the backup directory | |||
* Copying/rsyncing backups to a remote server | |||
* Are using some third party backup software (to tape) to archive/backup the zimbra backup sessions. | |||
==== | ====Optional Tweaks To The Zip Options==== | ||
Please see this comment and those underneath it within this RFE: | |||
* "Use zip files for shared blobs of a full backup made with --zip option" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=26624#c6 | |||
*** Use zmlocalconfig. To set: | |||
**** $ zmlocalconfig -e key=val | |||
*** To unset: | |||
**** $ zmlocalconfig -u key | |||
*** Once you set the key you will be able to view it. | |||
**** $ zmlocalconfig | |||
*** backup_zip_copier_private_blob_zips | |||
**** How many zip files to distribute a mailbox's private (unshared) blobs over; default 4 (blobs-1.zip through blobs-4.zip); range 1 to 10,000 | |||
*** backup_zip_copier_copy_buffer_size | |||
**** File copy buffer size; default 16384 (16KB); range 4KB to 1MB | |||
*** backup_zip_copier_queue_capacity | |||
**** Each zip file gets a queue of files to add. This key sets the queue size. Default is 10. Range is 1 to 10,000. | |||
*** backup_zip_copier_deflate_level | |||
**** Compression level. Default is -1. (same as in java.util.zip.ZipOutputStream). -1 is same as level 6. This behavior comes from zlib library which the JVM uses to implement zip. Other than the special default value, the level can range from 0 to 9. 0 means no compression. 1 means fastest compression and 9 means best compression. | |||
*** backup_disable_shared_blobs | |||
**** This one isn't limited to zip backups. When this is set to true, all blobs are backed up as private backups. Default is false. | |||
*** backup_debug_use_old_zip_format | |||
**** If true, backup will behave like ZCS 5.0.4 and earlier. Shared blobs are never zipped, and private blobs are added to a single blobs.zip file in zip backup. Default is false. | |||
==== | ====Need To Write Fewer Files - Add The Zip Option To Your Backup Commands==== | ||
http:// | RFE to make zip option the default for backups: | ||
* "backup: default to the zip option" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=31836 | |||
There is very little details in the official documentation on this option unfortunately. This does have a really good explanation though: | |||
http://www.zimbrablog.com/blog/archives/2008/08/recent-admin-tidbits-part-1.html | |||
From the administrative manual on the Backup section: | |||
http://www.zimbra.com/docs/ne/latest/administration_guide/10_Backup_Restore.15.1.html | |||
It says, | |||
:: "-zip can be added to the command line to zip the message files during backup. Zipping these can save backup storage space." | |||
It's implied that instead of having all the individual message files in the backup that it will bunch them all together into zip files. '''The body of a shared blob is added once to a shared-blobs zip file, then a small pointer-only entry is added to a mailbox's zip file. Same effect as in non-zipped case.''' This will be useful when the number of message files is causing disk i/o issues. Maybe your trying to rsync the backup session directories off to another server or your running a third party backup on it to save to tape. The default use of -zip will use compression, if this also causes overhead that you need to avoid you can use the -zipStore option. | |||
( | Note about -zipStore: | ||
:: "when used with the -zip option, it allows the backup to write fewer files (-zip), but not incur the compression overhead as well" | |||
'''The zip options effect backups that are in blob formats (full's). Incremental backups are bascially redologs, not the full message store of the user. In summary, the zip option will not impact the increment type backups. Auto-group backups are a mixture of both fulls and incrementals.''' | |||
=====How To Use As A Default Option?===== | |||
You'll add the options to the zimbra crontab file. This can be done with the zmschedulebackup command. | |||
Run zmschedulebackup with help option: | |||
zmschedulebackup --help | |||
You'll see: | |||
-z: compress - compress email blobs with zip | |||
It appears that you'll need to manually add the options about -zipStore , if you want it, to the crontab file. | |||
See bug : | |||
= | http://bugzilla.zimbra.com/show_bug.cgi?id=30981 | ||
===== | =====What Does It Look Like When I Use Zip?===== | ||
Shared blobs are zipped and blobs (messages) are zipped per root store directory. | |||
mail:~/backup/sessions/full-20080820.160003.770/accounts/115/988/11598896-a89b-4b9d-bedb-1ed1afcb6c87/blobs | |||
zimbra$ ls blobs-1.zip blobs-2.zip blobs-3.zip blobs-4.zip | |||
===General Backup & Restore Debugging=== | |||
'''You'll be monitoring the /opt/zimbra/log/mailbox.log file''' | |||
Include the -d / --debug option on the CLI for either zmrestore or zmbackup . | |||
To increasing logging for backup/restore-related logs - /opt/zimbra/log/mailbox.log . Enable DEBUG log level for "zimbra.backup" logger in : | |||
* /opt/zimbra/conf/log4j.properties for "temporary" change - until next restart. This could take a couple of minutes before jetty "sees" the changes. | |||
* /opt/zimbra/conf/log4.properties.in for "permament" change that will stick after restart. A restart of jetty/mailbox would be required for this change - zmmailboxctl restart . | |||
log4j.logger.zimbra.backup=DEBUG | |||
For incremental backups, this should log each redolog being copied to the backup and also log which ones will be deleted out of archive directory. Those not deleted are kept because they are newer than 1 hour (default). The kept logs are deleted (but not copied again) during the next incremental backup. | |||
===Redolog Files=== | |||
---- | |||
====Redologs Copied To Backup Session And When Deleted==== | |||
Archived logs that are less than an hour old at the time of incremental backup are copied to the backup but aren't deleted to support post-crash waitset reinitialization mechanism. The interval is set in localconfig key backup_archived_redolog_keep_time, which is in seconds, default=3600. | |||
=====An Outline Of The Step===== | |||
# /opt/zimbra/redolog/redo.log (starts and then grows to zimbraRedoLogRolloverFileSizeKB size - default 100MB) | |||
# This flushes to /opt/zimbra/redolog/archive/[file] upon hitting the zimbraRedoLogRolloverFileSizeKB. | |||
# 1 & 2 keep repeating when zimbraRedoLogRolloverFileSizeKB is hit. | |||
# When a backup is done, the archive/* files are copied. The redo.log file is not moved. | |||
## When the backup processes archive/* logs, it first figures out the last sequence copied to backup. All newer logs are copied to the current backup. Then, all logs are deleted except those that are too new, determined by localconfig parameter backup_archived_redolog_keep_time, which defaults to 1 hour. (This is part of the waitset feature.) | |||
##* In standard backup mode, only incremental backups move the redologs. | |||
##* In auto-grouped mode, every backup is a hybrid of full and incremental and thus redologs are moved. | |||
==== | =====Redologs And Auto-group In Regards To Backups===== | ||
http://www.zimbra.com/forums/administrators/21360-auto-grouped-backups.html | |||
<blockquote>Think of auto-grouped mode as a full backup for the scheduled group as well as an incremental (via redologs) for the all other accounts at the same time. Auto-grouped mode automatically pulls in the redologs since the last run, so you get incremental backups of the remaining accounts. Although the incremental accounts captured via the redologs are not listed specifically in the backup account list. This still allows you to do a point in time restore for any account.</blockquote> | |||
=====If You Have Older Redologs Not Being Deleted===== | |||
According to the code, only archived logs newer than 1 hour old (default for backup_archived_redolog_keep_time) should remain after an incremental backup. It is a bug if you are seeing older logs sticking around. If so, look at mailbox.log and see if any error was logged. If you enable DEBUG logging for "zimbra.backup" logger in log4j.properties you will see log statements for each copy and deletion. | |||
=====The zimbraRedoLogDeleteOnRollover variable===== | |||
zimbraRedoLogDeleteOnRollover shouldn't have an effect on "If you have older redologs not being deleted". By default it's FALSE and affects whether or not stuff makes it into /opt/zimbra/redolog/archive at all. With it set to TRUE there's just /opt/zimbra/redolog/redo.log and it's deleted/not rolled over into archive. As discussed above old redologs are deleted after the incremental; thus if you don't take incremental backups you should set this value to TRUE or periodically script manual deletion of /opt/zimbra/redolog/archive. (And with zimbraRedoLogEnabled FALSE there's no redo.log at all.) | |||
======If You Don't Run Incremental Backups Or Don't Need Archive Redologs====== | |||
You would set zimbraRedoLogDeleteOnRollover to TRUE. | |||
(Auto-Grouped backups you can still leave this to the default of FALSE.) | |||
==== | ====Redolog Sequence And The Backup Session==== | ||
Redologs will exist in the incremental backup sessions. The zmbackupquery command will reference the redologs associated with the backup. For example" | |||
<pre> | <pre> | ||
$ | [zimbra@mail3 ~]$ ls /opt/zimbra/backup/sessions/incr-20080925.224528.230/redologs/ | ||
redo-20080925.213136.165-seq53.log redo-20080925.220726.521-seq55.log redo-20080925.224209.287-seq57.log | |||
redo-20080925.215516.450-seq54.log redo-20080925.221749.133-seq56.log | |||
[zimbra@mail3 ~]$ zmbackupquery -lb incr-20080925.224528.230 | |||
Label: incr-20080925.224528.230 | |||
Type: incremental | |||
Status: completed | |||
Started: Thu, 2008/09/25 18:45:28.230 EDT | |||
Ended: Thu, 2008/09/25 18:45:39.099 EDT | |||
Redo log sequence range: 53 .. 57 | |||
Number of accounts: 2 | |||
</pre> | </pre> | ||
In the above example, we see the sequence range of "53 .. 57" is referring to the files in the backup session directory called redologs. | |||
==== | ====RedoLog Variables==== | ||
=====Changing Redolog File Size And Location===== | |||
The /opt/zimbra/redolog/redo.log rolls over when it reaches zimbraRedoLogRolloverFileSizeKB (by default 100mb). | |||
The "roll overs" then goto /opt/zimbra/redolog/archive/ | |||
zmprov gacf | grep Redo | |||
zimbraRedoLogArchiveDir: redolog/archive | |||
zimbraRedoLogDeleteOnRollover: FALSE | |||
zimbraRedoLogEnabled: TRUE | |||
zimbraRedoLogFsyncIntervalMS: 10 | |||
zimbraRedoLogLogPath: redolog/redo.log | |||
zimbraRedoLogRolloverFileSizeKB: 102400 | |||
======Need To Move Redologs Because Partition Getting Full====== | |||
You'll | Let's say you have a partition getting full and you need to move the redolog to another partition or nfs mount temporary to deal with the potential crisis that will happen when the partition becomes full. '''You'll need to reallocate the complete redolog/ directory and the archive subdirectory to the same partition''' because the roll over from redo.log to the archive directory happens with a rename function within the java code. '''This will require downtime''' since you'll need to move the actual redo.log file and zimbra can't be running while you do this. You can use a symlink to your new partition path. For example: | ||
su - zimbra | |||
zmcontrol stop | |||
su - | |||
** as root | |||
mkdir /data/redolog | |||
chown zimbra:zimbra /data/redolog | |||
mount /dev/sdb1 /data/redolog | |||
mv /opt/zimbra/redolog/* /data/redolog/ | |||
** or use rsync | |||
rmdir /opt/zimbra/redolog | |||
ln -s /opt/zimbra/redolog /data/redolog | |||
ls -laR /data/redolog | |||
** confirm ownership is with zimbra and double check zimbra can write in this directory | |||
su - zimbra | |||
touch /data/redolog/testfile | |||
rm /data/redolog/testfile | |||
zmcontrol start | |||
=====Automatic Deleting Of Redo Logs On Rollover===== | |||
This variable (zimbraRedoLogDeleteOnRollover) is set TRUE or FALSE. | |||
zmprov gacf | grep zimbraRedoLogDeleteOnRollover | |||
To modify it | |||
zmprov mcf zimbraRedoLogDeleteOnRollover TRUE | |||
==== | ====Want To See What's In Redolog Files==== | ||
'''This is for older versions of ZCS - newer versions should use zmredodump if it's available.''' | |||
If you suspect there's too much redolog activity during a time window or have another need to inspect the contents of the redolog, dump it and examine it: | |||
$ zmjava com.zimbra.cs.redolog.util.RedoLogVerify /opt/zimbra/redolog/redo.log > out.file | |||
Pick the right redolog file, either redo.log or one of the files under archive/, based on timestamp. | |||
====zmplayredo And zmredodump==== | |||
==== | =====zmplayredo - Replaying Content From Any Redolog File===== | ||
zmplayredo is a newer command, first introduced in 5.0.5 I believe. The mailbox has to be stop to run zmplayredo. | |||
The help output from 6.0.8: | |||
<pre> | <pre> | ||
$ zmplayredo --help | |||
usage: zmplayredo <options> | |||
- | --fromSeq <arg> Replay from this redolog sequence (inclusive) | ||
--fromTime <arg> Replay from this time (inclusive) | |||
-h,--help Show help (this output) | |||
--logfiles <arg> Replay these logfiles, in order | |||
--mailboxId <arg> Replay for this mailbox only | |||
--queueCapacity <arg> Queue capacity per player thread; default=100 | |||
--stopOnError Stop replay on any error | |||
--threads <arg> Number of parallel redo threads; default=50 | |||
--toSeq <arg> Replay to this redolog sequence (inclusive) | |||
--toTime <arg> Replay to this time (inclusive) | |||
Specify date/time in one of these formats: | |||
2010/11/19 13:55:08 | |||
2010/11/19 13:55:08 802 | |||
2010/11/19 13:55:08.802 | |||
2010/11/19-13:55:08-802 | |||
2010/11/19-13:55:08 | |||
20101119.135508.802 | |||
20101119.135508 | |||
20101119135508802 | |||
20101119135508 | |||
Specify year, month, date, hour, minute, second, and optionally millisecond. | |||
Month/date/hour/minute/second are 0-padded to 2 digits, millisecond to 3 digits. | |||
Hour must be specified in 24-hour format, and time is in local time zone. | |||
</pre> | </pre> | ||
=====zmredodump - Replaying Content From Any Redolog File===== | |||
zmredodump is a newer command and very useful. It does not require mailboxd to be stopped like zmplayredo does. | |||
The help output from 6.0.8: | |||
<pre> | <pre> | ||
$ zmredodump --help | |||
[ | usage: zmredodump [options] <redolog file/directory> [...] | ||
where [options] are: | |||
-h,--help show this output | |||
--m <arg> one or more mailbox ids separated by comma or white | |||
< | space. The entire list must be quoted if using space as separator. If | ||
this option is given, only redo ops for the specified mailboxes are | |||
dumped. Omit this option to dump redo ops for all mailboxes. | |||
--no-offset don't show file offsets and size for each redo op | |||
-q,--quiet quiet mode. Only print the log filename and any errors. | |||
This option can be used to verify the integrity of redologs with minimal | |||
output. | |||
--show-blob show blob content. Item's blob is printed, surrounded | |||
by <START OF BLOB> and <END OF BLOB> markers. The last newline before end | |||
marker is not part of the blob. | |||
Multiple log files/directories can be specified. For each directory, all | |||
redolog files directly under it are processed, sorted in ascending redolog | |||
sequence order. | |||
</pre> | </pre> | ||
=====Using zmredodump To Get Message Blobs To Inject With zmlmtpinject - RFE===== | |||
Please see: | |||
* "RFE: zmredodump blobs to single files for zmlmtpinject [for example]" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=52930 | |||
* See also: | |||
** "RFE: zmplayredo option for --frommailboxId --tomailboxId" | |||
*** http://bugzilla.zimbra.com/show_bug.cgi?id=52642 | |||
==== | =====Expand Ability To Parse Redologs - RFE===== | ||
Please see: | |||
* "expand ability to parse redologs for recovery purposes - zmredodump / zmplayredo" | |||
: | ** http://bugzilla.zimbra.com/show_bug.cgi?id=37743 | ||
====Getting A Sequence or Time Variable For Restore Or Replay==== | |||
You can see the changes within the redo logs with the command below. You can point it to any redolog. | |||
<pre>zmjava com.zimbra.cs.redolog.util.RedoLogVerify /opt/zimbra/redolog/redo.log > out.file</pre> | |||
You'll get output like this: | |||
<pre> | |||
VERIFYING: redo.log | |||
HEADER | |||
------ | |||
sequence: 59 | |||
open: 1 | |||
filesize: 512 | |||
serverId: d5c5d6a7-b82f-4c29-b0cd-91818057196b | |||
firstOpTstamp: 1222385426273 | |||
lastOpTstamp: 1222385426273 | |||
version: 1.22 | |||
------ | |||
txn 1222383600.1 [PurgeOldMessages] ver=1.22, tstamp=1222385426273, change=20200, mailbox=1 | |||
txn 1222383600.1 [CommitTxn] ver=1.22, tstamp=1222385426329, mailbox=1, txnType=PurgeOldMessages | |||
txn 1222383600.2 [PurgeOldMessages] ver=1.22, tstamp=1222385486337, change=13500, mailbox=3 | |||
txn 1222383600.2 [CommitTxn] ver=1.22, tstamp=1222385486351, mailbox=3, txnType=PurgeOldMessages | |||
txn 1222383600.3 [PurgeOldMessages] ver=1.22, tstamp=1222385546357, change=20201, mailbox=1 | |||
txn 1222383600.3 [CommitTxn] ver=1.22, tstamp=1222385546383, mailbox=1, txnType=PurgeOldMessages | |||
txn 1222383600.4 [PurgeOldMessages] ver=1.22, tstamp=1222385606391, change=13501, mailbox=3 | |||
txn 1222383600.4 [CommitTxn] ver=1.22, tstamp=1222385606404, mailbox=3, txnType=PurgeOldMessages | |||
txn 1222383600.5 [PurgeOldMessages] ver=1.22, tstamp=1222385666416, change=20202, mailbox=1 | |||
txn 1222383600.5 [CommitTxn] ver=1.22, tstamp=1222385666428, mailbox=1, txnType=PurgeOldMessages | |||
txn 1222383600.6 [PurgeOldMessages] ver=1.22, tstamp=1222385726435, change=13502, mailbox=3 | |||
txn 1222383600.6 [CommitTxn] ver=1.22, tstamp=1222385726459, mailbox=3, txnType=PurgeOldMessages | |||
txn 1222383600.7 [PurgeOldMessages] ver=1.22, tstamp=1222385786476, change=20203, mailbox=1 | |||
txn 1222383600.7 [CommitTxn] ver=1.22, tstamp=1222385786486, mailbox=1, txnType=PurgeOldMessages | |||
txn 1222383600.8 [PurgeOldMessages] ver=1.22, tstamp=1222385846493, change=13503, mailbox=3 | |||
txn 1222383600.8 [CommitTxn] ver=1.22, tstamp=1222385846506, mailbox=3, txnType=PurgeOldMessages | |||
txn 1222383600.9 [PurgeOldMessages] ver=1.22, tstamp=1222385906739, change=20204, mailbox=1 | |||
txn 1222383600.9 [CommitTxn] ver=1.22, tstamp=1222385906775, mailbox=1, txnType=PurgeOldMessages | |||
txn 1222383600.10 [PurgeOldMessages] ver=1.22, tstamp=1222385966944, change=13504, mailbox=3 | |||
txn 1222383600.10 [CommitTxn] ver=1.22, tstamp=1222385966963, mailbox=3, txnType=PurgeOldMessages | |||
txn 1222383600.11 [PurgeOldMessages] ver=1.22, tstamp=1222386026972, change=20205, mailbox=1 | |||
txn 1222383600.11 [CommitTxn] ver=1.22, tstamp=1222386026990, mailbox=1, txnType=PurgeOldMessages | |||
... | |||
</pre> | |||
====How Do I Figure Out Which Sequence or Time Variable To Use For Restore Or Replay==== | |||
:'''''In 5.0.10+ we'll have a CLI wrapper (zmredodump) with a slightly different command line syntax, but the below long syntax works in earlier versions.''''' | |||
To locate the correct restore-to time, you have to start with an approximate time the message was added/deleted. Look at the redolog files. The filename contains the GMT time when the file was rolled over, which is roughly the tstamp of the last operation in the file. If your time data is accurate you can find the specific file. Or you have a range of files to examine. | |||
Use the redolog verify tool to dump the contents into text form, the -m / --message option to show message body data: | |||
<pre>zmjava com.zimbra.cs.redolog.util.RedoLogVerify -m <filename or directory> ... > out.file</pre> | |||
If the message was deleted and you don't know the id, you must go by some other clue such as the subject. Search the file to locate your message. You can cut/paste the message and lmtp-inject it to recover the message. No need to go through with a restore if this is all you needed. | |||
====Are You Messages Really Gone - Things To Check If zmplayredo Isn't Doing What You Expect==== | |||
Here's something I found out testing zmplayredo for a customer case. Testing on a ZCS 6.0.8 single ZCS server. | |||
Created a test account and sent it one message that is in the Inbox. I delete the msg in zwc but don't purge the Trash - msg is in Trash now. | |||
Log events of above action: | |||
<pre> | <pre> | ||
2010-10-27 15:07:13,375 INFO [btpool0-3://192.168.0.71/service/soap/ConvActionRequest] | |||
[name=ajcody@mail71.DOMAIN.com;mid=17;ip=192.168.0.17;ua=ZimbraWebClient | |||
- FF3.0 (Linux)/6.0.8_GA_2661;] mailop - Moving VirtualConversation (id=-257) to | |||
Folder Trash (id=3). Affected message ids: 257. | |||
</pre> | |||
Stop mailboxd so I can use zmplayredo and then start mailboxd back up after zmplayredo is finished : | |||
<pre> | |||
zmmailboxdctl stop | |||
zmplayredo --mailboxId 17 --logfiles /opt/zimbra/redolog/archive/* --fromTime 20101027090000 --toTime 20101027140000 | |||
zmmailboxdctl start | |||
</pre> | </pre> | ||
Log event for above: | |||
<pre> | |||
2010-10-27 15:07:50,383 INFO [main] [] mailop - Adding Message: id=257, Message-ID= | |||
<1604937630.920784.1288201208382.JavaMail.root@corp.zimbra.com>, parentId=-1, folderId=2, folderName=Inbox. | |||
2010-10-27 15:07:50,404 INFO [main] [] RedoableOp - Message 257 is already in mailbox 17 | |||
</pre> | |||
Log into ZWC with the test account. The msg is not in the Inbox, but it's still in Trash folder. I purge it from Trash. | |||
Log event for deletion. | |||
<pre> | |||
2010-10-27 15:09:38,761 INFO [btpool0-2://192.168.0.71/service/soap/ConvActionRequest] | |||
[name=ajcody@mail71.DOMAIN.com;mid=17;ip=192.168.0.17;ua=ZimbraWebClient | |||
- FF3.0 (Linux)/6.0.8_GA_2661;] mailop - Deleting Message (id=257). | |||
</pre> | |||
Then I redo the stop/start of mailboxd and zmplayredo again. | |||
<pre> | |||
zmmailboxdctl stop | |||
zmplayredo --mailboxId 17 --logfiles /opt/zimbra/redolog/archive/* --fromTime 20101027090000 --toTime 20101027140000 | |||
zmmailboxdctl start | |||
</pre> | |||
Log event for the above: | |||
<pre> | |||
2010-10-27 15:10:29,192 INFO [main] [] mailop - Adding Message: id=257, Message-ID= | |||
<1604937630.920784.1288201208382.JavaMail.root@corp.zimbra.com>, parentId=-1, | |||
folderId=2, folderName=Inbox. | |||
</pre> | |||
Log back into ZWC with test account and now I can confirm that the msg is not in Trash and it is now showing in Inbox. | |||
====Gap In Redo Log==== | |||
The error message from either a backup or restore command: | |||
If | :::'''''"Error occurred: Found gap in redo log sequence; missing 5965 through 6149;''''' | ||
:::'''''To avoid future restore problems, discard all existing backups and take a''''' | |||
:::'''''full backup of all accounts; If this error occurred during restore,''''' | |||
:::'''''try the --ignoreRedoErrors option"''''' | |||
The output is pretty accurate in how to handle the situation. | |||
You'll | If you get the error during a backup, the recommendation is to move your old backups out. The directories in /opt/zimbra/backup/sessions/* . You'll want to keep them around just in case and then proceed to do a full backup. | ||
If you get the error during a restore, you would add the flag --ignoreRedoErrors to your restore command. | |||
Another possible related issue is if your /tmp or /opt/zimbra/redolog/ is filling up. | |||
====Error Executing redoOp==== | |||
Errors with restores that involve the message 'error executing redoOp' will not show up in the admin console but will when you attempt the restore from CLI. This can also be the cause when you use the RestoreToTime option from the admin console and it doesn't seem to work correctly - the restore stopping prematurely from the specified date/time. | |||
I created the following RFE in regards to the admin console issue: | |||
= | * "Include --ignoreRedoErrors option and error feedback in Admin Console for restore" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=52358 | |||
*** This could explain why your restore to time isn't working in the Admin Console but does from CLI when you see an error about redologs and then reattempt restore with the --ignoreRedoErrors and it works. | |||
Another RFE that was made but marked as 'WONTFIX' that gives a background story to the issue is: | |||
= | * "Need more robust redolog serialization format" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=7080 | |||
When you hit this error with your backup data during restore attempts, there's basically only a couple of options to handle this that are recommended by support: | |||
# Try to get full backups of your accounts or the accounts in question and then test against them and the preceding incrementals after the full. | |||
# Attempt restores via the CLI using the additional option of : --ignoreRedoErrors | |||
#* Similar to the various steps described here - [[Ajcody-Backup-Restore-Issues#Restore_To_Time_Problems]] - but with the --ignoreRedoErrors option included. | |||
# Do your restore against the latest full backup of the account in question and then use the zmplayredo command against the redologs in the incrementals and/or the /opt/zimbra/redologs/* directory . This will give you more control to walk the restored account up to the point in time you want it at. One should really read through the whole section above, [[Ajcody-Backup-Restore-Issues#Redolog_Files]] , to understand the whole concept of redologs and then the use of zmplayredo. | |||
Generally, "fixing" the redolog itself is not an option. | |||
===Why Do My Fulls Not Report All Accounts?=== | |||
Are you sure it was a full backup that was ran or just a full session that was generated from your incremental backup job? When an incremental is ran, it will create a "full" session for any new accounts it discovers after the last actual full backup job. | |||
For example, here's a full session that was created by an incremental backup job: | |||
<pre> | <pre> | ||
Label: full-20081010.060126.559 | |||
Type: full | |||
Status: completed | |||
Started: Fri, 2008/10/10 01:01:26.559 CDT | |||
Ended: Fri, 2008/10/10 01:01:28.988 CDT | |||
Redo log sequence range: 705 .. 705 | |||
Number of accounts: 1 | |||
Label: incr-20081010.060009.420 | |||
Type: incremental | |||
Status: completed | |||
Started: Fri, 2008/10/10 01:00:09.420 CDT | |||
Ended: Fri, 2008/10/10 01:01:26.413 CDT | |||
Redo log sequence range: 700 .. 704 | |||
Number of accounts: 392 | |||
[zimbra@servername ~]$ du -sh /opt/zimbra/backup/sessions/full-20081010.060126.559 | |||
1.2M /opt/zimbra/backup/sessions/full-20081010.060126.559 | |||
[zimbra@servername ~]$ du -sh /opt/zimbra/backup/sessions/incr-20081003.060010.622 | |||
452M /opt/zimbra/backup/sessions/incr-20081003.060010.622 | |||
</pre> | </pre> | ||
Notice the Start and End times, this will show that the full is related to the incremental job. | |||
You'll want to run zmbackupquery against your full labels to see your "main" full backup session - assuming you can't simply guess based upon the cron entry for it [ su - zimbra ; crontab -l | grep backup ]. For example, to see all your fulls from today's date back to October 01, 2008 and the accounts within each session - you would do: | |||
zmbackupquery -v --from 20081001.000000 --type full | |||
The | The -v flag outputs the accounts, the --from uses YearMonthDay.HourMinuteSecond , and the --type can be full or incremental. To just see one particular sessions date, you would use the lb [label] flag: | ||
zmbackupquery -v -lb [your full label, ex. full-20081001.000000] | |||
===Issues After /opt/zimbra/backup Became Full=== | |||
Bugs/RFE's on this issue: | |||
* "backup should give better error when disk is full" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=16482 | |||
* Was marked dup'd of above, "Issues when backup partition becomes full" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=32017 | |||
See also[[Ajcody-Backup-Restore-Issues#Possible_Issue_That_A_Failed_Or_Interrupted_Backup_Causes]] and the Bugs & RFE's under that section. | |||
You can run into numerous issues if you allow your backup directory to become full. | |||
Confirm your /opt/zimbra/backup/accounts.xml is being updated after a backup. You might see that the newer account.xml* file is accounts.xml.new . This is a sign of problems. | |||
Confirm that the files in /opt/zimbra/backup/tmp/* don't have 0 byte lengths. There might be files like 1.xml and 3.xml in there. If they show 0 bytes, you need to remove them. The backup/restore commands if the file exist and they are empty. Your errors might look like this: | |||
[zimbra@mailb ~]$ zmrestore -a USER@DOMAIN -ca -pre restore_ | |||
Error occurred: system failure: Unable to parse XML file /opt/zimbra/backup/tmp/restore/shared_blobs/1.xml | |||
'' | If you tried doing restores (redirected -ca -pre) before to clear up the above issues, you might find you can't do a successful restore AND you can't delete the account afterwards. | ||
If you get errors like : | |||
zmprov da restore3_tester3@XXXXXX.edu | |||
ERROR: service.FAILURE (system failure: writing new mailbox row for account 89e7d9f4-013e-4cf1-a352-7b2f0a00d5af) | |||
zmprov gmi restored_USER | |||
ERROR: service.FAILURE (system failure: writing new mailbox row for account 56a7f654-f85b-45cc-931a-81d9bb9076bf) | |||
' | You'll need to delete the account via a ldapdelete command. | ||
===Query And Stopping A Backup or Restore In Progress=== | |||
Please see the url below for Backup In Progress - topic name "Aborting Full Backup In Progress": | |||
* A matter of using zmbackupquery & zmbackupabort . | |||
Please see url below for Restore In Progress - topic name "Stopping a Restore Process" : | |||
* A matter of using : ''zmbackupabort -r'' | |||
** Latest ZCS Admin Guide Table of Contents, search for the topic name mentioned above. | |||
*** http://www.zimbra.com/docs/ne/latest/administration_guide/toc.html | |||
** ZCS 4.5.10 Admin Guide with static links to back section, you should review info in latest admin guide though. | |||
*** http://www.zimbra.com/docs/ne/4.5.10/administration_guide/10_Backup_Restore.13.1.html#1042283 | |||
** '''Note''' - what is absent is an easy way to query restores in progress though. Please see: | |||
*** "Status for Zmrestore" | |||
**** http://bugzilla.zimbra.com/show_bug.cgi?id=47238 | |||
**** Currently, status of a restore can only be monitored via the logging events in the mailbox.log file. | |||
====A -del Delete In Progress==== | |||
Please see the bug / rfe's I filed | |||
* "need way to kill/recover from zmbackup -del when in progress" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=31869 | |||
* "zmbackup -del shouldn't prevent zmbackup -f/-i from running for ALL cases" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=33294 | |||
==== | ====zmbackupabort syntax==== | ||
From ZCS 6.0.8 | |||
<pre> | |||
$ zmbackupabort -h | |||
usage: zmbackupabort <options> | |||
-d,--debug Display diagnostics for debugging purposes. | |||
-h,--help Displays this help message. | |||
-lb,--label <arg> Label of full backup set to abort. | |||
-r,--restore Abort the restore in progress. | |||
-s,--server <arg> Mail server hostname. Default is localhost. | |||
-t,--target <arg> Backup target location (default | |||
<zimbra_home>/backup). | |||
</pre> | |||
====zmbackupquery syntax==== | |||
From ZCS 6.0.8 | |||
<pre> | |||
$ zmbackupquery -h | |||
usage: zmbackupquery <options> | |||
-a,--account <arg> Account email addresses seperated by white space or | |||
"all" for all accounts. | |||
-d,--debug Display diagnostics for debugging purposes. | |||
--from <arg> List backups whose start date/time is at or after | |||
this date/time. | |||
-h,--help Displays this help message. | |||
-lb,--label <arg> The label of full backup to query. | |||
-s,--server <arg> Mail server hostname. Default is localhost. | |||
-t,--target <arg> Backup target location (default | |||
<zimbra_home>/backup). | |||
--to <arg> List backups whose start date/time is at or before | |||
this date/time. | |||
--type <arg> Backup set type to query. "full" or "incremental"; | |||
both if unspecified. | |||
-v,--verbose Show account list in each backup. | |||
Specify date/time in one of these formats: | |||
2010/11/19 14:06:22 | |||
2010/11/19 14:06:22 923 | |||
2010/11/19 14:06:22.923 | |||
2010/11/19-14:06:22-923 | |||
2010/11/19-14:06:22 | |||
20101119.140622.923 | |||
20101119.140622 | |||
20101119140622923 | |||
20101119140622 | |||
The | Specify year, month, date, hour, minute, second, and optionally millisecond. | ||
Month/date/hour/minute/second are 0-padded to 2 digits, millisecond to 3 digits. | |||
Hour must be specified in 24-hour format, and time is in local time zone. | |||
</pre> | |||
===Restore To Time Problems=== | |||
There's seems to be some syntax issues when using this variable. Please review the following to confirm your syntax. | |||
http://wiki.zimbra.com/index.php?title=CLI_zmrestore_restoreToTime_Network_Edition_only | |||
The gist, you '''MUST''' use the -lb full-200xxxxxx option when your trying to restore anything that ISN'T meant to include the latest information for the mailbox. '''''The -lb argument should specify a full backup that took place prior to the time of the backup you wish to restore.''''' | |||
====Find Out What Backup Session Labels You Need First==== | |||
To find out what backups are associated with a particular account, you would do the following : | |||
zmbackupquery -a user@domain | |||
You'll want to note what is the first full that occurs before the point in time you want to restore. And then the incremental that follows right after your point in time. | |||
Backup label (-lb) for fulls can be found by doing [include the -v option if you want to see a listing of the user accounts within the backups] : | |||
zmbackupquery --type full | |||
Backup labels (-restoreToIncrLabel) for incrementals can be found by: | |||
zmbackupquery --type incremental | |||
====Command Syntax Example For Restores On The CLI==== | |||
Example to full label and stop : | |||
zmrestore -a USER@DOMAIN.com -lb full-20080726.050017.306 -rf -ca -pre restore_ | |||
Example to incremental label and stop : | |||
zmrestore -a USER@DOMAIN.com -restoreToIncrLabel incr-20080731.060007.644 -lb full-20080726.050017.306 -br -ca -pre restore_ | |||
Example to specific time and stop : | |||
zmrestore -a USER@DOMAIN.com -restoreToTime 20080801011800 -lb full-20080726.050017.306 -br -ca -pre restore_ | |||
'''Important Options You Might Want Or Need To Include''' | |||
'''--ignoreRedoErrors''' : If you attempt a restore and you see an error about problems related to playing the redolog, you'll want to run the restore command again and include this option. | |||
= | '''--skipDeletes''' : Please see http://bugzilla.zimbra.com/show_bug.cgi?id=31824#c5 for details on this. | ||
'''-t /path/to/backup_dir''' : If you are restoring from another backup directory besides your current default path. | |||
Variables that are asking for TIME rather than LABELS should follow this syntax (from zmrestore --help): | |||
<pre> | |||
Specify date/time in one of these formats: | |||
2008/08/06 09:55:50 | |||
2008/08/06 09:55:50 572 | |||
2008/08/06 09:55:50.572 | |||
2008/08/06-09:55:50-572 | |||
2008/08/06-09:55:50 | |||
20080806.095550.572 | |||
20080806.095550 | |||
20080806095550572 | |||
20080806095550 | |||
Specify year, month, date, hour, minute, second, and optionally millisecond. | |||
Month/date/hour/minute/second are 0-padded to 2 digits, millisecond to 3 digits. | |||
Hour must be specified in 24-hour format, and time is in local time zone. | |||
</pre> | |||
====Bugs And RFE's To Review==== | |||
'''Update - Bug/RFE's I Filed Against ZCS 8.6''' | |||
* [story] Ability to search data within backup and do "item" restores or identify locations of search results | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97551 | |||
* admin console backup label view doesn't list accounts in the all accounts tab | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97555 | |||
* admin console restore - doesn't autocomplete / suggest account matches when filling out email address box | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97556 | |||
* document new restore functions / options with ZCS 8+ for admin console restore | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97558 | |||
* admin console restore - rename "Selected Servers" panel to "Restore Options" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97559 | |||
*admin console restore - if only one mailstore in env. then state such in second panel of restore about "server for the restored accounts" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97560 | |||
*admin console restore - expand restore To options - To full backup label, To incremental target | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97561 | |||
*admin console restore - "restore to the latest backup" incorrectly described / broken | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97562 | |||
* admin console restore - unable to restore individual accounts [sort of] | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97564 | |||
* admin console restore - reuse GAL/Contact Picker Window for "restore individual accounts" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97565 | |||
'''Older Bug/RFE's''' | |||
* zmrestore using restoreToTime option restores data after the specified time | |||
= | ** See: http://bugzilla.zimbra.com/show_bug.cgi?id=15320 | ||
*** Resulting in documentation changes : [[CLI_zmrestore_Network_Edition_only]] | |||
I' | * zmrestore -restoreToTime should fail if no backup label is passed | ||
** See: http://bugzilla.zimbra.com/show_bug.cgi?id=28320 | |||
*** "unable to restore to point in time/incremental" '''Admin GUI''' | |||
**** http://bugzilla.zimbra.com/show_bug.cgi?id=33135 | |||
* Admin console issues and other details I've posted are in this bug: | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=27746 | |||
** Added for search terms, admin console can't restore to point in time | |||
* Include --ignoreRedoErrors option and error feedback in Admin Console for restore | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=52358 | |||
*** This could explain why your restore to time isn't working in the Admin Console but does from CLI when you see an error about redologs and then reattempt restore with the --ignoreRedoErrors and it works. | |||
=== | ===Restore An Individual Message=== | ||
The zmrestore command is at a mailbox level. | |||
An RFE was filed already to expand this. It is currently targeted for the Helix release. | |||
* "More Granular Restore: per folder & per-message" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=8849 | |||
*** '''Note''' - the above was marked as a duplicate of our work on "dumpster" option. I disagree with this choice and created the following RFE below. | |||
* "Ability to search data within backup and do "item" restores or identify locations of search results" | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=97551 | |||
A way around the current limitations would be to use lmtpinject. Please see the following for details on that: | |||
* http://www.zimbra.com/forums/installation/12617-recover-data-store-folders.html#post64962 | |||
* http://www.zimbra.com/forums/administrators/729-using-zmlmtpinject.html#post4017 | |||
The difficultly would be determining the message your trying to find within your backups that was "deleted" in prod. | |||
===User Deleted A Bunch Of Data And Notified You Hours Later Wanting It Restored=== | |||
# To determine the time of the delete, use the ''zmredodump'' command. | |||
#* You'll use this "time" for the restore command. | |||
#* Example: | |||
#** ''$ zmprov gmi USER@DOMAIN.com'' ::: gives me mailboxid 17 | |||
#** ''$ zmredodump --show-blob --m 17 /opt/zimbra/redolog/ | grep Delete'' ::: returns: | |||
#*** ''[0000f311 - 0000f350: 64 bytes; tstamp: 2010/11/19 11:21:30.852 CST] txn 1290033504.2544 [DeleteItem] ver=1.28, tstamp=1290187290852, change=3913, mailbox=17, ids=[304, 308], type=5'' | |||
#*** ''[0000f351 - 0000f382: 50 bytes; tstamp: 2010/11/19 11:21:30.869 CST] txn 1290033504.2544 [CommitTxn] ver=1.28, tstamp=1290187290869, mailbox=17, txnType=DeleteItem'' | |||
# See [[Ajcody-Backup-Restore-Issues#Restore_To_Time_Problems]] about setting up the proper restore syntax. | |||
#* You'll want to include the ''-ca -pre restore_'' options since we'll first get the old data into a temporary account. | |||
#* Remember to use ''zmbackupquery -a USER@DOMAIN.com --type full'' to find what full label will be needed for the restore. | |||
#* Also, if you need/want the incremental label, do a ''zmbackupquery -a USER@DOMAIN.com --type incremental'' . | |||
#** Example: | |||
#*** ''$ zmbackupquery -a USER@DOMAIN.com --type full'' ::: shows the latest as being: | |||
#**** ''Label: full-20101119.070018.607'' | |||
#**** ''Type: full'' | |||
#**** ''Started: Fri, 2010/11/19 01:00:18.607 CST'' | |||
#**** ''Ended: Fri, 2010/11/19 01:00:29.751 CST'' | |||
#**** ''Acct ID: f33d6daf-8875-4496-8bee-6df345f295e7'' | |||
#* Do the restore now with the proper information for the variable flags. | |||
#** '''''Note''''': You might need to include -br , -rf , or neither depending on the time frames involved. | |||
#** Example: | |||
#*** ''$ zmrestore -a USER@DOMAIN.com -restoreToTime 20101119112000 -lb full-20101119.070018.607 -ca -pre restore_'' | |||
#** It would be best to log into the restore_USER@DOMAIN.com account to confirm the data is as you expect it. | |||
# Use ''zmmailbox'' with the ''getRestUrl'' option against the "restore_USER" account now to export the data. | |||
#* Examples: | |||
#** Export ALL the 'old' data from the restored account | |||
#*** ''$ /opt/zimbra/bin/zmmailbox -z -m restore_USER@DOMAIN.com getRestURL "//?fmt=tgz" > /var/tmp/user-export.tgz'' | |||
#** You can also export SOME of the 'old' data from the restore account using other options. One option is with the ''before'' and ''after'' variables. '''NOTE''' - We have to set the query string as a variable to get around some of the shell issues. | |||
#** For example: | |||
#*** ''$ query='before:11/20/2010 after:11/1/2010''' | |||
#**** ZCS5 might require you to have a %20 rather than the actual space character. | |||
#*** ''$ /opt/zimbra/bin/zmmailbox -z -m restore_USER@DOMAIN.com getRestURL "//?fmt=tgz&query=$query" > /var/tmp/user-export.tgz'' | |||
#**** '''Note''': the $query above will be the expansion of the variable you set prior in the shell, ''query='before:11/20/2010 after:11/1/2010''' . | |||
# Use ''zmmailbox'' with the ''postRestUrl'' option to IMPORT the RESTORE_USER account into the "USER" account now with appropriate options. | |||
#* Examples: | |||
#** ''$ /opt/zimbra/bin/zmmailbox -z -m USER@DOMAIN.com postRestURL “//?fmt=tgz&resolve=replace” /var/tmp/user-export.tgz'' | |||
#* '''Note''' : A critical option in the above command is the ''&resolve=replace'' one. There are various ways you can handle the importing of data. Please review the following to determine what is best for you needs. | |||
#** [[Ajcody-Migration-Notes#ZCS_User_to_Another_ZCS_Server_-_With_Rest_.26_TGZ]] | |||
===Restore | ===Restore Deleted Items - skipDeletes Option - ZCS6+=== | ||
* "skip delete operations flag to zmrestore" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=31824#c5 | |||
From | From the RFE comment: | ||
<pre> | |||
Added new option --skipDeletes to zmrestore. If specified, skip | |||
over delete operations during redo replay. Delete ops are: | |||
DeleteItem (hard delete) | |||
DeleteMailbox | |||
EmptyFolder | |||
MoveItem, if moving item to Trash folder | |||
PurgeImapDeleted | |||
PurgeOldMessages | |||
Skipping these deletes can lead to other problems later, such as | |||
conflicting paths, but it is assumed the priority is recovering as | |||
much data as possible when using this option. | |||
</pre> | |||
===Restore Account Not Yet In Backups=== | |||
Please see: | |||
* "add ability to restore accounts not yet backed up (but still in redologs)" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=31536 | |||
===How To Restore To Events Within The Same Day=== | |||
Work in progress and investigation. | |||
====Users Trash Items==== | |||
=====User Ability To Recover Trash Purge===== | |||
Please see RFE: | |||
* "RFE: Recover Deleted Items ability for users" | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=30582 | |||
===Restoring | =====Retention Policy About Purges===== | ||
Please see [[Mailbox_Purge]] | |||
===Can't Restore Or Find An Account That Was Renamed=== | |||
When an account is "renamed", the old account name will no longer be "found" is your "default" type restore or backup queries. This can cause some confusions when one needs to restore to a time frame of when the account was under it's older name. | |||
====Restoring From CLI==== | |||
First, identify what sessions labels hold the differing account names: | |||
zmbackupquery -a USER@DOMAIN | |||
zmbackupquery -a USER-RENAMED@DOMAIN | |||
You should know have what you need to do follow the steps in the [[Ajcody-Backup-Restore-Issues#Restore_To_Time_Problems]] section. | |||
====Restoring From Admin Console GUI==== | |||
I'll give a detail explanation of the situation when working around restores of renamed accounts in the admin console [web GUI]: | |||
# If you in the GUI goto the "Restore" button, it first asks for an account rather than giving an option for date/time/session. I think you already stated, that "renamed" accounts don't show up in this query window. Therefore, one wouldn't really progress to the next window that would allow you to change the backup session label. | |||
# They way you get around this is, you actually double click on the full session listing that you see on the backup page in the admin UI. This will bring you to another page, that is specific to that session. In there, you should see the old account name prior to the rename. You can then highlight that account listing and click on the "Restore" button. This will bring up the restore dialog, which will now have the date/time/session label auto-filled out. | |||
=== | ===Quota Is Stopping A Redirected Restore=== | ||
'''Update''' | |||
= | * "accounts with quota set by COS fail to restore when over default quota" | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=41875 | |||
Reasoning for need, maybe the msg files coming from the restore are no longer "shared message blobs" and therefore increase the mailbox to a size it wasn't in the past. Changes to HSM maybe? | |||
I think I'll need to create a RFE about adding an option to the zmrestore command to also include an option to set the COS value on a created account. Until then... Create a new COS and set it up to NOT have any quota. Once you kick off the backup and you see the account is created you can then apply the COS to that account. Call the cos something like no-quota. Here's the steps below. | |||
To copy your cos (assuming your quota cause is the default one, change default to match your production cos your using). | |||
To see all cos's | |||
zmprov gac | |||
Copies cos called default to cos named no-quota | |||
zmprov cpc default no-quota | |||
To remove quota to the new cos no-quota | |||
zmprov mc no-quota zimbraMailQuota 0 | |||
To confirm | |||
zmprov gc no-quota | grep -i quota | |||
Now you would start your redirected restore and once you see the account is created, run the below in a separate shell. (example) | |||
zmrestore -a USER@DOMAIN.com -restoreToTime 20080801011800 -lb full-20080726.050017.306 -br -ca -pre restore- | |||
Once restore has kicked off - To apply the no-quota cos to the restored account: | |||
zmprov sac restore-USER@DOMAIN.com no-quota | |||
===Restore Of Non-Account Items - Example - COS DL Etc === | |||
Cos and DL's are ldap entries basically. | |||
From [http://www.zimbra.com/docs/ne/latest/administration_guide/10_Backup_Restore.17.01.html Backup and Restore] | |||
*zmrestoreldap. This command restores the complete LDAP directory server, including accounts, domains, servers, COS and other data." | |||
You'll see in a DR process, [[Network_Edition_Disaster_Recovery]] , that the zmrestoreldap is done before the zmrestoreoffline . | |||
*zmrestoreldap doesn't have options that allow specific items to be restored (COS, DL's, etc.). It only has option for named accounts (-a). One could try a ldapadd with a ldif of the COS or DL details. One could also take the information on the COS or DL within the ldap file in the backup session to at least have all the variables to manually add it back (via the zmprov command). Your looking at the backups on the LDAP master if your in a multi-server configuration. | |||
<pre>/opt/zimbra/backup/sessions/full-xxxxxx/ldap/ldap.bak</pre> | |||
Start of ldap entry example to search for: | |||
*Cos example | |||
**dn: cn=default,cn=cos,cn=zimbra | |||
*DL example | |||
**dn: uid=dl-group,ou=people,dc=mail,dc=domain,dc=com | |||
To compare a current DL with past details, just save out the ldap entry from the backup to a txt file. And then do: | |||
<pre>zmprov gdl maillist@domain.com</pre> | |||
Make the necessary changes after comparing the two. | |||
===Restoring A Calendar (ics)=== | |||
The admin guide mentions: | There seems to be a bug or odd expectation on how this command is currently working. If the appointment exists in the Calendar and the time is different with the same appointment in the ics file your importing - the time of the appointment will not change to the imported ics one. If you delete the event first, then the imported appointment will reflect the correct time. | ||
:"Full backup is usually run asynchronously. When you begin the full backup, the label of the ongoing backup process is immediately displayed. The backup continues in the background. You can use the zmbackupquery command to check the status of the running backup at any time." | Here's what I did to reproduce this situation. It seems this has been true for sometime, customer was on 4.5.11 and I was on 5.0.8 | ||
I couldn't find any other indication beyond that to explain in more details the purpose of that flag. But from what is stated above, it does look like the -sync flag will resolve the issues of "backup in progress" when scripting out multiple zmbackup commands. | <pre> | ||
Created test account and made two appointments on friday - 9am and 4pm. | |||
If not, you could query for "Status: in progress" from the zmbackupquery command. | Did a full backup. | ||
Restored test account to restore_user | |||
You can give the zmbackupquery command flags for date/time, label, account, -t target, and so forth [Do a zmbackupquery --help to see the options format]. | Ran : | ||
zmmailbox -z -m user@domain.com gru /Calendar > /tmp/calendarA.ics | |||
===Backing Up Backups - 3rd Party Tools And Software - Dealing With Directories With Hard Links=== | zmmailbox -z -m restore_user@domain.com gru /Calendar > /tmp/calendarB.ics | ||
And then | |||
====Description Of Hard Links==== | diff /tmp/calendarA.ics /tmp/calendarB.ics [no differences] | ||
Zimbra uses hard links and special attention needs to be given to this fact. See [http://en.wikipedia.org/wiki/Hard_link hard links] if your not familiar with hard links and their difference to [http://en.wikipedia.org/wiki/Symbolic_link symbolic links]. Not all 3rd party backup software will handle or respect hard links. Many unix commands will need special flags to maintain hard links. When hard links are respected and also "copied" to the new location you could find your data usage become a large multiplication of the original size. | Now some tests. | ||
As user, I deleted the two appointments and then: | |||
An good thread I found on the topic of preserving hard links for copy/move/backup operations is here: | zmmailbox -z -m user@domain.com pru /Calendar /tmp/calendarB.ics | ||
Refreshed Calendar as User in webclient. | |||
* "How to Copy a Filesystem and Preserve Hard Links in Linux - Some random bits scribbled by Jeremy Zawodny" | 9am and 4pm appointment shows up. | ||
** http://jeremy.zawodny.com/blog/archives/010037.html | I then moved in the webclient the 9am appointment to 11am | ||
Did another restore: | |||
I'll be summarizing the comments and including additional information I find on the topic below, based upon the command or software being used. | zmmailbox -z -m user@domain.com pru /Calendar /tmp/calendarB.ics | ||
Refreshed Calendar as User in webclient. | |||
=====Zimbra and Single Instance Storage - Hard Links===== | 11am and 4pm appointment shows up. | ||
** The restore did not move the 11am appointment back to the 9am slot as in /tmp/calendarB.ics | |||
If hard links are possible, we use them. | ** Assumption, this process will not over-write an appointment if it's there - it does not look to the time. | ||
Let's do a diff of the state of the calendar | |||
Mike gives a good description of it here: | zmmailbox -z -m user@domain.com gru /Calendar > /tmp/calendarC.ics | ||
* http://www.zimbra.com/forums/administrators/14435-single-instance-storage.html#post73746 | diff /tmp/calendarB.ics /tmp/calendarC.ics | ||
** Here's the one wiki page Mike mentions in there: [[Account_mailbox_database_structure]] | The DTSTAMP and SEQUENCE shows the difference in the time. | ||
If I delete the 11am appointment and then do the calendarB.ics restore the appointment shows up again at 9am. | |||
======Redoing Hard Links RFE====== | </pre> | ||
For 8.0.2+ , see this option - zmdedupe : | I see this same behavior if I also use the web interface to export/import the calendar between the restored account and user one. Even when I import it into a NEW calendar, it even changes the two appointments to reflect the new calendar rather than the default one. | ||
* RFE: Shipping a tool to convert duplicate blobs to hardlinks | ====One Fix==== | ||
** https://bugzilla.zimbra.com/show_bug.cgi?id=77597 | One fix, if the situation allows, is to purge the current Calendar and then import the full ics file. This would be done like this: | ||
======Easy Way To SEE Hard Links In Use====== | <pre> | ||
zmmailbox -z -v -m ajcody@mail3.internal.homeunix.com ef /Calendar | |||
* ef is for emptyFolder zmmailbox help folder | |||
*webclient shows all events gone but Calendars are still listed. | |||
zmmailbox -z -v -m ajcody@mail3.internal.homeunix.com pru /Calendar /tmp/calendarB.ics | |||
*webclient show all events with times as expected. | |||
</pre> | |||
====Second Fix==== | |||
Haven't tried yet, but someone said you should be able to adjust the SEQUENCE number in the appointment and the import process will use that data (data/time) of the newer sequence number appointment. | |||
===Archiving User Accounts Out Of Production Use In Zimbra=== | |||
====Backup - Restore Method==== | |||
To "archive" the user data with the ability of Zimbra later restoring if needed, one would rely on the backup/restore tools. | |||
For example: | |||
zmbackup -f -a user@domain | |||
If you want to make this more "intelligent" later, one could do this: | |||
mkdir /nfs-mount/archived-users/[user-name] | |||
zmbackup -f -a userA@domain -t /nfs-mount/archived-users/userA-domain/ | |||
This would give some "intelligent" information for recovery later. Confirms it was an archived account, shows the "real" username, the date of the full backup, and so forth. | |||
ls /nfs-mount/archived-users/userA-domain/ | |||
full-20081104.131643.006 | |||
ls /nfs-mount/archived-users/userA-domain/full-20081104.131643.006 | |||
accounts/ session.xml shared_blobs sys | |||
If one would need to "restore" the account later, it would consume a license if the account was "deleted". | |||
zmrestore -a userA@domain -ca -pre restored- -t /nfs-mount/archived-users/userA-domain/ -lb full-20081104.131643.006 | |||
=====Setup A Secondary Zimbra Box For Restores Of Archive Accounts===== | |||
Your Zimbra license can be installed on multiple machines. One idea that might prove useful in handling these "archive" accounts for those situations when you need to investigate something is to setup a "archive" Zimbra box. You'll want to isolate this box from any "production" use. It will need to be configured to have the "domains" of the archive accounts. You can then use this box to restore the "archive" account and then use the administration tools to investigate the user data. | |||
===Use Of REST And Other Tools For Specific User Data=== | |||
The following page, [[User_Migration]] , will shows numerous examples of how to export different types of data from a user account into a neutral file format that one could use for "archive" purposes. | |||
===Use Of The REST Command To Export ALL User Data - Version Dependant, 5.0.9+ [I believe]=== | |||
Example of the commend syntax: | |||
/opt/zimbra/bin/zmmailbox -z -m user@domain.com getRestURL “//?fmt=tgz” > /tmp/account.tgz | |||
===Backup And HSM=== | |||
Please see Bugs/RFE: | |||
* "RFE: HSM and backup should not run at the same time if initated." | |||
** http://bugzilla.zimbra.com/show_bug.cgi?id=33452 | |||
===Using zmprov -l gaa To Create User Listing for zmbackup & zmrestore -a option=== | |||
For example, see below. '''Note''' the use of the egrep -v option below, this would ''remove'' any matches from the grep. Useful if you want to only backup certain domains for example. | |||
<pre> | |||
[zimbra@ldap2 sessions]$ zmbackup -f -a `zmprov -l gaa | egrep -v "ham|spam|virus|admin|galsync"` | |||
full-20150130.210821.124 | |||
[zimbra@ldap2 sessions]$ zmbackup -f -a `zmprov -l gaa` | |||
full-20150130.210922.637 | |||
[zimbra@ldap2 sessions]$ zmbackupquery -lb full-20150130.210821.124 -v | |||
Label: full-20150130.210821.124 | |||
Type: full | |||
Status: completed | |||
Started: Fri, 2015/01/30 16:08:21.124 EST | |||
Ended: Fri, 2015/01/30 16:08:50.181 EST | |||
Redo log sequence range: 23 .. 23 | |||
Number of accounts: 3 out of 3 completed | |||
Accounts: | |||
archive-search-results@ldap2.zimbra.DOMAIN.com: completed | |||
user1-20150115@ldap2.zimbra.DOMAIN.com.archive: completed | |||
user1@ldap2.zimbra.DOMAIN.com: completed | |||
Total space: 14020MB | |||
Free space: 5977MB | |||
[zimbra@ldap2 sessions]$ zmbackupquery -lb full-20150130.210922.637 -v | |||
Label: full-20150130.210922.637 | |||
Type: full | |||
Status: completed | |||
Started: Fri, 2015/01/30 16:09:22.637 EST | |||
Ended: Fri, 2015/01/30 16:09:33.083 EST | |||
Redo log sequence range: 23 .. 23 | |||
Number of accounts: 9 out of 9 completed | |||
Accounts: | |||
admin-20150122@ldap2.zimbra.DOMAIN.com.archive: completed | |||
admin@ldap2.zimbra.DOMAIN.com: completed | |||
archive-search-results@ldap2.zimbra.DOMAIN.com: completed | |||
galsync.tfnapjb9@ldap2.zimbra.DOMAIN.com: completed | |||
ham.yeygcogdd2@ldap2.zimbra.DOMAIN.com: completed | |||
spam.dpxyqjnm6t@ldap2.zimbra.DOMAIN.com: completed | |||
user1-20150115@ldap2.zimbra.DOMAIN.com.archive: completed | |||
user1@ldap2.zimbra.DOMAIN.com: completed | |||
virus-quarantine.wfkd4vvm1g@ldap2.zimbra.DOMAIN.com: completed | |||
Total space: 14020MB | |||
Free space: 5977MB | |||
</pre> | |||
===Scripting Out Individual Backups Of Accounts=== | |||
If you want to do individual backups of accounts using a for-loop, for example, you might want to include the -sync option from zmbackup. zmbackup without this will normal give an error as it passing the next zmbackup command stating that there's a current backup in progress. | |||
Example command in some for-loop script is ['''without the -sync option''']: | |||
sudo -u zimbra /opt/zimbra/bin/zmbackup --fullBackup --account "$acct" --server "$host" --target "$dest" | |||
zmbackup --help shows: | |||
--sync -sync Runs full backup synchronously. | |||
The admin guide mentions: | |||
:"Full backup is usually run asynchronously. When you begin the full backup, the label of the ongoing backup process is immediately displayed. The backup continues in the background. You can use the zmbackupquery command to check the status of the running backup at any time." | |||
I couldn't find any other indication beyond that to explain in more details the purpose of that flag. But from what is stated above, it does look like the -sync flag will resolve the issues of "backup in progress" when scripting out multiple zmbackup commands. | |||
If not, you could query for "Status: in progress" from the zmbackupquery command. | |||
You can give the zmbackupquery command flags for date/time, label, account, -t target, and so forth [Do a zmbackupquery --help to see the options format]. | |||
===Finding Message Blob In Users Backup=== | |||
Get the zimbraId of the user, this is what is used in the backup session directory layout: | |||
<pre> | |||
$ zmprov ga admin@`zmhostname` zimbraId | |||
# name admin@zcs806.DOMAIN.com | |||
zimbraId: e46a828b-cdda-4635-98ab-31b8ac0129b6 | |||
</pre> | |||
Get the mailboxId, this is what is used in the zmvolume primary message volume directory layout: | |||
<pre> | |||
$ zmprov gmi admin@`zmhostname` | |||
mailboxId: 1 | |||
quotaUsed: 77794874 | |||
</pre> | |||
Finding a message in the primary message volume: | |||
<pre> | |||
$ cd /opt/zimbra/store/0/1/msg/9/ | |||
$ ls -la 40511-49376.msg | |||
-rw-r----- 1 zimbra zimbra 1372 Mar 16 02:01 40511-49376.msg | |||
</pre> | |||
Finding the users directory in a full backup session directory layout: | |||
<pre> | |||
$ find /opt/zimbra/backup/sessions/full-20140426.080019.153/ -name e46a828b-cdda-4635-98ab-31b8ac0129b6 -print | |||
/opt/zimbra/backup/sessions/full-20140426.080019.153/accounts/e46/a82/e46a828b-cdda-4635-98ab-31b8ac0129b6 | |||
</pre> | |||
Locating the message in the backup session - this example is where the backups are using the zip option: | |||
<pre> | |||
$ cd /opt/zimbra/backup/sessions/full-20140426.080019.153/accounts/e46/a82/e46a828b-cdda-4635-98ab-31b8ac0129b6/blobs/ | |||
$ ls | |||
blobs-1.zip blobs-2.zip blobs-3.zip blobs-4.zip | |||
$ for i in `ls /opt/zimbra/backup/sessions/full-20140426.080019.153/accounts/e46/a82/e46a828b-cdda-4635-98ab-31b8ac0129b6/blobs/`; do echo $i ; unzip -l $i | grep 40511-49376.msg; done | |||
blobs-1.zip | |||
1372 04-26-2014 01:00 1/9/sha256_bKH8aeWJSh9bhzv5zsXrweA7+jZ88NUllkfV+7m9cJo=_40511-49376.msg1 | |||
</pre> | |||
===Backing Up Backups - 3rd Party Tools And Software - Dealing With Directories With Hard Links=== | |||
====Description Of Hard Links==== | |||
Zimbra uses hard links and special attention needs to be given to this fact. See [http://en.wikipedia.org/wiki/Hard_link hard links] if your not familiar with hard links and their difference to [http://en.wikipedia.org/wiki/Symbolic_link symbolic links]. Not all 3rd party backup software will handle or respect hard links. Many unix commands will need special flags to maintain hard links. When hard links are respected and also "copied" to the new location you could find your data usage become a large multiplication of the original size. | |||
An good thread I found on the topic of preserving hard links for copy/move/backup operations is here: | |||
* "How to Copy a Filesystem and Preserve Hard Links in Linux - Some random bits scribbled by Jeremy Zawodny" | |||
** http://jeremy.zawodny.com/blog/archives/010037.html | |||
I'll be summarizing the comments and including additional information I find on the topic below, based upon the command or software being used. | |||
=====Zimbra and Single Instance Storage - Hard Links===== | |||
If hard links are possible, we use them. The message must be identical and on to users on the same mailstore and stored on zmvolumes where hard linking is possible. Hard links exist only on the same partition. Postfix has a veriable, default_destination_recipient_limit , which will cause large recipient emails to be delivered in a way where they aren't identical [ see [[Ajcody-Hardlinks-And-Postfix-default_destination_recipient_limit]] for more details ]. | |||
Mike gives a good description of it here: | |||
* http://www.zimbra.com/forums/administrators/14435-single-instance-storage.html#post73746 | |||
** Here's the one wiki page Mike mentions in there: [[Account_mailbox_database_structure]] | |||
======Redoing Hard Links RFE====== | |||
For 8.0.2+ , see this option - zmdedupe : | |||
* RFE: Shipping a tool to convert duplicate blobs to hardlinks | |||
** https://bugzilla.zimbra.com/show_bug.cgi?id=77597 | |||
======Easy Way To SEE Hard Links In Use====== | |||
I sent a test email with 5 accounts listed in the To field, that is shown below with the inode listing of 2133394. the first column of the ls [because of the i option] is listing the inode number of the file. I included the -type f because the . and .. will show directories using the same inode as the 'name' of the directory as listed. | I sent a test email with 5 accounts listed in the To field, that is shown below with the inode listing of 2133394. the first column of the ls [because of the i option] is listing the inode number of the file. I included the -type f because the . and .. will show directories using the same inode as the 'name' of the directory as listed. | ||
| Line 1,879: | Line 2,216: | ||
2133404 -rw-r----- 2 zimbra zimbra 1518 May 7 05:22 ./0/27/msg/0/260-3018.msg | 2133404 -rw-r----- 2 zimbra zimbra 1518 May 7 05:22 ./0/27/msg/0/260-3018.msg | ||
</pre> | </pre> | ||
======Why Does A Message Blob With The Same Message-ID Have Multiple Inodes====== | |||
Most likely, the message has a large recipient list and because of a variable in postfix, default_destination_recipient_limit , causes multiple deliveries of the message to have slight differences between them - for example, the times in the headers. | |||
Please see the following: | |||
* https://wiki.zimbra.com/wiki/Ajcody-Hardlinks-And-Postfix-default_destination_recipient_limit | |||
====Hard Links Used Within Zimbra Backup Directory - Sessions==== | ====Hard Links Used Within Zimbra Backup Directory - Sessions==== | ||
| Line 2,040: | Line 2,384: | ||
* [[5.0.x_Network_Edition_Backup_and_Restore#Using_snapshots_to_backup_and_restore]] | * [[5.0.x_Network_Edition_Backup_and_Restore#Using_snapshots_to_backup_and_restore]] | ||
* [[Individual_Mailbox_Restore_from_Snapshot]] | |||
* Developer discussion on the issue | * Developer discussion on the issue | ||
** http://bugzilla.zimbra.com/show_bug.cgi?id=21273 | ** http://bugzilla.zimbra.com/show_bug.cgi?id=21273 | ||
| Line 2,265: | Line 2,610: | ||
* "Installing a DLT, SDLT, VS, LTO, or DAT Tape Drive Into a Linux Operating System" | * "Installing a DLT, SDLT, VS, LTO, or DAT Tape Drive Into a Linux Operating System" | ||
** [PDF warning] http://cp-quantum.talismaonline.com/display/2/kb/article.aspx?aid=8040&n=1&docid=72010 | ** [PDF warning] http://cp-quantum.talismaonline.com/display/2/kb/article.aspx?aid=8040&n=1&docid=72010 | ||
---- | |||
[[Category: Community Sandbox]] | [[Category: Community Sandbox]] | ||
[[Category:Backup and Restore]] | [[Category:Backup and Restore]] | ||
[[Category: Author:Ajcody]] | |||
Latest revision as of 13:49, 17 May 2017
Ajcody Backup & Restore Issues
- This article is a Work in Progress, and may be unfinished or missing sections.
Actual Backup & Restore Issues Homepage
Please see Ajcody-Backup-Restore-Issues
Update - May, 2017
I'll be updating this page after the ZCS 8.8 release is done to only reflect what is true in that version and future versions. It will also include information about the Zimbra_Suite_Plus modules where appropriate. If you currently are using the backup module for ZSP, please see Zimbra_Suite_Plus/Zimbra_Backup_Plus for now.
Backup-Restore Training Material Rough Drafts I Wrote
- Ajcody-Troubleshooting-Recover_Missing_Data_-_Server
- Ajcody-Troubleshooting-Recover_Missing_Data_-_User
Bug/RFE's I Filed Against ZCS 8.6
- [story] Ability to search data within backup and do "item" restores or identify locations of search results
- admin console backup label view doesn't list accounts in the all accounts tab
- admin console restore - doesn't autocomplete / suggest account matches when filling out email address box
- document new restore functions / options with ZCS 8+ for admin console restore
- admin console restore - rename "Selected Servers" panel to "Restore Options"
- admin console restore - if only one mailstore in env. then state such in second panel of restore about "server for the restored accounts"
- admin console restore - expand restore To options - To full backup label, To incremental target
- admin console restore - "restore to the latest backup" incorrectly described / broken
- admin console restore - unable to restore individual accounts [sort of]
- admin console restore - reuse GAL/Contact Picker Window for "restore individual accounts"
Miscellaneous Bugs & RFE's
For those that address other specific issues described on this page:
- "Separate Restore Mechanism for Primary/Secondary Volumes" [Helix]
- http://bugzilla.zimbra.com/show_bug.cgi?id=18566
- "add backup/restore for HSM only" [marked as duplicate of above]
- http://bugzilla.zimbra.com/show_bug.cgi?id=18566
RFE For Live DR Restore Option
- zmrestore / zmrestoreoffline have options to --skipDeleteMailboxes - Provides Live DR option
Backups And Upgrades And Prior Versions
- Upgrades And Compatibility Of Older Backups
- "Backups must be compatible across patch releases"
- "Incorrect upgrade documentation regarding backups"
- "support for restore across major versions"
- "Add conversion tool to upgrade backup versions to allow restore on later zcs versions"
- From 5.0.7 - 5.0.10 You Might See minor version upgrades moving your backups into a subdirectory
- "upgrade incorrectly invalidates backups."
Information To Provide When Submitting A Support Case For Backup Issues
Basic Backup Information To Submit To Support
Disk Space Usage Issues
Trend Data
If there is concerns about disks/partitions getting full, this command would be helpful for trending data on your server. Send support the resulting df.tar file . Note - adjust the tail command if you want more than 20 day's worth of trending data, the -n 20 option.
[zimbra@zcs806 tmp]$ /tmp [zimbra@zcs806 tmp]$ tar cvf /tmp/df.tar `find /opt/zimbra/zmstat -name df.cs\* | sort | tail -n 20` tar: Removing leading `/' from member names /opt/zimbra/zmstat/2014-03-10/df.csv.gz /opt/zimbra/zmstat/2014-03-11/df.csv.gz [cut - Ajcody] /opt/zimbra/zmstat/2014-03-27/df.csv.gz /opt/zimbra/zmstat/2014-03-28/df.csv.gz /opt/zimbra/zmstat/df.csv [zimbra@zcs806 tmp]$ ls -lah /tmp/df.tar -rw-r----- 1 zimbra zimbra 80K Mar 29 06:44 /tmp/df.tar [zimbra@zcs806 tmp]$ tar tvf /tmp/df.tar -rw-r----- zimbra/zimbra 2566 2014-03-11 00:00 opt/zimbra/zmstat/2014-03-10/df.csv.gz -rw-r----- zimbra/zimbra 2553 2014-03-12 00:00 opt/zimbra/zmstat/2014-03-11/df.csv.gz [cut - Ajcody] -rw-r----- zimbra/zimbra 2513 2014-03-28 00:00 opt/zimbra/zmstat/2014-03-27/df.csv.gz -rw-r----- zimbra/zimbra 2531 2014-03-29 00:00 opt/zimbra/zmstat/2014-03-28/df.csv.gz -rw-r----- zimbra/zimbra 8013 2014-03-29 06:40 opt/zimbra/zmstat/df.csv
Directory Sizes In /opt/zimbra
Please see the following and provide the output to support. Note, even though this method is faster than doing a du it still can take awhile.
* Ajcody-Server-Misc-Topics#Faster_Way_To_Get_Directory_Size_On_Filesytem_-_find_vs_du
Adjusting The Disk Alert Threshold
Note - zmlocalconfig smtp_notify must return yes if you want to receive the notifications.
If you just need to adjust the disk alert threshold, then see the following:
See current values:
zmlocalconfig | grep zmdisklog
Example adjustment:
su - zimbra zmlocalconfig -e zmdisklog_critical_threshold=98 zmlocalconfig -e zmdisklog_warn_threshold=95 zmstatctl
To exclude a partition from the checks [example of two being excluded]:
su - zimbra zmlocalconfig -e zmstat_df_excludes="/mount/point:/mount/point2" zmstatctl
They might be a bug on this, where you'll keep getting email until a logrotate happens [zimbra.log?].
- Changing Zmstat-df values do not take affect until logrotate
Some things to do to confirm and share with support or in bug. As zimbra
su - zimbra
ls -la /var/log/zimbra.log
df -h
/dev/mapper/vg_rhel664-lv_root
5.5G 3.5G 1.7G 68% /
tmpfs 939M 0 939M 0% /dev/shm
/dev/sda1 485M 79M 381M 18% /boot
/dev/sdb1 30G 6.2G 23G 22% /opt
date
zmlocalconfig | grep zmdisklog
zmdisklog_critical_threshold = 80
zmdisklog_warn_threshold = 85
zmlocalconfig -e zmdisklog_critical_threshold=95
zmlocalconfig -e zmdisklog_warn_threshold=90
zmlocalconfig | grep zmdisklog
zmdisklog_critical_threshold = 95
zmdisklog_warn_threshold = 90
zmstatctl restart
date
ps -eaf | grep zmstat-df
ls -la /var/log/zimbra.log
date ; grep "Disk warning" /var/log/zimbra* ; zmmailbox -z -m admin@`zmhostname` s -l 100 -t message "Subject: Disk and after:yesterday"
##Note - Emails by default go out every 10 minutes - for example:
[zimbra@zcs803 ~]$ date ; grep "Disk warning" /var/log/zimbra* ; zmmailbox -z -m admin@`zmhostname` s -l 100 -t message "Subject: Disk and after:yesterday"
Thu May 22 09:40:08 PDT 2014
/var/log/zimbra.log:May 22 08:30:00 zcs803 zimbramon[18826]: 18826:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82%
/var/log/zimbra.log:May 22 08:40:00 zcs803 zimbramon[22970]: 22970:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82%
/var/log/zimbra.log:May 22 08:50:00 zcs803 zimbramon[22970]: 22970:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82%
/var/log/zimbra.log:May 22 09:00:00 zcs803 zimbramon[22970]: 22970:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82%
## Note - I had readjusted the variable to not warn during this time segment ##
/var/log/zimbra.log:May 22 09:20:00 zcs803 zimbramon[8322]: 8322:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82%
/var/log/zimbra.log:May 22 09:30:00 zcs803 zimbramon[8322]: 8322:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82%
/var/log/zimbra.log:May 22 09:40:00 zcs803 zimbramon[8322]: 8322:err: Disk warning: zcs803.DOMAIN.com: / on device /dev/mapper/vg_rhel664-lv_root at 82%
num: 7, more: false
Id Type From Subject Date
---- ---- -------------------- -------------------------------------------------- --------------
1. 328 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:40
2. 327 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:30
3. 326 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:20
## Note - I had readjusted the variable to not warn during this time segment ##
4. 325 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 09:00
5. 324 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 08:50
6. 323 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 08:40
7. 320 mess admin Disk / at 82% on zcs803.DOMAIN.com: 05/22/14 08:31
Continue to monitor your zmmailbox search results for an hour.
The Basic Information Support Needs
as root:
- cat /etc/fstab
- Shows us what is mounted upon boot
- cat /proc/mounts
- Shows us what is currently mounted and its status - you can see if a mount is read-only here.
- df -hT
- Lists current mounts using human-readable size information and also notes the filesystem type.
as zimbra:
- zmprov -l gs `zmhostname` | egrep 'Back|Redo'
- Will show us a number of variables related to backup and redologs. Also tell us if your using auto-group or the default method.
- du -sh /opt/zimbra/redolog
- Will might notice your redolog logs aren't rolling over, causing a possible issue.
- ls -latr /opt/zimbra/backup
- This is the default backup target, please adjust this path here and below if you are using a different zimbraBackupTarget value.
- zmprov gs `zmhostname` zimbraBackupTarget
- We'll be able to confirm permissions are right.
- ls -latr /opt/zimbra/backup/tmp
- This will show us if you have failed backup jobs and confirm tmp is being cleaned appropriately after the backup is done.
- ls -latr /opt/zimbra/backup/sessions
- This will show us what backup sessions are available and confirm permissions are correct.
- Adjust path if your zimbraBackupTarget value is not the default path.
- su - zimbra
- zmjava com.zimbra.cs.backup.util.GetVersion
- cd /opt/zimbra/backup/sessions/full-[YOUR MOST RECENT FULL]/
- head -n6 session.xml
- cd /opt/zimbra/backup/sessions/incr-[YOUR MOST RECENT INCREMENTAL]/
- head -n6 session.xml
- Some directory sizes in the backup directory:
- Default path first
- du -sh `find /opt/zimbra/backup -maxdepth 2 -type d`
- If your using a different backup target, check that directory also. Replace /opt/zimbra/backup above with your backup path.
- Default path first
- zmbackupquery
- This should match what's in the sessions directory and it will also tell us if status of each backup and how many accts were done.
- crontab -l | grep -i back
- This will show use when backups are support to run and with what options they are running with.
- zmlocalconfig | grep -i back
- This is useful to see a number of backup options not exposed in the crontab, things related to the zip options.
- zmvolume -l
- This is useful to see how many volumes are being used, if HSM is being used, and if compression is being done at the volume level.
Additional Log Files Support Might Need
And send the following logs:
- /var/log/messages
- Filesystem issues often times are noted here and also in syslog. This might explain an interruption in the backup process. Server restarts, filesystem going full, filesystem going read-only, etc.
- /var/log/syslog
- /opt/zimbra/log/mailbox.log
- The backup activity is logged here.
- And any other mailbox.log file that would cover the event
Additional Checks For Performance Specific Issues
If Your Using a SAN or NFS For Your Backup Target - Please Check Your IOWait
Ideally, you would compare iowait and performance data from the target backup host as well as the stats available on the ZCS servers. To get graphs and stats on this from ZCS, please see Ajcody-Testing-Debugging#zmstat_and_zmstat-chart . You should submit this data and iowait conclusions if you still need to submit a support case about backup performance issues.
Is HSM Running During Your Backup Window
- Are you running HSM? HSM should not be ran during your backup window.
- "RFE: HSM and backup should not run at the same time if initated."
Are You Using --zipStore
--zipStore zips the blobs vs. keeping the blobs as individual files. --zipStore does not use compression either. For most circumstances, this will give the best performance, especially with NFS. This should be the default behavior of the backups, the following RFE is when it became the default [ZCS6+] :
- "backup: default to the zip option"
- https://bugzilla.zimbra.com/show_bug.cgi?id=31836#c6
- Link to comment that explains options and default behavior.
- https://bugzilla.zimbra.com/show_bug.cgi?id=31836#c6
To see if zip's are being used for backups for example, in the backup/session directory you'll know if it is by seeing .zip files:
mail:~/backup/sessions/full-20080820.160003.770/accounts/115/988/11598896-a89b-4b9d-bedb-1ed1afcb6c87/blobs zimbra$ ls blobs-1.zip blobs-2.zip blobs-3.zip blobs-4.zip
To see if the zip file is using compression [-Z option for unzip will indicate whether or not the archive is actually compressed] :
unzip -Z blobs-4.zip 293 files, 5982984 bytes uncompressed, 5982984 bytes compressed: 0.0%
Also, if your zmvolume has compression enabled the blobs will remain compressed within the zip also upon backup. The point being, they are uncompressed to be then put into a zip file when the backup is using --zipStore.
Restore Compatibility Between ZCS Versions
Please see the following for details. In summary, user level restores should work against older ZCS backup data.
- "support for restore across major versions"
Other related bug/rfe's:
- support for restore across major versions
- Restore across multiple versions
- Restore across multiple versions
- Backups must be compatible across patch releases
- write ZCS version into backup
- Restore should deal with database schema changes that add columns with defined default value
- Incorrect upgrade documentation regarding backups
NFS Use For Backups
Please see this RFE:
- "Need clarity on supporting nfs mounted zimbra directories - report error/msg if nfs mount is present"
This is the proposed statement to be included in the release notes following the RFE:
- ZCS & NFS:
- Zimbra will support customers that store backups (e.g. /opt/zimbra/backup) on an NFS-mounted partition. Please note that this does not relieve the customer from the responsibility of providing a storage system with a performance level appropriate to their desired backup and restore times. In our experience, network-based storage access is more likely to encounter latency or disconnects than is equivalent storage attached by fiber channel or direct SCSI.
- Zimbra continues to view NFS storage of other parts of the system as unsupported. Our testing has shown poor read and write performance for small files over NFS implementations, and as such we view it unlikely that this policy will change for the index and database stores. We will continue to evaluate support for NFS for the message store as customer demand warrants.
- When working with Zimbra Support on related issues, the customer must please disclose that the backup storage used is NFS.
Things To Check
- Check the /var/log/messages on both the zimbra server and the nfs server for nfs related errors during the time frame of your backup.
- Check /opt/zimbra/log/mailbox.log for error messages about folders/files not being able to be written or missing directory errors.
- Is root_squash configured on the nfs server? If it's changed to no_root_squash , does the behavior of the backup change?
- Is the */backup directory owned by zimbra:zimbra with at least 750 or 755 permissions?
- This parent directory as given in:
- zmprov gs `zmhostname` zimbraBackupTarget
- This parent directory as given in:
- Does zimbraBackupTarget have at least the subdirectories of : sessions and tmp : and are owned by zimbra:zimbra with 750 or 755 permissions?
- If not, try manually creating them and then running a test backup.
- IF USING A NAS - MAKE SURE YOUR NOT USING EXTENDED ACLS OR THAT YOU HAVE THEM CONFIGURED PROPERLY
- If your backup session directory shows something like : drwxrwx---+ 2 zimbra zimbra 4096 Sep 14 00:00 TO_DELETE-full-XXXXXX , that + sign indicated extended acls are in use.
Debugging Example
Steps I wrote for one customer, where saving out the information as you walk through all the commands would give enough information [hopefully] to submit a good rfe/bug:
1. make a test partition on nfs server - /nfs-test
2. mount on zimbra server
2A. mkdir /nfs-test
2B. chmod 755 /nfs-test
2C. mount nfs-server:/nfs-test /nfs-test
2D. ls -la /nfs-test
2E. mkdir /nfs-test/backup
2F. chown zimbra:zimbra /nfs-test/backup
2G. chmod 755 /nfs-test/backup
2H. su - zimbra ; touch /nfs-test/backup/testfile
2I. ls -laR /nfs-test/
2J. rm /nfs-test/backup/testfile
3. Set zimbraBackupTarget
3A. zmprov ms `zmhostname` zimbraBackupTarget /nfs-test/backup
4. Run a full backup against one account
4A. ex. zmbackup -f -a user@domain.com
5. ls -laR /nfs-test/
6. If you again, run into the same problem. You could also repeat the backup after increasing the backup
logging variable for the account your trying to backup. If you didn't run into the same problem, it might
had to do with the initial setup of the nfs mount and permissions being used during the directory creation.
6A. zmprov aal user@domain.com zimbra.backup debug
6B. logging will show up in /opt/zimbra/log/mailbox.log
6C. Remove account logging when your done. zmprov ral user@domain.com zimbra.backup
8. Change zimbraBackupTarget back to your production path.
Setup A Fast Test NOT Using NFS
A way to "avoid" the NFS issues for testing purposes would be to setup a new zimbraBackupTarget to try doing a full backup of a couple of user accounts. I DON'T recommend this if your using auto-group for zimbraBackupMode [ zmprov gs `zmhostname` zimbraBackupMode ] , only if your using Standard mode.
[as root] ** adjust your new "backup" directory path as needed - mine is just an example** mkdir /mnt/usb1/backup-test chown zimbra:zimbra /mnt/usb1/backup-test chmod 750 /mnt/usb1/backup-test su - zimbra **confirm backup mode as standard** zmprov gs `zmhostname` zimbraBackupMode **if not stand, please stop** zmprov ms `zmhostname` zimbraBackupTarget /mnt/usb1/backup-test **Find a couple of test accounts to do a full for. Make sure you'll have space to do the backup regards to need free space.** zmbackup -f -a user1@domain.com user2@domain.com user3@domain.com **Watch and confirm status of backup you just started.** zmbackupquery **Confirm files were backed up in right location** ls /mnt/usb1/backup-test/sessions/ **Failed backups would most likely results in left over directory in tmp directory** ls /mnt/usb1/backup-test/tmp/
Restore For Disaster Recovery
For Full Single ZCS Server DR Restores
Please see Network_Edition_Disaster_Recovery
Some additional notes I have on it - Ajcody-Disaster-Recovery-Specific-Notes
For Multi-Server DR Restore Specifics
Along with the above references, please see Ajcody-Notes-Multi-Server-Restore-DR
To Restore Just The LDAP Date
Let's say your ldap data was 'lost/destoyed' but everything else was intact, you should look at the zmrestoreldap command.
This section should have more precaution and background information to handle this section.
The basics:
- To find the LDAP session labels type -lbs.
- zmrestoreldap -lbs
- Restore the complete LDAP directory server
- zmrestoreldap -lb full20061130135236
- Restore LDAP data for specific accounts
- zmrestoreldap -lb full20061130135236 -a tac@DOMAIN.com jane@DOMAIN.com
To Restore Just The Mysql DB
Option available from the following RFE work:
- "Allow backup of only primary message volume"
- https://bugzilla.zimbra.com/show_bug.cgi?id=35278
- Options to exclude types of data as described in the 6.0.6 Admin Guide:
- Search index : If you do not restore the search index data, the mailbox will have to be reindexed after the restore.
- zmrestore <all or account> --exclude-search-index
- Blobs : This is a useful option when all blobs for the mailbox being restored already exists.
- zmrestore <all or account>|--exclude-blobs
- HSM-blobs : This is useful when all HSM blobs for the mailbox being restored already exists.
- zmrestore <all or account> --exclude-hsm-blobs
- Search index : If you do not restore the search index data, the mailbox will have to be reindexed after the restore.
- Options to exclude types of data as described in the 6.0.6 Admin Guide:
- https://bugzilla.zimbra.com/show_bug.cgi?id=35278
Let's say your mysql data was 'lost/destoyed' but everything else was intact. This might be the solution for the situation:
The steps below are to REPRODUCE A DR situation to test.
- zmcontrol stop
- Caution - step to reproduce DR situation to test against
- mv ~/db/data ~/db/data.OLD
- Getting old mysql passwords
- zmlocalconfig -s mysql_root_password
- zmlocalconfig -s zimbra_mysql_password
- [as zimbra] /opt/zimbra/libexec/zmmyinit
- Most likely your mysql passwords will change.
- See the following article to set them back:
- ldap start
- zmconvertctl start
- mysql is already running per the zmmyinit - mysql.server status - to check.
- zmrestoreoffline -a all -br --systemData --excludeSearchIndex --excludeBlobs --excludeHsmBlobs
- Note - you most likely will want to use the -br or -rf option for this situation.
- -br,--backedupRedologsOnly : Replays the redo logs in backup only, which excludes archived and current redo logs of the system
- -rf,--restoreFullBackupOnly : Restores to last full backup only, which excludes incremental backups.
- -sys,--systemData : Restores global tables and local config.
- This restores the 'zimbra' mysql data - this stuff Ajcody-Mysql-Topics#zimbra_Database_Default_Example_for_ZCS5
- Important - the zimbra db holds information about the volumes. This needs to be restored/existing prior to user db restoration.
- Note the use of -a all , you could also do this for one account first to confirm operation is successful for your circumstances.
- Note - you most likely will want to use the -br or -rf option for this situation.
- If you used -rf or -br with your zmestoreoffline, you might also need to use zmplayredo to finish it up to get the most complete restore.
- Improve zmrestore & zmrestoreoffline performance
- Ajcody-Backup-Restore-Issues#zmplayredo_-_Replaying_Content_From_Any_Redolog_File and other 'redolog' sections on that page.
Performance Issues And Time To Complete
Please see Ajcody-Notes-BackupPlans#What_About_Backups.3F_I_Need_A_Plan
Also created an RFE for increase backup performance:
- "Improve zmrestore & zmrestoreoffline performance"
- "Improvement to backup performance"
- http://bugzilla.zimbra.com/show_bug.cgi?id=36220
- Above marked as a dupe of "Reduce duration of maintenance mode during backup"
Understanding Option Flags For zmbackup & zmrestore
First, they don't make sense if your just reading from the help output - I will not argue this point at all.
The biggest problem with the options I point out below is that you can often include them in the command and they do nothing or you include them for a particular situation and they don't apply. Why is this a problem? Because they are silent and give no output telling you that it's not necessary, it's redundant, or it will actually cause your intended results to fail simply because you included the option.
zmrestore Options
Problems mostly revolve around these options.
To Times In The Past (If -lb Isn't Used, Implies Your Using Times/Incr/RedoSeq AFTER Last Full)
- -restoreToIncrLabel
- <arg> Replay redo logs up to and including this incremental backup
- Requires: --label or -lb
- <arg> Replay redo logs up to and including this incremental backup
- -restoreToTime
- <arg> Replay rodo logs until this time
- Requires: --label or -lb
- <arg> Replay rodo logs until this time
- -restoreToRedoSeq
- <arg> Replay up to and including this redo log sequence
Redolog Variables
- --backedupRedologs or -br
- Replays the redo logs in backup only, which excludes archived and current redo logs of the system
- Only useful when restoring against latest full backup (NOT using the -lb option).
- Will restore using incremental backup data after the last full backup as well but NOT including any redolog activity.
- Replays the redo logs in backup only, which excludes archived and current redo logs of the system
- --restorefullBackup or -rf
- Restores to the full backup only, not any incremental backups since that backup.
- The default behavior of zmrestore in general is to always play from a "full" and "incrementals" that are associated with it UNLESS you state otherwise.
- If you do:
zmrestore -a user@domain.com -lb full6monthsago
- It will playback the incremental data associated with that full from 6 months ago.
- If you do:
zmrestore -a user@domain.com -lb full6monthsago -rf
- It will ONLY playback the data in the full from 6 months ago.
- If you do:
- Will not progress past the data that's in the last full backup, no incremental backups after it in other words.
- Implies NO redolog play, so there's no need to use -br.
- The default behavior of zmrestore in general is to always play from a "full" and "incrementals" that are associated with it UNLESS you state otherwise.
- Restores to the full backup only, not any incremental backups since that backup.
Targets And Labels
- --label or -lb
- <arg> The label of the full backup to restore. Restores to the latest full backup if this is omitted.
- --target or -t
- <arg> Specifies the backup target location. The default is <zimbra_home>/backup.
Impact Of AutoGroup Option Being Used
Place for notes about how autogroup backup option might impact or limit command options.
zmbackup Options
Problems mostly revolve around these options:
- --target or -t
- <arg> Specifies the target backup location. The default is <zimbra_home>/backup.
- --zip or -z
- Zips email blobs in backup - using compression
- --zipStore
- Zips email blobs in backup - does NOT use compression
Deleting Old Backups -del
Caution You want to delete from the oldest label to newest. The -del option will automatically purge all older sessions prior to the label you used. To find out the label names, use zmbackupquery.
Format example:
zmbackup -del <oldest_backup_label>
Impact Of AutoGroup Option Being Used
Place for notes about how autogroup backup option might impact or limit command options.
Changing Default Backup Target
To find out what the current backup target is, do:
zmprov gacf | grep zimbraBackupTarget zimbraBackupTarget: /opt/zimbra/backup
This is also configurable at the "server" level:
zmprov gs `zmhostname` | grep zimbraBackupTarget zimbraBackupTarget: /opt/zimbra/backup
For example:
zmprov ms `zmhostname` zimbraBackupTarget /san/mount/backup
Issues of changing the default path in regards to the admin web console. Please see:
- "Work backup path if it was changed in admin interface"
Another way to change the backup path is described at Changing_Backup_directory_and_General_Information. I recommend reviewing it as well.
See Change Location For Backup Or Restore Source Data for non-default adjustments to CLI commands in regards to a non-default path for backups.
RFE & Bugs Concerning Option Flags For Restore And Backup
Setting Account Status After Restore Is Done
I filed an RFE for this:
- "RFE: zmrestore & zmrestoreoffline have option to set account status"
Use DL COS Status To Generate User List Of Accounts
I filed an RFE for this:
- "RFE: backup/restore should allow -a option to use DL's COS Status"
An Overview Of Some Backup/Restore Items
I believe we are a little light on describing the shared blobs situation. Shared blobs can cause different corrections to a problem as compared to a normal message issue that isn't shared. I'll start some notes on this here.
From Backup and Restore
- "When backing up shared messages, the backup process looks to see whether a Binary Large Object file (BLOB) representing a message already exists in the backup. If it does, it simply flags this object as such and does not copy its content again."
- "Keeping the same backup target saves disk space, because shared binary large object files (BLOB) and other files do not have to be duplicated every time the backup process runs.
Bugs/RFE's
- "Use zip files for shared blobs of a full backup made with --zip option"
Remote copies of backup data for DR use
You will want to copy over /opt/zimbra/redolog/archive/* and /opt/zimbra/redolog/redo.log frequently in order to stay current. The redo.log file being open is not a problem since the crash recovery step can work with redo.log file in any state.
The redolog/archive/ contains logs that have not yet been backed up by an incremental (or by a full in auto-grouped mode)
The redo.log rolls over when it reaches zimbraRedoLogRolloverFileSizeKB (by default 100MB prior to ZCS 5.0.11 and 1GB after). When ZCS restarts after a crash, it seems to work through the current redo.log ok regardless of its state, if the current log really must be copied."
My Initial Thoughts On This
Start of process:
- Weekend full on prod
- rsync full-xxx on prod > remote sessions/
- rsync redolog/* > remote redolog/
- through non-full and incremental times every x about of minutes
- weekday nights 10pm incre-xxx on prod
- rsync incr-xxx on prod > remote sessions/
- rsync redlog/* > remote redolog/
Created three separate rsync cron rules.
- Full - once a week
- Confirms full is done and then looks for latest full-xxxx and rsyncs that specific directory
- Incre - once a night except for full schedule night
- Confirms incre is done and then looks for latest incr-xxx and rsyncs that specific directory
- Redolog/ - every x amount of minutes (outside of full and incr backups sessions)
- Soes full rsync of redolog/ - probably want delete/remove option?
- lsof will report /opt/zimbra/redolog/redo.log is open.
Somewhere we need to account for accounts.xml in this process. And also confirm what else might be missing. Also, steps on the actually restore process depending on when/where the DR event took place.
What's Needed For Later Restores
In regards to what is moved and what is needed for later restores, you must remember this "flow" of the backups:
- Full backup files that contains all the information needed to restore mailboxes (to that point in time)
- Incremental backup files that contains the LDAP directory server files and all the redo log transactions written since the last backup (to that point in time)
- Redo logs that contains current and archived transactions processed by the Zimbra server since the last incremental backup (to that point in time - more about this topic is above)
Variables to be aware of in regards to backup/restore [ viewed with - zmprov gs [server-name] | grep Backup ]:
- This is that gui path option - note, it doesn't change default to redo file path [see below]
zimbraBackupTarget zimbraBackupMode zimbraBackupAutoGroupedInterval zimbraBackupAutoGroupedNumGroups zimbraBackupAutoGroupedThrottled zimbraBackupReportEmailSubjectPrefix zimbraBackupReportEmailSender zimbraBackupReportEmailRecipients
- Variables to be aware of in regards to redo files [ viewed with - zmprov gs [server-name] | grep Redo ]:
zimbraRedoLogArchiveDir zimbraRedoLogDeleteOnRollover zimbraRedoLogEnabled zimbraRedoLogFsyncIntervalslMS zimbraRedoLogLogPath zimbraRedoLogRolloverFileSizeKB
Mysql Table That References Most Recent Backup Session Of Users (AutoGroup Backup Mode)
During the backup we update the zimbra.mailbox table for each mailbox to record the most recent backup time. This is in the "last_backup_at" column within Mysql.
This data is used by auto-grouped backup to figure out which mailboxes to backup.
Creating A List Of Last Backup Of Users
Remove the , | head , below to get a full listing of all your accounts. Note, this reports on the users that exist on the mailstore your running the command.
[zimbra@zcs806 tmp]$ mysql zimbra -NBe 'select from_unixtime(last_backup_at), comment from mailbox' | sort | head 2014-06-05 01:00:24 dluser558@zcs806.DOMAIN.com 2014-06-05 01:00:26 dluser557@zcs806.DOMAIN.com 2014-06-05 01:00:28 dluser556@zcs806.DOMAIN.com 2014-06-05 01:00:30 dluser555@zcs806.DOMAIN.com 2014-06-05 01:00:31 dluser554@zcs806.DOMAIN.com 2014-06-05 01:00:32 dluser551@zcs806.DOMAIN.com 2014-06-05 01:00:32 dluser552@zcs806.DOMAIN.com 2014-06-05 01:00:32 dluser553@zcs806.DOMAIN.com 2014-06-05 01:00:33 dluser550@zcs806.DOMAIN.com 2014-06-05 01:00:34 dluser549@zcs806.DOMAIN.com
I include also below the results from the zmbackupquery for the first user:
[zimbra@zcs806 tmp]$ date ; zmbackupquery -a dluser558@zcs806.DOMAIN.com
Wed Jun 11 14:29:48 PDT 2014
Account: dluser558@zcs806.DOMAIN.com
Label: full-20140605.080023.296
Type: full
Started: Thu, 2014/06/05 01:00:23.296 PDT
Ended: Thu, 2014/06/05 01:02:37.739 PDT
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555
Label: full-20140529.080016.546
Type: full
Started: Thu, 2014/05/29 01:00:16.546 PDT
Ended: Thu, 2014/05/29 01:02:51.556 PDT
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555
Label: full-20140522.080015.818
Type: full
Started: Thu, 2014/05/22 01:00:15.818 PDT
Ended: Thu, 2014/05/22 01:02:42.126 PDT
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555
Label: full-20140515.080016.160
Type: full
Started: Thu, 2014/05/15 01:00:16.160 PDT
Ended: Thu, 2014/05/15 01:02:34.204 PDT
Acct ID: 85d3c8f4-eea8-4cf2-8a84-8f1fcc87d555
Possible Issue That A Failed Or Interrupted Backup Causes
An interrupted backup can cause an issue because the table currently gets updated right off the bat rather than waiting for backup to be successfully completed.
Possible RFE: To update zimbra.mailbox.last_backup_at column for successfully backed-up mailboxes to the very end of the backup process, to either just before or just after renaming the /opt/zimbra/backup/tmp/<backup label> directory to /opt/zimbra/backup/sessions/<backup label>.
Setting To Null To Cause A New Backup For User
To undo what was done by an interrupted backup for example, you need to clear this column (set it to null) for the affected mailboxes. By clearing the column, you're forcing the next AG backup to choose these mailboxes because they look like they have never been backed up. If you don't clear this column, you have to wait until the next cycle. (7 days)
Example syntax to view:
mysql zimbra -e "select last_backup_at from mailbox where id=27"
Example syntax to change data of the last_backup_at to NULL"
mysql zimbra -e "UPDATE mailbox SET last_backup_at = NULL WHERE id = 27"
Related Bugs RFE's
- "In auto-grouped backup, delay the update of mailboxes' last_backup_at timestamp to the very end of backup"
- "Partial backup should be able to finish successfully when backup volume runs out of space"
Restore Requires accounts.xml File
- "accounts.xml file dependency needed for zmrestore"
Also, see:
- "accounts.xml file improperly updated when a full backup is deleted"
Change "Location" For Backup Or Restore Source Data
Remember that zmbackup and zmrestore can take flags as well in regards to the location of items.
- zmrestore & zmbackup can both