Greetings of the day. Hope everyone is doing great. We are using EMC storage , VMAX for our production, stage, dev databases. Size of the database range from 500G to few Terabytes.
Right now we are using RMAN backups to backup these databases . A level 0 backup on sunday and incremental backup on week days.
Need info/guidance of snapshot technology available in EMC , which can reduce our backup timings , restore/recover to dev and stage databases.
You can use SM/Mirror or SM/Clone to make backups using snapshots. If using backup software, like EMC NetWorker, you can integrate this with PowerSnap module. I, for example, use this to protect database (SAP and Oracle) ranging from 400GB to 12TB.
i assume you are talking about array based snapshot technologies. If you are licensed for Timefinder/SNAP you can perform multiple snapshots of source devices and use them for quick recoveries. For example our big Oracle PeopleSoft database get's snapped twice a day , for 7 days. If corruption occurs we can always use snapshots to go back to previous version and then use archive logs to roll the database forward to specific time.
Thank You. Just to understand more operationally, is that those multiple snaps taken in a day are full snap of the database?? Or is that something incremental snaps too available?
Is there any benchmarks as how much time it takes to take a snap of big database say 15TB , and time to restore/recover the same for test and dev databases.
ble1
6 Operator
•
14354 Posts
•
56186 Points
496
0
Posted March 13th, 2013 02:00
You can use SM/Mirror or SM/Clone to make backups using snapshots. If using backup software, like EMC NetWorker, you can integrate this with PowerSnap module. I, for example, use this to protect database (SAP and Oracle) ranging from 400GB to 12TB.