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
4 Operator
•
14.4K Posts
0
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.
dynamox
9 Legend
•
20.4K Posts
1
March 13th, 2013 04:00
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.
Baskarl
1 Rookie
•
19 Posts
0
March 13th, 2013 07:00
Hi ,
Thanks a lot for information. Those multiple snapshots and snapping twice a day, is that the same mentioned in http://www.emc.com/collateral/software/white-papers/h5635-timefinder-snap-multiple-snapshots-wp.pdf “Creating multiple rolling point in-time restartable database images” or any other document?
Baskar.l
Baskarl
1 Rookie
•
19 Posts
1
March 13th, 2013 07:00
Hi Hrvoje,
Thanks a lot for the information. Is that integrating with Power Snap module also takes multiple snapshots?
baskar.l
dynamox
9 Legend
•
20.4K Posts
0
March 13th, 2013 08:00
exactly
ble1
4 Operator
•
14.4K Posts
0
March 13th, 2013 08:00
You can create multiple snapshots too. In PowerSnap's pool file you define relationship for those.
Baskarl
1 Rookie
•
19 Posts
0
March 13th, 2013 08:00
Hi Dynamox,
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.
baskar.l