Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Experts,
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.
Thanks,
Nayab
9 REPLIES 9
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Regards
Karthikeyan.N
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My Storage is via FC and i can see the plugin supports only NFS protocol and also im using ASM in my environment again which is not supported by Plugin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
With FC+ASM you’ll need SnapManager for Oracle. This is a standard capability of that product.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry we are using Oracle LDOMS as well so Snapmanager will not work with Oracle LDOMS... Any
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have any snap creator scripts handy ??? I really want to do this but the place where im struck in at scripts im not a Scripting Geek sorry.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I’ve never scripted any LDOM work before, plus the need to re-write ASM headers makes this even more difficult. I don’t see a good option here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Nayab,
Please let us know if you have any more questions.
Thanks!
-Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.