This post is more than 5 years old
19 Posts
0
721
Snapshot Technology
Hi All,
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.
Thanks in advance,
Baskar.l
ble1
2 Intern
2 Intern
•
14.3K 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
2 Intern
2 Intern
•
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
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
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
2 Intern
2 Intern
•
20.4K Posts
0
March 13th, 2013 08:00
exactly
ble1
2 Intern
2 Intern
•
14.3K Posts
0
March 13th, 2013 08:00
You can create multiple snapshots too. In PowerSnap's pool file you define relationship for those.
Baskarl
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