2014-05-20 05:05 AM - edited 2015-12-18 01:09 AM
My client wants a copy of one of the Oracle_DB which is 10TB with which they want to setup a Test DB is it possible if i snapmirror all the Oracle DB Volumes and map them to the Test server where they can up the DB ( I need to confirm this part ) and use it as Test DB ?? Is the DB will be Consistent ?? Please Need Advise.
2014-05-20 06:38 AM
Yes. Use SnapManager for Oracle or Netapp plugin for RMAN (https://communities.netapp.com/docs/DOC-33477) to do the Consistent backup and protect it using Snapmirror, then you can clone the db from the protected snapshot from secondary volume.
2014-05-21 11:04 AM
Question - you say "volumes". If the database exists across more than one volume, this can get more complicated. The simplest approach is to generate a cg-snapshot of all the volumes. You can do this with the SnapDrive utility, SnapCreator, or a simple script. Once you have this, you can easily snapmirror this set of snapshots anywhere you want. If you can match the directory structure of the source, then you can just start the database. It will have the same name as the original, but if that's okay then this is a VERY easy way to spin up a clone.
2014-06-03 02:46 AM
You’ll have to do quite a bit of scripting. The problem with LDOM’s is they essentially re-virtualize LUNs as Sun LUN’s. It hides the source of them. You can do this with SnapCreator, but you’d have to write some scripts that map and unmap the LUNs through the LDOM.