zmrestore restoreToTime problem

[magsuser2007]

Hi All,

I am having trouble using zmrestore to restore mailboxes to a certain point in time.

The redolog file is as follows:

-rw-r----- 1 zimbra zimbra 2035998 Aug 27 10:41 redo-20070827.154151.000-seq0.log

I tried many different times, but still missing some emails which were received after the last backup. Some tries:

zmrestore -s zimbra.server.com -a user@zimbra.server.com -restoreToTime 20070827.104151.000

zmrestore -s zimbra.server.com -a user@zimbra.server.com -restoreToTime 20070827.154151.000

However, it works if I use:

zmrestore -s zimbra.server.com -a user@zimbra.server.com -restoreToRedoSeq 0

Thanks,

[mmorse]

They have 'zimbra' in their email address fqdn?

zmrestore -s zimbra.server.com -a user@zimbra.server.com -restoreToRedoSeq 0

Or are you playing on a test box?

I know your not saying it errors out, but let's try with quotes on the end and a double -- (can do either after 4.5.4?)
zmrestore -s zimbra#.wiu.edu -a user@wiu.edu --restoreToTime '20070827.104151.000'

As a side test-what happens if you put the time as that of the incremental (using restoreToTime). Does that act the same as your restoreToIncrLabel?

Date formats:
20070827.104151.000
20070827.104151
20070827104151000
20070827104151
2007/08/27 10:41:51 000
2007/08/27 10:41:51
2007/08/27-10:41:51-000
2007/08/27-10:41:51

Don't forget that you can move the restore to another account: (in this case it will be restoredmailuser@wiu.edu)
zmrestore -s zimbra#.wiu.edu -ca -pre restoredmailuser -a user@wiu.edu -restoreToRedoSeq 0

FYI: After you perform any of the following point-in-time restores, you should immediately run a complete backup for those accounts to avoid future restoration problems with those accounts. (Of course when you do that I'll go through all the redo logs so be sure you got any necessary full/incremental/redo logs moved to a safe place)

[mmorse]

Kinda related in case you were attempting incremental restores in your ?testing? process. (Unless you really have 'zimbra' in your domain name and this is a live box; then I encourage you to open a support request.)

There's an extra 'e' in some of the docs-it should be 'Incr' not 'Incre' in restoreToIncrLabel.

I just filed:
Bug 19744 - restoreToIncrLabel (not restoreToIncreLabel)

[magsuser2007]

Hi,

The -- did not work, it is expecting one dash

The single quote did not make any difference. In fact whether or not I put single quotes it prints the following after I issue the zmrestore command:
"using restore to time of 2007/08/27 10:41:51 000"

Which means that it thinks that it is restoring to this time but it is not!!!


PS. Thanks for the restoreToIncrLabel bug

[mmorse]

Maged Messeh,

Can you verify if the incrememtals are working properly?
ie: create account, put some mail in it, run a full backup, send it some more mail (remember the content), do an incremental(#1), delete that mail, run another incremental(#2), do whatever for a bit, then run -restoreToIncrLabel on the first incremental.

Yes I know this is not the end goal, but what happens if you put the exact time of the incremental in restoreToTime? Does that act the same as your restoreToIncrLabel?
zmrestore -s zimbra#.wiu.edu -a user@wiu.edu -lb full-200708etc -ca -pre restore -restoreToTime 'put in time of incremental here'

Play with putting -br on the end of that to see if it forces use of the backup's redo logs only so your not even remotely messing with current redologs.

If this is on a test machine with a few users (else it'll be one large blob of data)-give us the output of the following at stragetic points in your testing:
zmbackupquery -v
ls -l /opt/zimbra/redolog
(of course be sure to let us know when those are taken)

---
You need to use the -lb argument to specify a full that takes place prior to the date of the time you want to restore to, as fulls after the date wouldn't have the incrementals/redologs to the prior time.

Created: CLI zmrestore restoreToTime Network Edition only - Zimbra :: Wiki

[bobby]

mmorse shows the answer in the last post: make sure to specify (with the -lb,--label option to zmrestore) the last full backup before the time to which you are restoring.