What would be the best way to get snapvault to move a snapshot from the primary that's not created on an hour boundary? We're putting our DB into hot backup mode at 9:05 and I don't want to make the DBA change his scripts if possible, is there a way (maybe with rsh+cron) that I can manually create a snapshot at 9:15 and then use snapvault to transfer it?
Please be advised that this email may contain confidential information. If you are not the intended recipient, please do not read, copy or re-transmit this email. If you have received this email in error, please notify us by email by replying to the sender and by telephone (call us collect at +1 202-828-0850) and delete this message and any attachments. Thank you in advance for your cooperation and assistance.
In addition, Danaher and its subsidiaries disclaim that the content of this email constitutes an offer to enter into, or the acceptance of, any contract or agreement or any amendment thereto; provided that the foregoing disclaimer does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment to this email.
snapvault snap sched MYVOL sv_daily 7@-
now your script can execute the snapvault snap command whenever you want. you can either have snapvault automatically pick it up on a later schedule or also have the script initiate a snapvault update at the end of the hotbackup script.
--daniel
-- Daniel Leeds Manager, Storage Operations Edmunds, Inc. 1620 26th Street, Suite 400 South Santa Monica, CA 90404
310-309-4999 desk 310-430-0536 cell
-----Original Message----- From: owner-toasters@mathworks.com on behalf of Page, Jeremy Sent: Wed 12/10/2008 8:24 AM To: toasters@mathworks.com Subject: Snapvaults schedules not at the top of the hour
What would be the best way to get snapvault to move a snapshot from the primary that's not created on an hour boundary? We're putting our DB into hot backup mode at 9:05 and I don't want to make the DBA change his scripts if possible, is there a way (maybe with rsh+cron) that I can manually create a snapshot at 9:15 and then use snapvault to transfer it?
Please be advised that this email may contain confidential information. If you are not the intended recipient, please do not read, copy or re-transmit this email. If you have received this email in error, please notify us by email by replying to the sender and by telephone (call us collect at +1 202-828-0850) and delete this message and any attachments. Thank you in advance for your cooperation and assistance.
In addition, Danaher and its subsidiaries disclaim that the content of this email constitutes an offer to enter into, or the acceptance of, any contract or agreement or any amendment thereto; provided that the foregoing disclaimer does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment to this email.
If you are using Snapdrive for Windows v5 or higher, the snapshot and snapvault operations can be done via the sdcli command interface. Otherwise you can use rsh. This is how we backup our Oracle databases every day. We 'recycle' a set of snapshots for daily backups.
1. Delete snapshot sd_daily.1 on all volumes used for the database
2. Rename snapshot sd_daily.0 to sd_daily.1
3. Put database in hot backup mode
4. Create snapshot name sd_daily.0 on all database volumes except the archive log volume
5. Take database out of hot backup mode
6. Create snapshot named sd_daily.0 on archive log volume
7. Snapvault update the database volumes from sd_daily.0
This method guarantees a snapvault update immediately following the snapshots rather than waiting for some specified time. We then use rsh to do a snapvault status on the destination every couple of minutes to determine when the snapvault update has completed transfer so we can then take a snapshot on the snapvault destination and also trigger an ndmp tape backup that gets removed to a fireproof safe every day.
Since we use Snapdrive for Windows, there is also a snapmirror update triggered whenever we take a snapshot.
Looks like you are probably using Linux/Unix. I know NetApp has Snapdrive for that platform, but I am unfamiliar with it to know what interface it may provide. However, every step I have outlined above can be performed via rsh.
From: owner-toasters@mathworks.com [mailto:owner-toasters@mathworks.com] On Behalf Of Page, Jeremy Sent: Wednesday, December 10, 2008 11:24 AM To: toasters@mathworks.com Subject: Snapvaults schedules not at the top of the hour
What would be the best way to get snapvault to move a snapshot from the primary that's not created on an hour boundary? We're putting our DB into hot backup mode at 9:05 and I don't want to make the DBA change his scripts if possible, is there a way (maybe with rsh+cron) that I can manually create a snapshot at 9:15 and then use snapvault to transfer it?
Please be advised that this email may contain confidential information. If you are not the intended recipient, please do not read, copy or re-transmit this email. If you have received this email in error, please notify us by email by replying to the sender and by telephone (call us collect at +1 202-828-0850) and delete this message and any attachments. Thank you in advance for your cooperation and assistance.
In addition, Danaher and its subsidiaries disclaim that the content of this email constitutes an offer to enter into, or the acceptance of, any contract or agreement or any amendment thereto; provided that the foregoing disclaimer does not invalidate the binding effect of any digital or other electronic reproduction of a manual signature that is included in any attachment to this email.
-
Holland, William L -
Leeds, Daniel -
Page, Jeremy