8.2. Microsoft vShadow Transaction Consistent Database Cloning to the same server

You might get into the situation where you have to quickly clone your production database to the same server for some release management. In most situations, you will not be able to take that database down, neither have the time to do backup & restore so online transaction consistent database cloning will be a great tool for you. The capability of IBM VDS & DS8000 FlashCopy & vShadow with a bit of scripting can provide you with just that. Below is a small batch file with explanation which can do just that.

==============Fcm2.bat================

del bc1.xml sc1.cmd

C:\fcm2\vshadow.exe -p -t=bc1.xml -script=sc1.cmd y:

echo c:\fcm2\fcmmount.bat >> sc1.cmd

c:\fcm2\vshadow -i=c:\fcm2\bc1.xml

c:\fcm2\sc1.cmd

===============================

===========fcmmount.bat==========

c:\fcm2\vshadow -el=%SHADOW_ID_1%,D:\mytest

c:\fcm2\vshadow -bw=%SHADOW_SET_ID%

====================================

In order for the script above to work you have to create the two batch files with the same names shown above each. In addition, you will have to put them in the folder c:\fcm2 with the vshadow executable.

The above batch files will delete the old parameters files, then will create a transportable shadow copy of the LUN for Drive Y:. It will import the Y: Drive FlashCopy as a mount point called mytest under the D:\ drive. As soon the batch file finish executing you will be able to mount the database under a different name. The whole process can finish in just few minutes compared to many hours, when using traditional methods.

Please if you have any problems using the above scripts, leave me a comment & I will be more than happy to follow up on it.

:

Back to: IBM Tivoli Storage FlashCopy Manager Tutorial Index





Leave a Reply